| Name |
Format |
Description |
Link |
|
0 |
|
https://www.openenvironmentaldata.org/convening/caswb-workshop-drinking-water |
|
33 |
Synthesis and recommendations from this workshop in PDF format |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/5ca9c993-35d2-4898-901a-a5e006d0f214/download/drinking-water-datasets-recommendations-42504.pdf |
|
0 |
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. |
https://data.ca.gov/dataset/drinking-water-public-water-system-information |
|
33 |
This is not the final version and is being used for testing purposes.
Describes the columns in the dataset etc... |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/a9fe604e-67ce-4855-8fe8-5fa96048af75/download/risk-assessment-data-dictionary-not-final.pdf |
|
36 |
This is the power point presented by Greg Gearheart, Rafael Maestu and Paul Williams from the State Water Resources Control Board |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e601bb7f-ebcc-4a8e-915d-314288dd50fd/download/oedp-workshop-greg-and-rafa1-1.pptx |
|
21 |
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 |
https://sdwis.waterboards.ca.gov/PDWW/Help/html_Water_System_Facilities.htm |
|
61 |
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. |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/918f76a9-e9f0-4bf3-8761-4999a869fb9d/download/sabl_public_230322.zip |
|
33 |
This is the link to the online data dictionary for the drinking water quality results associated datasets. |
https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/79a3c6a4-6034-4637-9de6-aa4fca0f7798/download/clip-sql-2021.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/6d113312-dd71-45c2-95d9-2fb4c04fb030/download/clip-sql-2019.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/2d0aca32-68fa-474e-90d5-2528c8804836/download/clip-sql-2018.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/d2235b6c-b156-44a9-9127-e01614d8c25b/download/clip-sql-2013.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/6ab48d4a-b4a2-4d30-9302-9bc6f1442cdf/download/clip-sql-2012.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/39fab6c1-105a-493f-b88a-02a00e68d62e/download/clip-sql-2011.csv |
|
21 |
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 |
https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/prelim2023.html |
|
21 |
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 |
https://sdwis.waterboards.ca.gov/PDWW/Help/html_Violation_Detail.htm |
|
57 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e0216eb3-cc19-4ea5-8c40-7d80b6a8aefd/download/drinking-water-quality-data-clip-sql-all.zip |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/3bce5a17-41e4-4db4-9310-14b74b066308/download/clip-sql-2024.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/9f6dc19b-ab64-4aa2-bf20-30e8ae4394f6/download/clip-sql-2020.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/86a13f43-2ddc-4c76-844d-3c4bf550cacb/download/clip-sql-2017.csv |
|
21 |
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. |
https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/needs.html |
|
0 |
This is the data dictionary associated to the drinking water systems dataset. |
https://data.ca.gov/dataset/drinking-water-public-water-system-information/resource/52419458-eb9a-4460-8483-0695e1940453 |
|
0 |
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/. |
https://sdwis.waterboards.ca.gov/PDWW/ |
|
8 |
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. |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/3a37d065-ef56-4730-a0fa-d3af436e11df/download/drinking-water-risk-assessment-public-flat-file-1.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e8f33cad-546a-4a99-b5b1-3b5e5b632856/download/clip-sql-2022.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/8f19e0a7-2e6f-477e-83d0-0de8e6acfb1e/download/clip-sql-2016.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/c72cc3f4-ca55-4f37-ac00-8c8a0ca95e16/download/clip-sql-2015.csv |
|
21 |
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. |
https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/EDTlibrary.html |
|
61 |
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. |
https://gispublic.waterboards.ca.gov/portalserver/rest/services/Drinking_Water/California_Drinking_Water_System_Area_Boundaries/MapServer |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/2e2c0a07-a477-4887-af18-b0345767e7f8/download/clip-sql-2014.csv |
|
8 |
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 |
https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/134ab09c-2632-4b09-947f-195832a0ddc7/download/clip-sql-2023.csv |