Laserfiche WebLink
Appendix A <br />Development of the Phase 2 Task 43.2 Aquifer Properties Data Set <br />1.0 Purpose/Objective <br />To document the procedure used to query aquifer properties data from HydroBase, <br />merge the data with Task 37 data and Phase 11ab data, and to process all the data for the <br />Phase 2 Task 43.2 analysis. <br />Explanation of Formatting used below: <br />1. Noun: the name of a HydroBase table <br />2. "Noun': the name of a field in a table <br />3. 'Noun :the name of a value for a field <br />2.0 Procedure/Approach <br />A. Sources of Data <br />1. In the August 2005 version of the HydroBase database transmitted to <br />CDM by the DWR, Wells and Pumping test tables were linked up in a <br />select query using the "well_id" field. Selected fields were chosen <br />from the Wells table (well id, permit number, location information, <br />etc.) and all fields were chosen from the Pumping test table, which <br />contains information pertinent to aquifer hydraulic properties testing <br />results. Records where "aquiferl" _ 'QAL' were excluded from the <br />select query to limit the query to bedrock aquifer data. <br />2. Solicited, Field, and Specific Capacity test data were obtained from <br />the SPDSS Phase 2 Task 37 TM. <br />3. Lab data from Phase 1 of Task 43 that were not included in <br />HydroBase were also obtained. These data points were excluded <br />from the Phase 1 data added to HydroBase because from one <br />borehole, samples were collected from multiple depths and multiple <br />aquifers. This type of data was not suitable for the HydroBase <br />format. <br />4. The three sources of data, HydroBase, Task 37, and Phase 1 Lab data, <br />were merged into one full data set using the HydroBase format. Two <br />additional fields were added to the Pumping test table format to <br />accommodate the P11ab data, "pt_aquiferl" and "pt_aquifer2". <br />These fields are necessary to identify which aquifer a lab sample <br />represents when the lab sample is from an aquifer other than that in <br />which the well is completed, as indicated by the "aquiferl" and <br />"aquiferl" fields. <br />B. Data Exclusions <br />Data were excluded from the Phase 2 Task 43 TM analysis for a variety of <br />reasons, which are listed below. Excluded data are shown in Table A-1 at the <br />end of this appendix. Table A-1 shows HydroBase records that were excluded <br />from analysis in Phase 2, and does not include any data collected under Phase 2 <br />of the SPDSS project that were identified for exclusion. <br />SPDSS Task 43.2 TM- Final A-1 <br />02/13/06 <br />