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

                                            {
  "fn": "Rafael Maestu",
  "@type": "vcard:Contact",
  "hasEmail": "mailto:rafael.maestu@waterboards.ca.gov"
}
                                        

                                            [
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water - Public Water System Information",
    "accessURL": "https://data.ca.gov/dataset/drinking-water-public-water-system-information",
    "description": "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."
  },
  {
    "@type": "dcat:Distribution",
    "title": "Data Dictionary. Drinking Water Systems",
    "accessURL": "https://data.ca.gov/dataset/drinking-water-public-water-system-information/resource/52419458-eb9a-4460-8483-0695e1940453",
    "description": "This is the data dictionary associated to the drinking water systems dataset."
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Watch Web Portal",
    "accessURL": "https://sdwis.waterboards.ca.gov/PDWW/",
    "description": "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/."
  },
  {
    "@type": "dcat:Distribution",
    "title": "Data Dictionary: Drinking Water Violations and Enforcement",
    "format": "HTML",
    "accessURL": "https://sdwis.waterboards.ca.gov/PDWW/Help/html_Violation_Detail.htm",
    "description": "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"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Data Dictionary. Drinking Water Facilities",
    "format": "HTML",
    "accessURL": "https://sdwis.waterboards.ca.gov/PDWW/Help/html_Water_System_Facilities.htm",
    "description": "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"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Synthesis and recommendations from this workshop",
    "accessURL": "https://www.openenvironmentaldata.org/convening/caswb-workshop-drinking-water"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results EDT 1974-2010",
    "format": "HTML",
    "accessURL": "https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/EDTlibrary.html",
    "description": "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."
  },
  {
    "@type": "dcat:Distribution",
    "title": "California Drinking Water Needs Assessment Web Site",
    "format": "HTML",
    "accessURL": "https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/needs.html",
    "description": "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."
  },
  {
    "@type": "dcat:Distribution",
    "title": "Preliminary Risk Assessment Results for Public Water Systems 2023 TABLEAU Viz",
    "format": "HTML",
    "accessURL": "https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/prelim2023.html",
    "description": "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"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2023",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=134ab09c-2632-4b09-947f-195832a0ddc7&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/134ab09c-2632-4b09-947f-195832a0ddc7/download/clip-sql-2023.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2018",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=2d0aca32-68fa-474e-90d5-2528c8804836&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/2d0aca32-68fa-474e-90d5-2528c8804836/download/clip-sql-2018.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2014",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=2e2c0a07-a477-4887-af18-b0345767e7f8&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/2e2c0a07-a477-4887-af18-b0345767e7f8/download/clip-sql-2014.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2011",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=39fab6c1-105a-493f-b88a-02a00e68d62e&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/39fab6c1-105a-493f-b88a-02a00e68d62e/download/clip-sql-2011.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water - SAFER Failing and At-Risk Drinking Water Systems",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=3a37d065-ef56-4730-a0fa-d3af436e11df&limit=0",
    "description": "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.",
    "downloadURL": "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",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2024",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=3bce5a17-41e4-4db4-9310-14b74b066308&limit=0",
    "description": "2024 monitoring results as of November 7, 2025. 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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/3bce5a17-41e4-4db4-9310-14b74b066308/download/clip-sql-2024.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2012",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=6ab48d4a-b4a2-4d30-9302-9bc6f1442cdf&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/6ab48d4a-b4a2-4d30-9302-9bc6f1442cdf/download/clip-sql-2012.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2019",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=6d113312-dd71-45c2-95d9-2fb4c04fb030&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/6d113312-dd71-45c2-95d9-2fb4c04fb030/download/clip-sql-2019.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2021",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=79a3c6a4-6034-4637-9de6-aa4fca0f7798&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/79a3c6a4-6034-4637-9de6-aa4fca0f7798/download/clip-sql-2021.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2025",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=84de0856-5b00-421f-83de-bd78d57c4b08&limit=0",
    "description": "2025 monitoring results as of November 7, 2025. 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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/84de0856-5b00-421f-83de-bd78d57c4b08/download/clip-sql-2025.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2017",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=86a13f43-2ddc-4c76-844d-3c4bf550cacb&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/86a13f43-2ddc-4c76-844d-3c4bf550cacb/download/clip-sql-2017.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2016",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=8f19e0a7-2e6f-477e-83d0-0de8e6acfb1e&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/8f19e0a7-2e6f-477e-83d0-0de8e6acfb1e/download/clip-sql-2016.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2020",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=9f6dc19b-ab64-4aa2-bf20-30e8ae4394f6&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/9f6dc19b-ab64-4aa2-bf20-30e8ae4394f6/download/clip-sql-2020.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2015",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=c72cc3f4-ca55-4f37-ac00-8c8a0ca95e16&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/c72cc3f4-ca55-4f37-ac00-8c8a0ca95e16/download/clip-sql-2015.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2013",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=d2235b6c-b156-44a9-9127-e01614d8c25b&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/d2235b6c-b156-44a9-9127-e01614d8c25b/download/clip-sql-2013.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results 2022",
    "format": "CSV",
    "mediaType": "text/csv",
    "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=e8f33cad-546a-4a99-b5b1-3b5e5b632856&limit=0",
    "description": "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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e8f33cad-546a-4a99-b5b1-3b5e5b632856/download/clip-sql-2022.csv",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Drinking Water Laboratory Analysis Results All Data Since 1978",
    "format": "ZIP",
    "mediaType": "application/zip",
    "description": "All drinking water quality monitoring results since 1978 as of November 7, 2025. 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",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e0216eb3-cc19-4ea5-8c40-7d80b6a8aefd/download/drinking-water-quality-data-clip-sql-all-2.zip"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Rest API. Drinking Water System Service Area Boundaries (SABL)",
    "format": "SHP",
    "mediaType": "application/octet-stream",
    "description": "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.",
    "downloadURL": "https://gispublic.waterboards.ca.gov/portalserver/rest/services/Drinking_Water/California_Drinking_Water_System_Area_Boundaries/MapServer"
  },
  {
    "@type": "dcat:Distribution",
    "title": "SHP (Zip) Drinking Water Service System Area Boundaries SHP File (current as of 03-22-2023)",
    "format": "SHP",
    "mediaType": "application/octet-stream",
    "description": "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.",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/918f76a9-e9f0-4bf3-8761-4999a869fb9d/download/sabl_public_230322.zip"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Synthesis and recommendations from this workshop",
    "format": "PDF",
    "mediaType": "application/pdf",
    "description": "Synthesis and recommendations from this workshop in PDF format",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/5ca9c993-35d2-4898-901a-a5e006d0f214/download/drinking-water-datasets-recommendations-42504.pdf"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Data Dictionary. Drinking Water - SAFER Failing and At-Risk Assessment",
    "format": "PDF",
    "mediaType": "application/pdf",
    "description": "This is not the final version and is being used for testing purposes.

Describes the columns in the dataset etc...",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/a9fe604e-67ce-4855-8fe8-5fa96048af75/download/risk-assessment-data-dictionary-not-final.pdf"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Data Dictionary. Water Quality Results",
    "format": "PDF",
    "mediaType": "application/pdf",
    "description": "This is the link to the online data dictionary for the drinking water quality results associated datasets.",
    "downloadURL": "https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/edtlibrary/data_dictionary.pdf"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Water Boards OEDP Power Point Presentation",
    "format": "PPTX",
    "mediaType": "application/vnd.openxmlformats-officedocument.presentationml.presentation",
    "description": "This is the power point presented by Greg Gearheart, Rafael Maestu and Paul Williams from the State Water Resources Control Board",
    "downloadURL": "https://data.ca.gov/dataset/d7193835-8161-4ff6-bcc3-da894965d53c/resource/e601bb7f-ebcc-4a8e-915d-314288dd50fd/download/oedp-workshop-greg-and-rafa1-1.pptx"
  }
]
                                        

                                            [
  "Drinking Water",
  "Drinking Water Quality Results",
  "Drinking Water Violations",
  "Open Data"
]
                                        

                                            {
  "name": "California State Water Resources Control Board",
  "@type": "org:Organization"
}
                                        

                                            [
  "Water"
]