Excel · dataset · 2025
DWR Urban Water Use Objective Analyzer Tool
Listed in California Open Data
With the enactment of Senate Bill 606 (Hertzberg) and Assembly Bill 1668 (Friedman) in 2018, California established a new framework for long term urban water use efficiency and conservation.
Description
This landmark legislation required the Department of Water Resources (DWR), in coordination with the State Water Board, to develop recommendations for new urban water use efficiency standards that would result in lower aggregate statewide urban water use than achieved by the SB X7-7 statewide 2020 target.
DWR developed the DWR Urban Water Use Objective Analyzer tool to, among other things, evaluate alternative water use efficiency standards in relation to the statewide SB X7-7 water use target for 2020. This spreadsheet model utilizes the various data sources to estimate Urban Water Use Objective and Objective Based Total Water Use for the State’s urban retail water supplier. The "Read Me" tab of the spreadsheet provides description of the data sources used in the Objective Analyzer Tool.
Read the rest (3 more)
To use the model to evaluate different scenarios, users can input varying assumptions in yellow boxes on the "Dashboard" worksheet. This worksheet also summarizes the model's outputs. This is the only worksheet where the user can modify model inputs.
The other worksheets store data or perform calculations. All worksheets in the DWR Urban Water Use Objective Analyzer, except for the Dashboard worksheet, are password protected to prevent inadvertent changes to data and formulas. Users are expected to download the excel file to their local computer before entering new values on the Dashboard worksheets.
For additional details, see DWR reports “Recommendations for Urban Water Use Efficiency Standards, Variances, Performance Measures, and Annual Water Use Reporting (Report No. WUES-DWR-2021-01A)” and “Recommendations for Outdoor Residential Water Use Efficiency Standard (Report No. WUES-DWR-2021-02)” at water.ca.gov/Programs/Water-Use-And-Efficiency/2018-Water-Conservation-Legislation/Urban-Water-Use-Efficiency-Standards-Variances-and-Performance-Measures.
Links
Get the data
Where it is published
- California Open Data dataset page data.ca.gov/dataset/dwr-urban-water-use-objective-analyzer-tool ↗
landing page · from data ca gov
Documentation and papers
- Publisher page water.ca.gov/Programs/Water-Use-And-Efficiency/2018-Water-Conservation-Legi… ↗
documentation · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=40a847f6-3908-4a1d-8c56-067a45fdf… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Natural Resources · Water
- From keywords
- Earth & Environmental Science · Social Science
Provenance · 1 source records, 11 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 40a847f6-3908-4a1d-8c56-067a45fdf135 | 13 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| 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 |