Water Boards Data and Databases
A subset of the datasets maintained by the Water Boards can be found on the State of California's Open Data Portal under the 'Water' category. That platform provides web services that enhance data accessibility, and we plan to continue adding datasets to that platform in the future. Note that the datasets found on that site mirror some of the datasets described in the table below.
For questions regarding a specific database or dataset, please use the contact information provided for that program or database. For general questions regarding the content covered in this webpage, or if you cannot locate the contact information for a specific database, please contact the Water Boards' Office of Information Management and Analysis (OIMA) at OIMA-Helpdesk@waterboards.ca.gov.
Subscribe to our email lists. See the following sections:
- General Interests
- CEDEN - California Environmental Data Exchange Network
- Monitoring Council Workgroups & My Water Quality Portals
- Water Quality
- Citizen Monitoring Program / Clean Water Team
- SWAMP Water Quality Monitoring (Surface Water Ambient Monitoring Program)
Publicly available data and databases at the Water Boards
Below you will find a table describing the publicly available data and databases at the Water Boards:
- To narrow the list of data, enter search criteria in the search box below.
Please note: Search is case insensitive, alphanumeric, and allows up to 20 characters.
Compatibility View Settings must be off for search box functionality to work
- To display the data sources clear the search box.
- To activate the sorting function in the table, click the column heading on which you would like to sort.
- To search the page, use your browser’s "Find" command from the Edit menu at the top of your browser window or press (CTRL+F) keys.
|Resource Name||Description||Key Words||Format||Contact Information||On the Open Data Portal?|
|Drinking Water Watch||Drinking Water Watch is a reporting tool that provides regulatory and water quality information about drinking water supply agencies. Data can be exported to Excel in some cases.||Drinking Water Quality, Water Supplier Information||Database Applicationfirstname.lastname@example.org|
|Monthly Conservation Reporting||This page provides links Excel workbooks containing urban water supplier reports and cumulative savings and compliance datasets, which are updated monthly. Scroll to the heading labeled ‘Monthly Reporting Archive’ and click on the most recent month to download the most recent dataset.||Drinking Water Quality, Water Supplier Information, Water Conservation Reporting||Tabular Data||Water Conservation Portal contacts||Yes|
|Urban Water Supplier Conservation Tiers||This Excel spreadsheet lists the conservation standard assigned to each urban water supplier (suppliers serving more than 3,000 connections) as part of the Water Board's emergency regulation to address specific provisions in Governor Brown’s April 1, 2015 Executive Order, which included a mandatory 25 percent statewide reduction in potable urban water use between June 2015 and February 2016. More information is available in the fact sheets about implementing the emergency regulation and assessing compliance with the conservation standards.||Drinking Water Quality, Water Supplier Information, Water Conservation Reporting||Tabular Data||Water Conservation Portal contacts|
|Electronic Annual Report (EAR)||The Electronic Annual Report (EAR) is a survey of public water systems, currently required annually, to collect critical water system information intended to assess the status of compliance with specific regulatory requirements. Find more information on the EAR home page.||EAR, Public Water Systems||Tabular Dataemail@example.com||Yes|
|Water Supplier Lookup Tool||This map-based tool can be used to determine who the water supplier is for a certain area. The water supplier boundaries are based on information provided directly by participating water suppliers via the California Department of Public Health Drinking Water Systems Geographic Reporting Tool.||Drinking Water Quality, Water Supplier Information, Water Conservation Reporting||Visualization|
|Public Proposals Search Tool||View and download proposals submitted to the Financial Assistance Application Submittal Tool (FAAST), the Water Board’s online loan and grant system.||Financial Assistance||Database Application/Reporting Tool||FAAST Help Desk at FAAST_Admin@waterboards.ca.gov or (866) 434-1083|
|Areas of Special Biological Significance||This map displays the 34 Areas of Special Biological Significance (ASBS) within the state.||Maps, ASBS, Ocean, Biological Significance||Map||Katherine Walsh, Ocean Standards Unit - email or phone (916) 445-2317|
|Map Services||Map services for the spatial data provided by many of the Water Boards’ map applications are open and available for public developer use via our GIS server endpoint. Map services are generally provided in ESRI REST, OGC WMS and KML formats.||Maps, GIS Web Services||API||GIS@waterboards.ca.gov|
|GeoTracker||GeoTracker is a data management system for managing sites that impact groundwater, especially those that require groundwater cleanup (Underground Storage Tanks, Department of Defense, Site Cleanup Program) as well as permitted facilities such as operating USTs and land disposal sites. It includes portals to retrieve records and view integrated data sets from multiple State Water Board programs and other agencies through a Google maps GIS interface, and provides most of the public record for a site (including regulatory communication with responsible parties, regulatory actions such as records of decision documents, and all data and documents submitted by the responsible party) through its Document Manager Module.||Groundwater Monitoring, Groundwater Related Facilities||Database Application||Geotracker@waterboards.ca.gov||Yes|
|GeoTracker Advanced Search||This search screen allows you more search options when looking for regulated sites in GeoTracker.||Groundwater Monitoring, Groundwater Related Facilities||Database Application||Geotracker@waterboards.ca.gov|
|Underground Storage Tank and Site Cleanup Data Download||These data downloads provide regulatory site information about underground storage tank and site cleanup program sites that are stored in GeoTracker.||Underground Storage Tanks, Site Cleanup, Regulatory||Zipped text files||Geotracker@waterboards.ca.gov|
|Groundwater and Well Data from Regulated Facilities||These data downloads provide groundwater monitoring results from regulated sites and associated well information by county, as well as statewide. The data are in the Electronic Deliverable Format (EDF).||Groundwater Monitoring||Zipped text files||Geotracker@waterboards.ca.gov|
|Groundwater – Water Quality Regulatory Information||These data on the Open Data Portal provide regulatory data on sites contained in GeoTracker||GeoTracker, Groundwater Related Facilities||Tabular Data||Geotracker@waterboards.ca.gov||Yes|
|Groundwater Ambient Monitoring and Assessment Program (GAMA) Groundwater Information System||The GAMA Groundwater Information System consists of groundwater sampling data and water level information. Well construction details are also available for State and Regional Water Boards (collectively Water Boards) regulated sites. Dataset categories included in the system have been integrated from various state and federal agencies responsible for collecting groundwater information, and private groups who have requested to include their data in the system. The GAMA Groundwater Information System displays water quality data from various sources on an interactive Google-based map, and is searchable by chemical or location.||Groundwater Monitoring, Groundwater Related Facilities, Maps, GIS Web Services||Database Application/Graphical Interface||Help Desk at GAMA@waterboards.ca.gov or (916) 341-5577|
|Groundwater Data Downloads||Groundwater quality data from GAMA repository.||Groundwater monitoring, depth to groundwater, well||CSV, KMZ||Help Desk at GAMA@waterboards.ca.gov or (916) 341-5577||Partial|
|GAMA OnLine Tools||This page provides a menu of groundwater-related tools for users to explore including a Nitrate Impacted Well Tool, a Trend Analysis Tool, and a Salt and Nutrient Management Plan Webmap.||Groundwater Monitoring, Groundwater Related Facilities, Maps, Nitrate, 123-TCP, San and Nutrient Management Plans, Groundwater Vulnerability, Groundwater Publications||Interactive Tools||Help Desk at GAMA@waterboards.ca.gov or (916) 341-5577|
|Impaired Water Bodies Map for 2018||20018 Assessed Lines and Polygons||Impaired waterbodies, Integrated Report, 303(d)||REST API||
For questions regarding the Integrated Report, please contact Lori Webber at (916) 341-5736.
For questions regarding the Integrated Report GIS files, please contact Nirmal Sandhar at (916) 341-5571
|Impaired Water Bodies Map for 2018||Interactive map displaying the assessed waterbodies for 2018.||Impaired waterbodies, Integrated Report, 303(d)||Interactive Map||
For questions regarding the Integrated Report, please contact Lori Webber at (916) 341-5736.
For questions regarding the Integrated Report GIS files, please contact Nirmal Sandhar at (916) 341-5571
|Impaired Water Bodies 303(d) Reports - Excel worksheet of waterbody/pollutant combinations||This Excel sheet provides a list of Water Quality Limited Segments under Section 303(d) of the federal Clean Water Act, which requires states to identify waterbodies that do not meet water quality standards and are not supporting their beneficial uses. The list identifies the pollutant or stressor causing impairment, and establishes a schedule for developing a control plan to address the impairment.||Impaired waterbodies, Integrated Report, 303(d)||Tabular Data||For questions regarding the Integrated Report, please contact Lori Webber at (916) 341-5736.|
|California Open Data Portal - Water Data||A subset of the datasets maintained by the Water Boards can be found on the State of California's Open Data Portal under the 'Water' category. That platform provides web services that enhance data accessibility, and we plan to continue adding datasets to that platform in the future. Note that the datasets found on that site mirror some of the datasets provided through this Water Boards portal.||Open Water Data||Portal||Yes|
|California Integrated Water Quality System (CIWQS)||The California Integrated Water Quality System (CIWQS) is a computer system used by the State and Regional Water Quality Control Boards to track information about places of environmental interest, manage permits and other orders, track inspections, and manage violations and enforcement activities. CIWQS also allows online submittal of information by Permittees within certain programs and makes data available to the public through reports.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Database Application||CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.|
|CIWQS Regulated Facility Report||This report allows the user to display a list of state owned wastewater treatment facilities by city, county, or region. The user can select a program, agency type, and permit status. They are then shown a summary table based on their criteria, which enables them to drill down for more information. Also see an Excel-based version of the same report.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions, Permits, Inspections||Hard Coded Report||CIWQS Help Center at email@example.com or (866) 792-4977.|
|CIWQS Facility At-a-Glance Report||This report allows users to view a wide range of information regarding a specific facility on one screen. This includes owner, violations, inspections, and orders and other regulatory measures issued to a facility.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions, Permits, Inspections||Hard Coded Report||CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.|
|CIWQS Mandatory Minimum Penalty Report||This report shows only mandatory minimum penalty violations associated with Water Code sections 13385(h) and (i) and 13385.1(a).||Water Quality, Violations||Hard Coded Report||CIWQS Help Center at email@example.com or (866) 792-4977.|
|CIWQS Enforcement Reports||This drill down report displays a table of enforcement action types per regional board. The user can control the primary sorting of the lists as well as drill down to see more detailed information.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Hard Coded Report||CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.|
|CIWQS eSMR Analytical Report||This report provides analytical and calculated data provided by NPDES permit holders. The report allows the user to query by a specific facility, agency, or order, or more generally by report type, monitoring location type, or time frame. The data is provided in Microsoft Excel format. The report limits queries to 100,000 data points.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Tabular Data||CIWQS Help Center at email@example.com or (866) 792-4977.|
|CIWQS Sanitary Sewer Overflows (SSO) Report||Sanitary sewer system agencies covered under Statewide General Waste Discharge Requirements for Sanitary Sewer Systems (WQO No. 2006-0003-DWQ), referred to as Enrollees, are required to report all Sanitary Sewer Overflows (SSOs) for which their agency has responsibility into the State Water Resources Control Board’s SSO database. Enrollees are also able to report sewage discharges from privately owned laterals or collection systems (known as private lateral sewage discharges, or PLSDs), for which the Enrollee has knowledge of the event but is not responsible, on a voluntary basis. The SSO Report allows users to view summary information of SSOs and PLSDs reported by Enrollees, as well as complete reports submitted for specific sewage discharge locations.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Hard Coded Report||CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.|
|CIWQS Sanitary Sewer Overflows (SSO) Reduction Program Data||This dataset contains information about any overflow, spill, release, discharge or diversion of untreated or partially treated wastewater from a sanitary sewer system. SSOs include: overflows or releases of untreated or partially treated wastewater that reach waters of the United States; overflows or releases of untreated or partially treated wastewater that do not reach waters of the United States; and wastewater backups into buildings and on private property that are caused by blockages or flow conditions within the publicly owned portion of a sanitary sewer system.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Tabular Data||CIWQS Help Center at email@example.com or (866) 792-4977.|
|CIWQS NPDES Permits||This Excel spreadsheet lists NPDES permits, including storm water general permit enrollees that are active or have been active within the past three years. The facility and discharger addresses are also provided. Please note there can be multiple listings for a single permit due to multiple dischargers, multiple facilities, and/or multiple address listings. Because the Regulatory Measure ID (column E) is a unique identifier for each permit, this number can be used to evaluate whether a particular permit is listed more than once.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Tabular Data||CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.|
|CIWQS Violation Reports||This report allows the user to select whether the first display is by county, regional board, or violation type. The user then is given options to choose program type, violation source, agency type, and date range. The user can then drill down to a listing of facilities with violations and then to more details about a particular facility’s violations, in accordance with the original criteria selected. For more information about the report and how to navigate, we have developed a Fact Sheet.||Water Quality, Wastewater Discharge Monitoring, Compliance, Enforcement Actions||Hard Coded Report||CIWQS Help Center at email@example.com or (866) 792-4977.|
|Stormwater Multi-Application Reporting & Tracking System (SMARTS) Public Reports||SMARTS provides a platform where dischargers, regulators, and the public can enter, manage, and view storm water data including permit registration documents, compliance, and monitoring data associated with California's Storm Water General Permits. SMARTS is compliant with the EPA's Cross-Media Electronic Reporting Rule (CROMERR) which sets requirements for electronic reporting of National Pollutant Discharge Elimination System (NPDES) permit and report submittals. Click on the button labeled ‘View SW Data’ to view public reports from the SMARTS program.||Stormwater Monitoring||Portal||SMARTS Help Center at firstname.lastname@example.org or (866) 563-3107.|
|California Environmental Data Exchange Network (CEDEN)||CEDEN is a central location to find and share information about California’s water bodies, including streams, lakes, rivers, and the coastal ocean. Many groups in California monitor water quality, aquatic habitat, and wildlife health to ensure good stewardship of our ecological resources, and CEDEN aggregates this data and makes it accessible to environmental managers and the public.||Surface Water Quality, Toxicity, Habitat, Benthic, Taxonomy||Hard Coded Report||CEDEN administrator at email@example.com.||Yes|
|Water Quality Goals||This searchable database contains an extensive compendium of numeric water quality thresholds for over 860 chemical constituents and water quality parameters. For more information, please visit the instructions webpage.||Water Quality Goals and Objectives||Database Application||Lisa Holmes: firstname.lastname@example.org or (916) 341-5557|
|Electronic Water Rights Information Management System (eWRIMS) Database||The eWRIMS Database System provides information about water rights throughout California. It includes information on Statements of Water Diversion and Use that have been filed by water diverters, as well as registrations, certificates, and water right permits and licenses that have been issued by the State Water Resources Control Board and its predecessors. You can search for water rights by several criteria, including the water right owner's name, watershed, stream system, and county.||Water Rights Permits, Licenses||Database Application||eWRIMS Help Center, or contact the Division of Water Rights at (916) 341-5300 or email@example.com.|
|eWRIMS Web Mapping Application||The eWRIMS Web Mapping Application provides the spatial location of water rights throughout California.||Water Rights Permits, Licenses, Maps, GIS Web Services||Interactive Map||eWRIMS Help Center, or contact the Division of Water Rights at (916) 341-5300 or firstname.lastname@example.org.|
|Points of Diversion (PODs)||Points of Diversion (PODs) are locations where water is being drawn from a water source such as a stream or river. The point locations in this service were derived by extracting the best known location information from the POD table from the WRIMS database supplied by the California State Water Resources Control Board. This service should be used for general mapping of Points of Diversion. Because of source data irregularities, some POD locations may be inaccurate by as much as half the width of a Public Land Survey System section.||Water Rights, Points of Diversions, GIS Layers||GIS Layer||eWRIMS Help Center or email@example.com.|