Surface
Water Database
Complete Chemical Analysis Results
Back to Surface Water Protection Program
Complete pesticide monitoring chemical analysis results from DPR's Surface Water Database are available to the public as a set of seven downloadable files. This page contains information about the available data files.
The files contain all chemical analysis results from the Department of Pesticide Regulation’s (DPR) surface water database, as of June 2008. Sediment monitoring data are now included as well as surface water monitoring data.
Information on the DPR’s surface water database
The “Complete Chemical Analysis Results files” (“Results files”) are derived from the full Surface Water Database.
The Results files each contain pesticide monitoring results from specific counties in California, as specified in Table 1.
The Results files contain the information shown in Table 2 and 3 for every record in DPR’s suface water database. This is the information most often requested from DPR. Some information that is less frequently requested, such as the type of sampling equipment used or the name of the analytical laboratory, has been omitted from these samples in order to make the file size more manageable. The files are a fixed column width format; each row consists of a record that is comprised of 9 fields for (surface water files, Table 2) or 10 fields (sediment file, Table 3). The first row in each file contains the column (variable) names. This format is easily imported into spreadsheet or database applications following the guidelines in Tables 2. For instructions on how to import the data files into a spreadsheet application, click here. (PDF, 9 kb).
Select the link below to download files. To download these files right click the link and choose "Save target as". |
||
| SacVal (1)_June08.txt (8.64 mb) | SacVal_1 = water data, Sacramento Valley Counties, file 1 of 2 | |
| SacVal (2)_June08.txt (8.40 mb) | SacVal_2 = water data, Sacramento Valley Counties, file 2 of 2 | |
| SJVal (1)_June08.txt (8.64 mb) | SJVal_1 = water data, San Joaquin Valley Counties, file 1 of 3 | |
| SJVal (2)_June08.txt (10 mb) | SJVal_2 = water data, San Joaquin Valley Counties, file 2 of 3 | |
| SJVal (3)_June08.txt (9.4 mb) | SJVal_3 = water data, San Joaquin Valley Counties, file 3 of 3 | |
| Other_Jun08.txt (10.8 mb) | Other = water data, all other counties | |
| Sed_Jun08.txt(457 kb) | Sed = sediment data, all counties | |
Table 1. Monitoring data in each data file and record totals, by county.
|
Sacramento - 38,326 records |
SacVal (2)_June08.txt 37,118 records Butte - 1,501 records |
SJVal (1)_June08.txt 60,087 records Stanislaus - 60,087 records |
SJVal (2)_June08.txt 41,116 records Fresno - 1,272 records |
SJVal (3)_June08.txt 41,814 records Merced - 41,814 records |
Sed_Jun08.txt 1,890 records Imperial - 180 records |
Other_Jun08.txt 48,090 records Alameda - 176 records |
Table 2. Variables and Locations in the Surface Water Data Records.
| Field Name | start column | end column |
|---|---|---|
| County name | 1 | 20 |
| Site description | 21 | 120 |
| Chemical | 121 | 162 |
| Sampling date (MMDDYYYY) | 163 | 172 |
| Concentration (ug/L)1 | 173 | 184 |
| Limit of quanitation | 185 | 196 |
| study code 2 | 197 | 205 |
| latitude (decimal degrees) | 206 | 220 |
| longitude (decimal degrees) | 221 | 235 |
Table 3. Variables and Locations in the Sediment Data Records.
| Field Name | start column | end column |
|---|---|---|
| County name | 1 | 20 |
| Site description | 21 | 120 |
| Chemical | 121 | 162 |
| Sampling date (MMDDYYYY) | 163 | 172 |
| Concentration (ug/L)1 | 173 | 184 |
| Limit of quanitation | 185 | 196 |
| TOC (percent total organic carbon) | 197 | 205 |
| study code | 206 | 215 |
| latitude (decimal degrees) | 216 | 230 |
| longitude (decimal degrees) | 231 | 245 |
1microgram per liter, commonly referred to as parts per billion (ppb).
2 for a description of the monitoring studies and their codes, see the link above, “Metadata for studies contained in the database”.
Contact information:
For content questions contact:
Keith Starner
Phone: (916) 324-4167
E-mail: kstarner@cdpr.ca.gov