Drinking Water - Open Environmental Data Project - March 23, 2023 Workshop

The following datasets related to regulated drinking water system facilities in California have been developed and are available for the purpose of the March 23, 2023, OEDP workshop. The main purpose of the workshop is to engage community members and researchers in understanding datasets maintained and shared by the California State Water Resources Control Board Drinking Water Program and explore possibilities for their use and enhancement. Input from this workshop could be used to inform recommendations OEDP makes to partnering organizations about how to collect, share, and structure their open datasets. Conversations could also support community organizations in using water datasets to inform programming, policy advocacy, or organizing.

Data files

Data title and descriptionAccess dataFile detailsLast updated

Drinking Water - SAFER Failing and At-Risk Drinking Water Systems

Human Right to Water Systems (HR2W). Community Water Systems (CWSs) and Non-Community Water Systems (NCWSs) that serve schools and daycares. Those systems were identified to be out of compliance for consistently failing to meet primary drinking water standards. The HR2W list criteria was expanded in March 2021 to better align with statutory definitions of what it means for a water system to “consistently fail” to meet primary drinking water standards.


Download
CSV
4.14 MB
03/17/23

SHP (Zip) Drinking Water Service System Area Boundaries SHP File (current as of 03-22-2023)

SHP (Zip) Drinking Water Service System Area Boundaries SHP File (current as of 03-22-2023). Please join the tables using the field SABL PWSID as Water System Number or PWSID (Public Water System ID). This is a spatial file format (SHP) of the service area boundaries for drinking water systems, including whole sellers and retailers. In order to provide an accurate data set of service area boundaries for California drinking water systems, the Division of Drinking Water of the California Water Resources Control Board (SWRCB DDW) has undertaken a project to vet and verify the data collected by the Tracking California's Water Boundary Tool (WBT). SWRCB DDW downloaded a copy of the current water system service areas loaded in the WBT as of June 27, 2019. Additional attribute fields indicating verification status, verification staff and system type were appended to the data set. SWRCB DDW staff are reviewing and validating the displayed boundaries of each service area as well as contacting the service providers regarding necessary corrections. The verification status of any particular service area may be found in the Verification Status field.


Download
SHP
11.78 MB
03/24/23

Rest API. Drinking Water System Service Area Boundaries (SABL)

Please join the tables using the field SABL PWSID as Water System Number or PWSID (Public Water System ID). This is a spatial file format (SHP) of the service area boundaries for drinking water systems, including whole sellers and retailers. In order to provide an accurate data set of service area boundaries for California drinking water systems, the Division of Drinking Water of the California Water Resources Control Board (SWRCB DDW) has undertaken a project to vet and verify the data collected by the Tracking California's Water Boundary Tool (WBT). SWRCB DDW downloaded a copy of the current water system service areas loaded in the WBT as of June 27, 2019. Additional attribute fields indicating verification status, verification staff and system type were appended to the data set. SWRCB DDW staff are reviewing and validating the displayed boundaries of each service area as well as contacting the service providers regarding necessary corrections. The verification status of any particular service area may be found in the Verification Status field.


Download
SHP
03/17/23

Drinking Water Laboratory Analysis Results All Data Since 1978

All drinking water quality monitoring results since 1978 as of August 30, 2024. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
ZIP
328.00 MB
09/27/24

Drinking Water Laboratory Analysis Results 2024

2024 monitoring results as of August 30, 2024. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
354.46 MB
09/03/24

Drinking Water Laboratory Analysis Results 2023

2023 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
569.38 MB
03/17/23

Drinking Water Laboratory Analysis Results 2022

2022 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
448.19 MB
03/17/23

Drinking Water Laboratory Analysis Results 2021

2021 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
452.20 MB
03/17/23

Drinking Water Laboratory Analysis Results 2020

2020 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
449.80 MB
03/17/23

Drinking Water Laboratory Analysis Results 2019

2019 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
433.96 MB
03/17/23

Drinking Water Laboratory Analysis Results 2018

2018 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
445.05 MB
03/17/23

Drinking Water Laboratory Analysis Results 2017

2017 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
425.49 MB
03/20/23

Drinking Water Laboratory Analysis Results 2016

2016 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
391.23 MB
03/20/23

Drinking Water Laboratory Analysis Results 2015

2015 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
387.58 MB
03/20/23

Drinking Water Laboratory Analysis Results 2014

2014 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
417.91 MB
03/20/23

Drinking Water Laboratory Analysis Results 2013

2013 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
392.78 MB
03/20/23

Drinking Water Laboratory Analysis Results 2012

2012 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
392.82 MB
03/20/23

Drinking Water Laboratory Analysis Results 2011

2011 monitoring results. The California State Water Resources Control Board (CASWRCB) Division of Drinking Water (DDW) regulates approximately 7,500 public water systems throughout the State of California. Part of this regulatory oversight ensures that required water quality sampling has been conducted and that follow-up actions are taken when the concentrations of certain chemicals exceed set limits. To streamline its regulatory oversight, DDW launched a portal known as CLIP (California Laboratory Intake Portal) on September 1, 2021. This change to the electronic submission of water quality analyses replaces the WQM (Water Quality Management) portal and ensures that data from laboratories flow to DDW’s database of record, the Safe Drinking Water Information System (SDWIS). This process will not only allow for quicker compliance determinations but will also provide for improved data quality by ensuring that minimum data validations have been met. Notice to the users of the data - use care in interpreting the data. A single detection of a contaminant may not indicate contamination of a drinking water supply. If this detection is not confirmed with a follow-up detection, it may represent a false positive. Additionally, the presence of a contaminant in raw water at a given concentration does not necessarily mean that the water was served by the water system to its customers, or if served, that the contaminant was present at that concentration. Water systems may not use certain sources or may treat or blend them prior to service. Data Dictionary here https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf


Download
CSV
399.66 MB
03/20/23

Supporting files

Data title and descriptionAccess dataFile detailsLast updated

Synthesis and recommendations from this workshop


Download

11/06/23

Synthesis and recommendations from this workshop

Synthesis and recommendations from this workshop in PDF format


Download
PDF
4.42 MB
11/07/23

Drinking Water - Public Water System Information

This is a curated dataset of information for all drinking water public water systems (PWS) in California, including the name, location and some general information for each PWS. The source of the data https://sdwis.waterboards.ca.gov/PDWW/ is a public web portal to view public water systems (PWS) location, facilities, sources, and samples.


Download

03/17/23

Data Dictionary. Drinking Water Systems

This is the data dictionary associated to the drinking water systems dataset.


Download

03/17/23

Drinking Water Watch Web Portal

Drinking Water Watch is a public web portal to view public water systems (PWS) location, facilities, sources, samples, etc for one water system at a time. The source of the data https://sdwis.waterboards.ca.gov/PDWW/.


Download

03/17/23

Data Dictionary. Drinking Water Facilities

This data dictionary is available through drinking water watch glossary available at https://sdwis.waterboards.ca.gov/PDWW/Help/html_Public_Water_Supply_Sytems_Search_Paramaters.htm https://sdwis.waterboards.ca.gov/PDWW/Help/html_Water_System_Facility.htm https://sdwis.waterboards.ca.gov/PDWW/Help/html_Water_System_Facility_Detail.htm


Download
HTML
03/17/23

Data Dictionary: Drinking Water Violations and Enforcement

Violations are issued for a public water system when there is a failure to meet certain state/region or federal drinking water regulations. This includes a failure to collect a sample (called a monitoring violation), failure to report the analytical results from a sample that was collected (a reporting requirement), deliver water that exceeds a maximum contaminant level (a Maximum Contaminant Level violation), as well as other failures. On the Violations page you may view basic water system information, such as Water System No., Water System Name, Principal County Served, Status, Federal and State Type, Source, and Activity Date. This data dictionary is available through drinking water watch glossary available at https://sdwis.waterboards.ca.gov/PDWW/Help/html_Public_Water_Supply_Sytems_Search_Paramaters.htm Violations: https://sdwis.waterboards.ca.gov/PDWW/Help/html_Violation.htm Violations and Group Violations: https://sdwis.waterboards.ca.gov/PDWW/Help/html_Violations.htm Enforcement actions are actions taken against a water system. These may include requirements that must be met in order to rectify a failure to perform under the Public Water System Supervision program. Enforcement actions are informal and formal. They are typically issued by the primacy agency but may be issued by its representative or the U.S. Environmental Protection Agency. Examples include administrative and civil/criminal legal actions, warning notices, citations, temporary injunctions, restraining orders, and penalties. https://sdwis.waterboards.ca.gov/PDWW/Help/html_Violation_Detail.htm


Download
HTML
03/17/23

Data Dictionary. Drinking Water - SAFER Failing and At-Risk Assessment

This is not the final version and is being used for testing purposes. Describes the columns in the dataset etc...


Download
PDF
130.10 KB
03/17/23

Data Dictionary. Water Quality Results

This is the link to the online data dictionary for the drinking water quality results associated datasets.


Download
PDF
03/17/23

Drinking Water Laboratory Analysis Results EDT 1974-2010

For historical data, from 1974 to 2010 The following historical water quality data are available to download and are divided among three files in both .DBF and .CSV formats (Chemhist, Chemarch, and Chemxarc). There are also four supporting data files in both .DBF and .CSV formats (Siteloc, Watsys, Lab, and Storet) along with a Word file that provides explanation.


Download
HTML
03/17/23

California Drinking Water Needs Assessment Web Site

In 2019, to advance the goals of the Human Right to Water “HR2W”, California passed Senate Bill 200, which enabled the State Water Board to establish the Safe and Affordable Funding for Equity and Resilience (SAFER) Program. Foremost among the tools created for SAFER is the Safe and Affordable Drinking Water Fund. The Fund provides up to $130 million per year through 2030 to enable the State Water Board to develop and implement sustainable solutions for underperforming drinking water systems. The annual Fund Expenditure Plan prioritizes projects for funding, documents past and planned expenditures, and is “based on data and analysis drawn from the drinking water Needs Assessment.” For more information on SAFER, visit the Safe and Affordable Fund for Equity and Resilience (SAFER) website.


Download
HTML
03/17/23

Preliminary Risk Assessment Results for Public Water Systems 2023 TABLEAU Viz

The State Water Board is proposing enhancements to the 2023 Needs Assessment. These changes are intended to improve the accuracy of the Needs Assessment and accommodate for data availability. These changes are summarized in the resources below. Public feedback on the proposed changes is due by February 24, 2023. https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/needs.html


Download
HTML
03/17/23

Water Boards OEDP Power Point Presentation

This is the power point presented by Greg Gearheart, Rafael Maestu and Paul Williams from the State Water Resources Control Board


Download
PPTX
14.15 MB
03/24/23

More details

Geographic coverage location

State of California. The data can be filtered by spatial references such as Latitude and Longitude, County, Hydrologic Units (HUC), etc.