Well Inventory Database – Data Dictionary
Back to Well Inventory Database
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." | |
CHEMNUMBER | A DPR-assigned five digit numeric field specifying the chemical analyzed. | |
CHEMNAME | A 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)." | |
AGENCY | A DPR-assigned four digit field with a character code specifying the agency that performed the study. | |
AGENCY_ACRON | An acronym of the agency name associated with the AGENCY code. | |
AGENCY_ACRON | AECON | American Environmental Consulting Firm |
AGENCY_ACRON | CDPH | California Department of Public Health (previously the Department of Health Services (DHS)) |
AGENCY_ACRON | CGY | Ciba-Geigy |
AGENCY_ACRON | CRWQCB1 | California Regional Water Quality Control Board-Region 1 |
AGENCY_ACRON | CRWQCB2 | California Regional Water Quality Control Board-Region 2 |
AGENCY_ACRON | CRWQCB3 | California Regional Water Quality Control Board-Region 3 |
AGENCY_ACRON | CRWQCB4 | California Regional Water Quality Control Board-Region 4 |
AGENCY_ACRON | CRWQCB5 | California Regional Water Quality Control Board-Region 5 |
AGENCY_ACRON | CRWQCB6 | California Regional Water Quality Control Board-Region 6 |
AGENCY_ACRON | CRWQCB8 | California Regional Water Quality Control Board-Region 8 |
AGENCY_ACRON | CRWQCB9 | California Regional Water Quality Control Board-Region 9 |
AGENCY_ACRON | CSWRCB | California State Water Resources Control Board |
AGENCY_ACRON | CSWRCBDWP | California State Water Resources Control Board-Drinking Water Program (took over reporting from CDPH) |
AGENCY_ACRON | CWS | California Water Service |
AGENCY_ACRON | DAVCY | City of Davis |
AGENCY_ACRON | DPR | California Department of Pesticide Regulation |
AGENCY_ACRON | DWR | California Department of Water Resources |
AGENCY_ACRON | FRECO | Fresno County |
AGENCY_ACRON | GLECO | Glenn County |
AGENCY_ACRON | IMPCO | Imperial County |
AGENCY_ACRON | KERCO | Kern County |
AGENCY_ACRON | LAKCO | Lake County |
AGENCY_ACRON | MADCO | Madera County |
AGENCY_ACRON | MARCO | Mariposa County |
AGENCY_ACRON | MODCO | Modoc County |
AGENCY_ACRON | OCNSDCY | City of Oceanside |
AGENCY_ACRON | RIVCO | Riverside County |
AGENCY_ACRON | RPAG | Rhone-Poulenc Ag Co. |
AGENCY_ACRON | SACCO | Sacramento County |
AGENCY_ACRON | SBCO | Santa Barbara County |
AGENCY_ACRON | SCCO | Santa Clara County |
AGENCY_ACRON | SCVWD | Santa Clara Valley Water District |
AGENCY_ACRON | SDCO | San Diego County |
AGENCY_ACRON | SFCY | San Francisco County |
AGENCY_ACRON | SLOCO | San Luis Obispo County |
AGENCY_ACRON | SMCO | San Mateo County |
AGENCY_ACRON | SOLID | Solano Irrigation District |
AGENCY_ACRON | STKESJWCD | Stockton-East San Joaquin Water Conservation District |
AGENCY_ACRON | SUTCO | Sutter County |
AGENCY_ACRON | USBLM | United States Bureau of Land Management |
AGENCY_ACRON | USDA | United States Department of Agriculture |
AGENCY_ACRON | USEPA | United States Environmental Protection Agency |
AGENCY_ACRON | USFS | United States Forest Service |
AGENCY_ACRON | USGS | United States Geological Survey |
AGENCY_ACRON | YOLCO | Yolo County |
AGENCY_ACRON | YUBCO | Yuba 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. " | |
STYPE | A 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. |
STYPE | A | Averaged result. |
STYPE | B | "Initial detection sample with further qualitative or quantitative analyses, all negative results." |
STYPE | C | Initial detection sample confirmed by data source agency. |
STYPE | D | "Split sample: method-different, lab-different." |
STYPE | E | "Split sample: method-same, lab-different." |
STYPE | F | "Split sample: method-different, lab-different." |
STYPE | G | "Split sample: method-same, lab same." |
STYPE | H | "Replicate sample: method-different, lab-same." |
STYPE | I | Initial detection not confirmed. |
STYPE | J | "Replicate sample: method-different, lab-different." |
STYPE | K | "Replicate sample: method-same, lab-different." |
STYPE | L | "Replicate sample: method-same, lab-same." |
STYPE | M | Initial detection sample qualitatively confirmed. |
STYPE | N | Single non-detected. |
STYPE | O | Single result. |
STYPE | P | Initial detection with further quantitative and qualitative analyses. |
STYPE | Q | Initial detection sample with further analyses. |
STYPE | R | Routine ongoing. |
STYPE | S | Split sample. |
STYPE | T | Initial detection sample analyzed for multiple compounds. |
STYPE | U | Unconfirmed detection sample. |
STYPE | V | Unequivocal detection method used. |
STYPE | X | Negative detection sample. |
STYPE | Y | "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’. " | |
STATUS | E | Estimated or quantified trace value reported by reporting agency. |
STATUS | N | Non-detect (concentration=0). |
STATUS | P | Confirmed detection (2 or more positive detections during the same study/well/chem/report year) or wells where the stype is ‘V’. |
STATUS | R | Data was marked as preliminary by the reporting agency at the time the data was loaded into the Well Inventory. |
STATUS | U | Unconfirmed detection (only 1 positive detection during the same study/well/chem/report year). |
STATUS | V | Positive detection analyzed using a DPR-approved unequivocal method. |
STATUS | X | Positive detection analyzed before 1987. |
RESIDUE_SOURCE | DPR evaluation of the source of the pesticide contamination | |
RESIDUE_SOURCE | - | No detection |
RESIDUE_SOURCE | NON POINT | Residues are not from local well contamination but are most likely due to agricultural use of the pesticide. |
RESIDUE_SOURCE | POINT_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_SOURCE | POINT_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_SOURCE | UNDER_INVESTIGATION | DPR is investigating to determine the source of the reported pesticide residue. |
LAB | Code for the laboratory analyzing the well samples. The translation table for this code is available on request. | |
ADATE | The analysis date for the well sample in DD-MMM-YYYY format. Not all datasets include this information. | |
APFILE | Letter 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. | |
COUNTY | California county name where the sampled well is located. | |
WELLCODE | Letter 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." | |
DEPTH | The reported depth of the well in feet. DPR does not have any construction data for most of the wells in its database. | |
TPERF | Top of Perforations. The reported depth to the to of the first casing perforations (where the well starts collecting water) in feet. | |
BPERF | Bottom 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_STATUS | ANPHU | Accepted Non-Point Source from Historical Use. Many Southern California wells have reported detections of 6800a/degradate pesticides due to pre-1985 use. |
DETECT_STATUS | CID | Confirmed 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_STATUS | DCNP | "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_STATUS | DNP | "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_STATUS | E | Estimated value below the reporting laboratory's detection limit or of questionable quantification certainty for the chemical. |
DETECT_STATUS | GS | Geologic Source detection. The chemical detected is not from man-made sources. |
DETECT_STATUS | MW | Monitoring 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_STATUS | MW-NC | Monitoring Well Not Confirmed by original agency. The chemical was not detected in subsequent testing of that well by the reporting agency. |
DETECT_STATUS | MWT | "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_STATUS | NCDPR | Initial detection Not Confirmed by DPR sampling. The detection was not repeated in co-samples or subsequent sampling by DPR included in the WIDB. |
DETECT_STATUS | NCRA | Initial 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_STATUS | NLR | No 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_STATUS | NOAG | No Agricultural use of this pesticide in the area. The detection is under investigation to determine if a field study is warranted. |
DETECT_STATUS | NPNLR | Non-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_STATUS | NPR | Non-Point source Registered. This registered pesticide/degradate detection is from legal agricultural use. |
DETECT_STATUS | NR | Never Registered in CA. This chemical has never been registered for use in CA. |
DETECT_STATUS | P1987 | Pre-1987 data dump accepted into the database without further investigation. |
DETECT_STATUS | PS | Point Source. This detection is from a pesticide spill or direct contamination of a well. Not from legal agricultural use. |
DETECT_STATUS | PSC | Point Source well Construction. This detection is the result of known well construction deficiencies resulting in contamination. Not from legal agricultural use. |
DETECT_STATUS | R | "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_STATUS | RE | Reporting 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_STATUS | RL | Regulated by Label change. The pesticide label was changed so applications were no longer allowed in counties where these detections were found. |
DETECT_STATUS | SNP | Source Not from Pesticides. Chemical can be pesticide-related but the largest source is from non-pesticide petroleum products (i.e. leaking gasoline tanks). |
DETECT_STATUS | SUI | Source Under Investigation. DPR is further evaluating the report. |
DETECT_STATUS | VLV | "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." | |
DNI | A 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. |