Table · dataset · 2025
Urban Water Data - Drought Planning and Management
Listed in California Open Data
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.
Description
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.
Read the rest (2 more)
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.
Links
Get the data
- Actual Water Shortage Level data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/c3832742… ↗
download · from data ca gov
- Five Year Water Shortage Outlook data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/77b47bbe… ↗
download · from data ca gov
- Historical Production and Delivery data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/b73488e4… ↗
download · from data ca gov
- Monthly Water Shortage Outlook data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/caf0ef52… ↗
download · from data ca gov
- Source Name data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/9688aeb1… ↗
download · from data ca gov
- Data Descriptions and Further Resources data.cnra.ca.gov/dataset/57b20340-2b03-4c22-bc52-b59047451496/resource/b0af64e8… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/urban-water-data-drought-planning-and-management ↗
landing page · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=3e2dfc18-dcc8-4595-8b4e-51cf2f372… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Natural Resources · Water
- From keywords
- Earth & Environmental Science · Social Science
- Inferred from text
- Urban hydrology 77%
Provenance · 1 source records, 12 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 3e2dfc18-dcc8-4595-8b4e-51cf2f372bbb | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].anzsrc:field:370705 | enrichment · data ca gov | taxonomy-embedding@1.1.0 | title+keywords+description (77%) |
| concepts[field].local:field:earth-environmental | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:social-science | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:natural-resources | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:water | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| license_text | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |