Well Inventory Database – Data Dictionary

Back to Well Inventory Database


Well Inventory Database Data Dictionary
COLUMN CODES USED DEFINITION
WELLKEY"DPR assigned security key used for public distribution of well information. DPR does not release exact geographical information for wells but does release township/range/section information. Therefore, the WIWELLKEY.WELL_KEY becomes the unique identifier for any public or private agency requesting data."
COMTRS"County-Meridian-Township-Range-Section. This field is a used for GIS-type applications and is an eleven character concatentation of: CO-A two-digit character field specifying the county where the well is located. M-Meridian (H, M, S) where the section grid is based. TRS-The Township, Range, and Section where the well is located."
RANDLAT"A nine digit field with 6 decimal places specifying the north/south geographic position of the well in degrees and decimal format. This field is a randomized estimated value based on the township, range, section, and tract of the well. "
RANDLONG"A nine digit field with 6 decimal places specifying the east/west geographic position of the well in degrees and decimal format. This field is a randomized estimated value based on the township, range, section, and tract of the well."
CHEMNUMBERA DPR-assigned five digit numeric field specifying the chemical analyzed.
CHEMNAMEA chemical name associated with the chemical number.
CONC"A nine digit numeric field with three decimal places. The chemical concentration is the amount in parts per billion (ppb) of a chemical. For example, both 0.05 and 12.005 are valid. Concentrations cannot be negative. Non-detect, trace, and concentrations reported that are below the screening level can be coded as zero, ‘0’. If known, actual values for trace reports may be listed. Estimated values below and above the screening level are reported as the value with an “E” in the Status."
SL"This field specifies the Screening Level concentration (ppb) for the analytical lab and method for each analysis. It is coded the same way as the chemical concentration field (CONC). This is normally the level (MDL, LRL, RL, etc) reported with the data but may be a standardized screening level (for the Groundwater Protection Program at CDPR)."
AGENCYA DPR-assigned four digit field with a character code specifying the agency that performed the study.
AGENCY_ACRONAn acronym of the agency name associated with the AGENCY code.
AGENCY_ACRONAECONAmerican Environmental Consulting Firm
AGENCY_ACRONCDPHCalifornia Department of Public Health (previously the Department of Health Services (DHS))
AGENCY_ACRONCGYCiba-Geigy
AGENCY_ACRONCRWQCB1California Regional Water Quality Control Board-Region 1
AGENCY_ACRONCRWQCB2California Regional Water Quality Control Board-Region 2
AGENCY_ACRONCRWQCB3California Regional Water Quality Control Board-Region 3
AGENCY_ACRONCRWQCB4California Regional Water Quality Control Board-Region 4
AGENCY_ACRONCRWQCB5California Regional Water Quality Control Board-Region 5
AGENCY_ACRONCRWQCB6California Regional Water Quality Control Board-Region 6
AGENCY_ACRONCRWQCB8California Regional Water Quality Control Board-Region 8
AGENCY_ACRONCRWQCB9California Regional Water Quality Control Board-Region 9
AGENCY_ACRONCSWRCBCalifornia State Water Resources Control Board
AGENCY_ACRONCSWRCBDWPCalifornia State Water Resources Control Board-Drinking Water Program (took over reporting from CDPH)
AGENCY_ACRONCWSCalifornia Water Service
AGENCY_ACRONDAVCYCity of Davis
AGENCY_ACRONDPRCalifornia Department of Pesticide Regulation
AGENCY_ACRONDWRCalifornia Department of Water Resources
AGENCY_ACRONFRECOFresno County
AGENCY_ACRONGLECOGlenn County
AGENCY_ACRONIMPCOImperial County
AGENCY_ACRONKERCOKern County
AGENCY_ACRONLAKCOLake County
AGENCY_ACRONMADCOMadera County
AGENCY_ACRONMARCOMariposa County
AGENCY_ACRONMODCOModoc County
AGENCY_ACRONOCNSDCYCity of Oceanside
AGENCY_ACRONRIVCORiverside County
AGENCY_ACRONRPAGRhone-Poulenc Ag Co.
AGENCY_ACRONSACCOSacramento County
AGENCY_ACRONSBCOSanta Barbara County
AGENCY_ACRONSCCOSanta Clara County
AGENCY_ACRONSCVWDSanta Clara Valley Water District
AGENCY_ACRONSDCOSan Diego County
AGENCY_ACRONSFCYSan Francisco County
AGENCY_ACRONSLOCOSan Luis Obispo County
AGENCY_ACRONSMCOSan Mateo County
AGENCY_ACRONSOLIDSolano Irrigation District
AGENCY_ACRONSTKESJWCDStockton-East San Joaquin Water Conservation District
AGENCY_ACRONSUTCOSutter County
AGENCY_ACRONUSBLMUnited States Bureau of Land Management
AGENCY_ACRONUSDAUnited States Department of Agriculture
AGENCY_ACRONUSEPAUnited States Environmental Protection Agency
AGENCY_ACRONUSFSUnited States Forest Service
AGENCY_ACRONUSGSUnited States Geological Survey
AGENCY_ACRONYOLCOYolo County
AGENCY_ACRONYUBCOYuba County
SDATE"A date field used to note the date the sample was taken. The complete sample date is coded using characters in the format DD-MON-YYYY. For example, July 1, 1996 would be 01-JUL-1996. If the sampling date is incomplete (e.g. July, 1996) the information is in the NOTES field (SAMPLED JULY 1996, NO DATE). This reserves the SDATE column for complete dates. "
STYPEA one character field with a character code specifying descriptive analytical information for each analysis based on all the analytical results for a particular well and chemical during that study.
STYPE-Not specified.
STYPEAAveraged result.
STYPEB"Initial detection sample with further qualitative or quantitative analyses, all negative results."
STYPECInitial detection sample confirmed by data source agency.
STYPED"Split sample: method-different, lab-different."
STYPEE"Split sample: method-same, lab-different."
STYPEF"Split sample: method-different, lab-different."
STYPEG"Split sample: method-same, lab same."
STYPEH"Replicate sample: method-different, lab-same."
STYPEIInitial detection not confirmed.
STYPEJ"Replicate sample: method-different, lab-different."
STYPEK"Replicate sample: method-same, lab-different."
STYPEL"Replicate sample: method-same, lab-same."
STYPEMInitial detection sample qualitatively confirmed.
STYPENSingle non-detected.
STYPEOSingle result.
STYPEPInitial detection with further quantitative and qualitative analyses.
STYPEQInitial detection sample with further analyses.
STYPERRoutine ongoing.
STYPESSplit sample.
STYPETInitial detection sample analyzed for multiple compounds.
STYPEUUnconfirmed detection sample.
STYPEVUnequivocal detection method used.
STYPEXNegative detection sample.
STYPEY"Split replicate: sample method-same, lab-different."
STATUS"A one digit field used to describe specific criteria of an analytical result based on the study, well, chemical, and summary year. This field is used to determine ‘verified’ detections. Verified detections have (AGENCY=‘4323’ and STATUS=‘P’) or STYPE = ‘V’. "
STATUSEEstimated or quantified trace value reported by reporting agency.
STATUSNNon-detect (concentration=0).
STATUSPConfirmed detection (2 or more positive detections during the same study/well/chem/report year) or wells where the stype is ‘V’.
STATUSRData was marked as preliminary by the reporting agency at the time the data was loaded into the Well Inventory.
STATUSUUnconfirmed detection (only 1 positive detection during the same study/well/chem/report year).
STATUSVPositive detection analyzed using a DPR-approved unequivocal method.
STATUSXPositive detection analyzed before 1987.
RESIDUE_SOURCEDPR evaluation of the source of the pesticide contamination
RESIDUE_SOURCE-No detection
RESIDUE_SOURCENON POINTResidues are not from local well contamination but are most likely due to agricultural use of the pesticide.
RESIDUE_SOURCEPOINT_SOURCE"Residues are from local contamination of the well. For example, pesiticide spills around the well head. These records are not included in this dataset."
RESIDUE_SOURCEPOINT_SOURCE_CON"Residues are from direct contamination of the well. For example, surface water or chemigated water spilling into the well. These records are not included in this dataset."
RESIDUE_SOURCEUNDER_INVESTIGATIONDPR is investigating to determine the source of the reported pesticide residue.
LABCode for the laboratory analyzing the well samples. The translation table for this code is available on request.
ADATEThe analysis date for the well sample in DD-MMM-YYYY format. Not all datasets include this information.
APFILELetter Code for the individual study for which the samples were collected. This is generally assigned by DPR and may refer to an entire dataset received in a given year.
COUNTYCalifornia county name where the sampled well is located.
WELLCODELetter Code for the type/main use of the well sampled. This code will corrispond to the WELLTYPE text field.
WELLTYPE"Short text description of the type/main use of the well sampled. For example: IRRIGATION, DOMESTIC, LARGE WATER SYSTEM, SMALL WATER SYSTEM, COMMUNITY."
DEPTHThe reported depth of the well in feet. DPR does not have any construction data for most of the wells in its database.
TPERFTop of Perforations. The reported depth to the to of the first casing perforations (where the well starts collecting water) in feet.
BPERFBottom of Perforations. The reported depth to the to of the last casing perforations (where the well stops collecting water) in feet.
DETECT_STATUS"Code for DPR's plan, evaluation, or response to a reported detection."
DETECT_STATUSANPHUAccepted Non-Point Source from Historical Use. Many Southern California wells have reported detections of 6800a/degradate pesticides due to pre-1985 use.
DETECT_STATUSCIDConfirmed or Verified Isolated Detection. At least two detections of a pesticide in different wells within a mile are normally required to make an agricultural use determination.
DETECT_STATUSDCNP"Degradate Confirmed with No Parent. Previously, DPR would only respond to detections of certain parent chemicals, not the degradates unless the degradates were found at harmful levels. That policy has been changed."
DETECT_STATUSDNP"Determined Not to Pollute at detected levels. These detections are assumed to be from agricultural use but evaluation by the Pesticide Registration Evaluation Committee determined they did not constitute pollution at the levels found. Therefore no further action will be taken."
DETECT_STATUSEEstimated value below the reporting laboratory's detection limit or of questionable quantification certainty for the chemical.
DETECT_STATUSGSGeologic Source detection. The chemical detected is not from man-made sources.
DETECT_STATUSMWMonitoring Well detection. These wells may not be as deep or as well constructed. They may also be wells installed around field test sites and spills.
DETECT_STATUSMW-NCMonitoring Well Not Confirmed by original agency. The chemical was not detected in subsequent testing of that well by the reporting agency.
DETECT_STATUSMWT"Monitoring Well used for pesticide evaluation Tests. Detection was made in monitoring wells surrounding fields where pesticide evaluations are a being conducted. Does not reflect normal agricultural use of the pesticide."
DETECT_STATUSNCDPRInitial detection Not Confirmed by DPR sampling. The detection was not repeated in co-samples or subsequent sampling by DPR included in the WIDB.
DETECT_STATUSNCRAInitial detection not confirmed by Reporting Agency sampling. The detection was not repeated in co-samples or subsequent sampling by Reporting Agency included in the WIDB.
DETECT_STATUSNLRNo Longer Registered at the time of detection. Pesticide was registered for use in CA at one time. Residues may result from that previous use.
DETECT_STATUSNOAGNo Agricultural use of this pesticide in the area. The detection is under investigation to determine if a field study is warranted.
DETECT_STATUSNPNLRNon-Point source of a No Longer Registered pesticide. Pesticide is assumed to be from agricultural use but is no longer registered or used in California.
DETECT_STATUSNPRNon-Point source Registered. This registered pesticide/degradate detection is from legal agricultural use.
DETECT_STATUSNRNever Registered in CA. This chemical has never been registered for use in CA.
DETECT_STATUSP1987Pre-1987 data dump accepted into the database without further investigation.
DETECT_STATUSPSPoint Source. This detection is from a pesticide spill or direct contamination of a well. Not from legal agricultural use.
DETECT_STATUSPSCPoint Source well Construction. This detection is the result of known well construction deficiencies resulting in contamination. Not from legal agricultural use.
DETECT_STATUSR"Regulated. This is a 6800a regulated pesticide (atrazine, simazine, bromacil, diuron, norflurazon, prometon or their degradatess within a GWPA or bentazon in rice growing areas) . No further action will be taken."
DETECT_STATUSREReporting Error. DPR's evaluation indicates the report is an error in analysis or data entry but has not confirmed this with the reporting agency.
DETECT_STATUSRLRegulated by Label change. The pesticide label was changed so applications were no longer allowed in counties where these detections were found.
DETECT_STATUSSNPSource Not from Pesticides. Chemical can be pesticide-related but the largest source is from non-pesticide petroleum products (i.e. leaking gasoline tanks).
DETECT_STATUSSUISource Under Investigation. DPR is further evaluating the report.
DETECT_STATUSVLV"Very Low Value. Well below DPR's screening level for response. Unless the screening level changes, no further response is planned."
DPR_RESPONSE"The field study (i.e. Z588, GW13) or Memo that explains DPR’s response to the reported detection. Please contact GWPP@cdpr.ca.gov with specific inquiries regarding DPR_Response values."
DNIA column used to exclude known point-source and reporting error data. Value should be NA. Any non-NA values are excluded but these data records are available upon request.