Surface Water Database (SURF)
Access to the Data
Pesticide monitoring results from Department of Pesticide Regulation's (DPR) Surface Water Database (SURF) are available through on-line query/export or as downloadable comma delimited (.csv) files. All the chemical analysis results from DPR's surface water database as of May 2016 are available. A minor update was released in August 2016 after removal of duplicates and a few corrections.
Information on DPR’s Surface Water Database
Accessing the Data
The data can be queried on-line. Query results can be viewed on-line, or exported and saved to your own computer.
- Guide to querying the data, PDF (82 kb)
- Query surface water monitoring data
- Query sediment monitoring data
Note: Google Fusion Table is an experimental online application. If the application does not work for you, you may download the data directly as described in the section below.
The data can also be downloaded as comma-delimited files for import into spreadsheet and database programs. Two files are available: one with all available surface water data (water_Aug2016) and one with all available sediment data (sed_Aug2016). The files will automatically open with the proper formatting in newer versions of spreadsheet programs. Note that the surface water data file contains over 488,000 records and will not import properly into older versions of spreadsheet programs which are limited to a maximum of 65,000 records.
- surf_Aug2016 (166 mb)
- sed_Aug2016 (25 mb)
- Map of all the surface water monitoring sites in the Database can be downloaded. The .kmz file can be opened in Google Earth, a free program by Google, Inc. If you do not have Google Earth on your computer, you can download it.
Once loaded into Google Earth, zoom to your area of interest. Clicking on a site point will give a pop-up box containing information about the site, including the DPR site code, the county where the site is located, a brief description of the site, the number of water column and sediment records in the database for the site and the maximum concentrations of water and sediment samples detected at the site. The latitude and longitude are also provided.
For content questions, contact:
Xuyang Zhang, Ph.D.
1001 I Street, P.O. Box 4015
Sacramento, CA 95812-4015
Phone: (510) 494-1102