Urban Water Data - Drought Planning and Management

This data package aims to pilot an approach for providing usable data for analyses related to drought planning and management for urban water suppliers--ultimately contributing to improvements in communication around drought. This project was convened by the California Water Data Consortium in partnership with the Department of Water Resources (DWR) and the State Water Resources and Control Board (SWB) and is one of two use cases of this working group that aim to improve data submitted by urban water suppliers in terms of accessibility and useability. The datasets from DWR and the SWB are compiled in a standard format to allow interested parties to synthesize and analyze these data into a cohesive message. This package includes a data management plan describing its development and maintenance. All code related to preparing this data package can be found on [GitHub](https://github.com/FlowWest/urban-water-drought-data). Please note that the "org_id" (DWR's Organization ID) and the "pwsid" (SWB's Public Water System ID) can be used to connect to the various data tables in this package. We acknowledge that data quality issues may exist. Making these data available in a usable format will help identify and address data quality issues. If you identify any data quality issues, please contact the data steward (see contact information). We plan to iteratively update this data package to incorporate new data and to update existing data with quality fixes. The purpose of this project is to demonstrate how data from two agencies, when made publicly available, can be used in relevant analyses; if you found this data package useful, please contact the data steward (see contact information) to share your experience.

Data files

Data title and descriptionAccess dataFile detailsLast updated

Actual Water Shortage Level

This table reports the monthly state standard shortage level by urban retail water suppliers, which are generally defined as agencies serving over 3,000 service connections or deliveries 3,000 acre-feet of water annually for municipal purposes. These data are collected by the State Water Resources Control Board through its monthly Conservation Reporting and the data included in this dataset represent a small component of the larger dataset. Information about these reports can be found on the Water Conservation Portal (https://www.waterboards.ca.gov/water_issues/programs/conservation_portal/conservation_reporting.html), which is no longer active, and the full data (which represents the source data for this dataset) are available on the California Open Data Portal (https://data.ca.gov/dataset/urws-conservation-supply-demand). Beginning in 2023, the reporting of these data transitioned to the SAFER Clearinghouse. *Data use limitations*: Prior to 2022, shortage levels were not standardized, which makes the data difficult to use. This dataset was filtered to include 2022 onwards where shortage levels are standardized.


Download
CSV
10/18/24

Five Year Water Shortage Outlook

This table provides anticipated annual potable water levels (both surplus and shortage) with shortage actions and without shortage actions for five years based on the five driest consecutive years on record. The Urban Water Management Plans (UWMP) reports this data. All data reported through the UWMP are currently available on the WUE portal (https://wuedata.water.ca.gov/wsda_export) and the California Natural Resources Open Data Portal (https://data.cnra.ca.gov/dataset/2020-uwmp-data-export-tables). The most recent UWMP guidance is available here: https://water.ca.gov/-/media/DWR-Website/Web-Pages/Programs/Water-Use-And-Efficiency/Urban-Water-Use-Efficiency/Urban-Water-Management-Plans/Final-2020-UWMP-Guidebook/UWMP-Guidebook-2020---Final-032921.pdf. See 7-20 through 7-34 for information about the data elements contained in the five_year_outlook table. *Data use limitations*: Similar to the monthly_water_shortage_outlook data, these data also reflect forecasted values rather than actual values. These data are expected to change as conditions change.


Download
CSV
10/18/24

Historical Production and Delivery

This table provides production and delivery data by water system and water type. These data were reported through the Electronic Annual Report (eAR) and published on the California Open Data Portal (https://data.ca.gov/dataset/drinking-water-public-water-system-annually-reported-water-production-and-delivery-information-2013). The data included in this table represent a subset of the data included in the eAR. Beginning in 2023, the reporting of these data transitioned to the SAFER Clearinghouse. The SWB is working on appending data from 2023 onwards but this is not currently available. *Data use limitations:* These data do not represent the most up to date production and delivery. Data from 2023 and 2024 exist but are not yet available.


Download
CSV
10/18/24

Monthly Water Shortage Outlook

This table provides forecasted monthly (and annual) potable water shortage (or surplus) with and without shortage actions for a dry year. The Annual Water Supply and Demand Assessment (AWSDA) reports this data. All data reported through the AWSDA are available on the DWR’s Water Use Efficiency (WUE) portal (https://wuedata.water.ca.gov/wsda_export). The most recent AWSDA guidance is available here: https://wuedata.water.ca.gov/public/public_resources/3517484366/AWSDA-Final-Guidance-4-2022.pdf. See pages 30-35 for information about the data elements in the monthly_water_shortage_outlook table. Methodology guidance is included in this report, though it is not implemented consistently across urban water suppliers. *Data use limitations:* The primary function of the AWSDA is to motivate planning processes for water shortages. These data represent forecasts specific to the urban supplier and a snapshot in time based on the conditions when the supplier completed the plan. These data are expected to change as conditions change and water shortage plans are updated. These data can only be used within the year they are reported for, though if the forecasted water year is not dry, they are unreliable.


Download
CSV
10/18/24

Source Name

This table summarizes the facility type, status, and location by public water system and facility. These data are from SDWIS and processed within the SAFER Clearinghouse. These data are assigned through facility permitting process and are not user reported, and often validated through on-the-ground field visits. The data are filtered to include the most recent data; out of date data are not included. Currently, no documentation has been published for these data. *Data use limitations:* When using these data note that the facility name is not unique and needs to be used with the facility ID and PWSID.


Download
CSV
10/18/24

Supporting files

Data title and descriptionAccess dataFile detailsLast updated

Data Descriptions and Further Resources

This document collates the data table descriptions from this data package and compiles other open data resources that are relevant to understanding drought. The other resources mentioned are not directly included in this package as they are available elsewhere in useful formats.


Download
PDF
10/19/24