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 description | Access data | File details | Last updated |
|---|---|---|---|
Drinking Water - SAFER Failing and At-Risk Drinking Water Systems 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. | Download | CSV 4.14 MB | 03/17/23 |
SHP (Zip) Drinking Water Service System Area Boundaries SHP File (current as of 03-22-2023) 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. | Download | SHP 11.78 MB | 03/24/23 |
Rest API. Drinking Water System Service Area Boundaries (SABL) 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. | Download | SHP | 03/17/23 |
Drinking Water Laboratory Analysis Results All Data Since 1978 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. | Download | ZIP 328.00 MB | 09/27/24 |
Drinking Water Laboratory Analysis Results 2024 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. | Download | CSV 354.46 MB | 09/03/24 |
Drinking Water Laboratory Analysis Results 2023 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. | Download | CSV 569.38 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2022 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. | Download | CSV 448.19 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2021 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. | Download | CSV 452.20 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2020 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. | Download | CSV 449.80 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2019 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. | Download | CSV 433.96 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2018 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. | Download | CSV 445.05 MB | 03/17/23 |
Drinking Water Laboratory Analysis Results 2017 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. | Download | CSV 425.49 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2016 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. | Download | CSV 391.23 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2015 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. | Download | CSV 387.58 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2014 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. | Download | CSV 417.91 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2013 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. | Download | CSV 392.78 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2012 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. | Download | CSV 392.82 MB | 03/20/23 |
Drinking Water Laboratory Analysis Results 2011 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. | Download | CSV 399.66 MB | 03/20/23 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Synthesis and recommendations from this workshop | 11/06/23 | ||
Synthesis and recommendations from this workshop Synthesis and recommendations from this workshop in PDF format | 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. | 03/17/23 | ||
Data Dictionary. Drinking Water Systems This is the data dictionary associated to the drinking water systems dataset. | 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/. | 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 | 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 | 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... | 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. | 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. | 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. | 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 | 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 | PPTX 14.15 MB | 03/24/23 |
More details
State of California. The data can be filtered by spatial references such as Latitude and Longitude, County, Hydrologic Units (HUC), etc.