{"action":"create","ckan_id":null,"date_created":"Thu, 26 Feb 2026 19:38:42 GMT","date_finished":null,"harvest_job_id":"dcc9c6eb-8123-4536-90b4-14fd2339c519","harvest_source_id":"959a1dad-e8ac-4235-935b-b5ca593f6714","id":"5f2b9549-8d81-4169-a6ca-9196910dce8a","identifier":"40a847f6-3908-4a1d-8c56-067a45fdf135","parent_identifier":null,"source_hash":"045a9ab91ab16315a94038f32d836efb1cc7ff45e07ecbb3bdf58586026f9767","source_raw":"{\"@type\": \"dcat:Dataset\", \"accessLevel\": \"public\", \"contactPoint\": {\"@type\": \"vcard:Contact\", \"fn\": \"Bekele Temesgen\", \"hasEmail\": \"mailto:bekele.temesgen@water.ca.gov\"}, \"description\": \"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. 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.\\r\\n\\r\\nDWR 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\\u2019s urban retail water supplier. The \\\"Read Me\\\" tab of the spreadsheet provides description of the data sources used in the Objective Analyzer Tool.\\r\\n\\r\\nTo 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.\\r\\n\\r\\nFor additional details, see DWR reports \\u201cRecommendations for Urban Water Use Efficiency Standards, Variances, Performance Measures, and Annual Water Use Reporting (Report No. WUES-DWR-2021-01A)\\u201d and \\u201cRecommendations for Outdoor Residential Water Use Efficiency Standard (Report No. WUES-DWR-2021-02)\\u201d at https://water.ca.gov/Programs/Water-Use-And-Efficiency/2018-Water-Conservation-Legislation/Urban-Water-Use-Efficiency-Standards-Variances-and-Performance-Measures.\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"description\": \"Spreadsheet zip file. Uploaded on 8/19/2022.\", \"downloadURL\": \"https://data.cnra.ca.gov/dataset/a89e237c-5f8a-4497-b367-34cef1bcd6d1/resource/5e8465be-d5ed-47b3-8b61-e77b5bcbce53/download/dwr_urban_water_use_objective_analyzer_final_08192022.xlsx\", \"format\": \"XLSX\", \"mediaType\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\", \"title\": \"DWR Urban Water Use Objective Analyzer Tool\"}], \"identifier\": \"40a847f6-3908-4a1d-8c56-067a45fdf135\", \"issued\": \"2022-07-01T23:36:07.335507\", \"keyword\": [\"california department of water resources\", \"objectives\", \"standards\", \"urban water use\", \"water conservation\", \"water use\", \"water use efficiency\", \"wue\"], \"license\": \"Other (Public Domain)\", \"modified\": \"2022-10-28T19:35:47.922126\", \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"California Department of Water Resources\"}, \"theme\": [\"Natural Resources\", \"Water\"], \"title\": \"DWR Urban Water Use Objective Analyzer Tool\"}","source_transform":null,"status":"error"}