Data and Databases
Drinking Water Quality, Water Supplier Information, and Water Conservation Reporting
- 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. For assistance, please contact the DRINC portal administrator at email@example.com.
- 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.
- Urban Water Supplier Conservation Tiers (Excel)
This 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.
- 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.
- 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. For assistance, please contact the 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. Annual lists of CAA funded projects can be found under the ‘Funded CAA Projects’ heading at the link above.
- 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.
- Map of Funded Projects
Scroll to the bottom of the link above to see 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.
Maps and GIS Web Services
- Data Maps
Maps that cover a wide range of Water Boards programs and the beneficial uses they protect and restore.
- 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. For questions regarding the use of the map services, please contact GIS@waterboards.ca.gov.
Groundwater Monitoring and Groundwater Related Facilities
- Cleanup Sites by County (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. For general assistance in searching or utilizing the GeoTracker database, please contact the GeoTracker Help Desk at firstname.lastname@example.org or (866) 480-1028.
- Groundwater Ambient Monitoring and Assessment Program (GAMA)
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. For assistance, please contact the 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.
Impaired Water Bodies (303(d) Report)
- 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.
Open Water Data
- 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.
- 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).
Some Water Boards' databases have reporting systems that allow users to directly access a specified URL to retrieve an up-to-date version of a data query, returned as either as a webpage or Excel workbook. For example, as part of the Regulated Facility Report from the CIWQS database, the query at this link will open a list of state owned wastewater treatment facilities on a webpage, and this link will open an Excel-based version of the same report. Some other examples of CIWQS reports with this feature are the are Facility At-a-Glance Report and the Mandatory Minimum Penalty Report (note that you must select criteria, run the report, and in some cases drill-down in order to copy an identifying URL).
- Stormwater Multi-Application Reporting & Tracking System (SMARTS) Public Reports
Click on the button labeled ‘View SW Data’ to view public reports from the SMARTS program. For assistance, please contact the SMARTS Help Center at email@example.com or (866) 563-3107.
Surface Water Quality and Toxicity
- 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. For assistance, please contact the CEDEN administrator at firstname.lastname@example.org.
- Surface Water Ambient Monitoring Program (SWAMP)
The Surface Water Ambient Monitoring Program (SWAMP) mission is to provide resource managers, decision makers, and the public with timely, high-quality information and tools needed to evaluate the condition of surface waters throughout California. SWAMP accomplishes this through its statewide and regional ambient monitoring programs and by maintaining the infrastructure to support the production of high quality data and tools for data analysis and interpretation.
Wastewater Discharge Monitoring and Compliance/Enforcement Actions
- All California Integrated Water Quality System (CIWQS) Public Reports
CIWQS is a web-based relational database for core regulatory data. The CIWQS Public Reports page allows the public to see information on the facilities regulated by the Water Boards, and violation and enforcement data. For assistance, please contact the CIWQS Help Center at email@example.com or (866) 792-4977.
- 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. For assistance, please contact the CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.
- 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. For assistance, please contact the CIWQS Help Center at email@example.com or (866) 792-4977.
- Facility at a Glance
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. For assistance, please contact the CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.
- Interactive Regulated Facilities Report
This report allows the user to display information 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. For assistance, please contact the CIWQS Help Center at email@example.com or (866) 792-4977.
- Interactive 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. For assistance, please contact the CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.
- NPDES Permits (including Stormwater) (Excel)
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. For assistance, please contact the CIWQS Help Center at email@example.com or (866) 792-4977.
- Sanitary Sewer Overflow 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.
- 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. For assistance, please contact the CIWQS Help Center at firstname.lastname@example.org or (866) 792-4977.
Water Quality Goals and Objectives
- 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 Rights Permits and Licenses
- 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. In addition, the eWRIMS Web Mapping Application provides the spatial location of water rights throughout California. For assistance please visit the eWRIMS Help Center, or contact the Division of Water Rights at (916) 341-5300 or email@example.com.