Laserfiche WebLink
Appendix B <br />Data Directory for Aquifer Property Data in HydroBase <br />Table Name: iNELLS Task: Task 42, 43 and 44 of the SPDSS <br />aquifer2 If well is located in two aquifers, name of second aquifer. <br />aquifer comment Any comments associated with the aquifer(s) that the well transverses. <br />tperf Depth to top of first perforated casing. (FEET) <br />bperf Depth to base of last perforated casing. (FEET) <br />field Actual pumping rate. (GPM) <br />bedrock elev Elevation of bedrock. <br />sat_1965 <br />remarksl Generic remarks. <br />remarksl Generic remarks. <br />owner Owner's fullname. <br />address Address of owner. <br />cit City. <br />st State abbreviation. <br />zip Zip code. <br />phone Phone number. <br />cell_ hone Cell phone number. <br />email E-mail address or Internet address. <br /> <br />collection_order Water level collection number. Used to indicate route to gather WL <br />measurements. <br />data_source_id A unique identifer of the data. Either the Site_ID or the locnum string. <br />data source Source of data. <br />publish? Boolean indicating if well is part of DWR's water level publications. <br />eoplo ? Boolean indicating if well is part of DWR's geophysical log archive. <br />modified Date the record was last modified. <br />user User who last modified the record. <br />cdm_id TEMPORARY - Identifer originally given to well by CDM in SPDSS project. <br />cmd_modified TEMPORARY -Date the record was last modified by CDM. <br />Table Name: PUMPING TEST Task: Task 43 of the SPDSS <br />Description: Table containin aquifer h draulic properties test results. <br />Field Name Field Descri tion <br />pump_test_num Unique pump test identifier. <br />well_id Well identifier. Foreign key from [wells]. <br />testdate Date of the pump test. <br />to testint Top of tested interval (FT). <br />basetestint Base of tested interval (FT). <br /> <br /> <br />tswl Pre-test static water level measured in feet from ground level. <br />Pressure head above ground level is given as a negative <br />value. <br /> <br /> <br />tfwl Post-test final water level measured in feet from ground <br />level. Pressure head above ground level is given as a negative <br />value. <br /> <br /> <br />drawdown Change in feet between pretest water level and end of test <br />water level. Pressure head above ground level is given as a <br />ne ative number. <br /> <br />testq Average testing discharge rate measured in gallons per <br />minute. <br />SPDSS Phase 2 Task 43.2 TM -Final <br />2/13/2006 B-2 <br />