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||Contact Information||On the Open Data Portal?|
|Drinking Water Program Repository||This page provides links to download flat files (CSV files and Excel workbooks) containing data covering a number of categories within the drinking water program, including annual reports from public water systems, a list of active public water systems (including contact, location, water source, and type), recent conservation reports for small water suppliers and urban water suppliers, and drinking water quality results from 2013 to present.||Drinking Water Quality, Water Supplier Information, Water Conservation Reporting||DRINC portal administrator: firstname.lastname@example.org|
|Monthly Conservation Reporting Archive||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||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||Water Conservation Portal contacts|
|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|
|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||FAAST Help Desk at FAAST_Admin@waterboards.ca.gov or (866) 434-1083|
|Cleanup and Abatement Account||The Cleanup and Abatement Account (CAA) was created by Water Code Sections 13440-13443 to provide public agencies with grants for the cleanup or abatement of a condition of pollution when there are no viable responsible parties available to undertake the work. Eligible entities that could apply for this funding include public agencies, as well as certain not-for-profit organizations and tribal governments that serve a disadvantaged community and that have the authority to clean up or abate the effects of a waste.||Financial Assistance||DFA-CAA@waterboards.ca.gov or (916) 319-9066|
|Drinking Water State Revolving Fund||The Drinking Water State Revolving Fund (DWSRF) Program is administered by staff in the State Water Board’s Division of Financial Assistance (DFA). Eligible applicants include community water systems and non-profit, non-community water systems.||Financial Assistance||DrinkingWaterSRF@waterboards.ca.gov
See the Drinking Water SRF contacts page
|Map of Funded Projects||Scroll to the bottom of the link for a map of projects funded from the Cleanup and Abatement Account under an emergency drought relief package to meet interim emergency drinking water needs for those communities with a contaminated water supply or that suffer drought related water outages or threatened emergencies.||Financial Assistance, Map|
|Data Maps||Maps that cover a wide range of Water Boards programs and the beneficial uses they protect and restore.||Maps, GIS Web Services|
|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||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||GeoTracker Help Desk at email@example.com or (866) 480-1028.|
|Groundwater Ambient Monitoring and Assessment Program (GAMA) Groundwater Information System||The GAMA Groundwater Information System 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||Help Desk at GAMA@waterboards.ca.gov or (916) 341-5577|
|Nitrate Impacted Water Wells||This interactive tool is intended for private domestic well owners to evaluate if their well is near a nitrate-impacted well. The map interface displays the location of wells with known test results above the nitrate maximum contaminant level (MCL). The blue dots displayed on the map each represent a well with the most recent detection of nitrate above the MCL since 2000. Additionally, this interface allows you to enter an address to see if a nitrate-impacted well is within 2,000 feet of you.||Groundwater Monitoring, Groundwater Related Facilities, Maps, GIS Web Services||Help Desk at GAMA@waterboards.ca.gov or (916) 341-5577|
|Impaired Water Bodies 303(d) Reports||Select the tab labeled ‘303(d) List’ near the bottom of the page to view 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 Water Bodies, Water Quality||For questions regarding the Integrated Report, please contact: Lori Webber or at (916) 341-5736. For questions regarding the Integrated Report GIS files, please contact: Nirmal Sandhar or at (916) 341-5571.|
|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||Yes|
|National Water Quality Monitoring Council's Water Quality Portal||The National Water Quality Monitoring Council maintains a data portal housing water quality information from over 400 state, federal, tribal, and local agencies. It is a cooperative service sponsored by the United States Geological Survey (USGS), the Environmental Protection Agency (EPA), and the National Water Quality Monitoring Council (NWQMC).||Open Water Data|
|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||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||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||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||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||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||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||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||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||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||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||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||CEDEN administrator at email@example.com.||Yes (some datasets)|
|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||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||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||eWRIMS Help Center, or contact the Division of Water Rights at (916) 341-5300 or firstname.lastname@example.org.|