Urban Retail Water Supplier - Water Conservation, Supply, and Demand (June 2014 onwards)

Description

Monthly reports of water use and conservation activities 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. The most recent reporting period generally lags by about 2 months, due to the reporting deadline and the necessary subsequent dataset preparation. The full dataset that spans June 2014 to the most recent reporting period is the Per-Supplier Water Supply and Demand resource, which is an updated version of the dataset previously released on the Water Board's [Water Conservation Portal](https://www.waterboards.ca.gov/water_issues/programs/conservation_portal/conservation_reporting.html). Other datasets include the per-water-system supply and demand, representing a subset of the SAFER Clearinghouse dataset, and the conservation actions datasets. See the documentation PDF for data dictionaries and an explanation of the data flag methodology.

Resources

Name Format Description Link
33 Data dictionaries and description of data flag/modified z-score methodology for the Urban Retail Water Supplier - Water Conservation, Supply, and Demand Dataset https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/54936a0d-09ce-46d3-a4e7-8808d42326c0/download/documentation-for-water-conservation-and-production-dataset_v1.1.pdf
33 A document created by the Department of Drinking Water that explains the procedure for updating population values outside of the Electronic Annual Report (EAR). https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/0ba8a039-9459-4796-916d-179cf0da6173/download/guidance_changing-population-procedure.pdf
8 Per-water-system data from the Clearinghouse for urban retail water suppliers, from January 2023 onwards. One row per water system per reporting period. Column header names have been reformatted to eliminate spaces and special characters. https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/264c7888-f7eb-42b4-9a19-ceb162f3ae8a/download/clearinghouse_report.csv
53 Reported actions to respond to drought/water shortage and/or encourage conservation, as reported in the DRINC Portal monthly report. In this format, the actions are reported as a comma-separated list under the following categories: - demand reduction - supply augmentation - water restrictions - communication - addressing water waste - other https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/51b21afe-f0a3-44cb-9a53-c9e358d0134c/download/cons_actions_list.xlsx
53 Reported actions to respond to drought/water shortage and/or encourage conservation, as reported in the DRINC Portal monthly report. In this format, each action is its own column, with a "Y" to denote if the action was implemented by the supplier for the corresponding reporting month. https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/70c0da06-4094-4110-8ac1-18d5c5883b21/download/cons_actions_single.xlsx
8 Data Dictionary for https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/f4d50112-5fb5-4066-b45c-44696b10a49e/download/monthly_combined_dataset.csv https://data.ca.gov/datastore/dictionary_download/f4d50112-5fb5-4066-b45c-44696b10a49e
8 Data Dictionary for https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/264c7888-f7eb-42b4-9a19-ceb162f3ae8a/download/clearinghouse_report.csv https://data.ca.gov/datastore/dictionary_download/264c7888-f7eb-42b4-9a19-ceb162f3ae8a
8 Per-supplier reports of selected production and deliveries fields, comprising of a combination of data from the DRINC Portal (June 2014-December 2022) and the SAFER Clearinghouse (January 2023 onwards). This table contains values converted to gallons from the original reported units. The per-water-system data for January 2023 can be viewed in the [Per-Water-System Supply and Demand](https://data.ca.gov/dataset/urws-conservation-supply-demand/resource/264c7888-f7eb-42b4-9a19-ceb162f3ae8a) table in the original units. Column header names have been reformatted to eliminate spaces and special characters. https://data.ca.gov/dataset/c69ac02b-adfb-459a-bc58-bf69a8b572d2/resource/f4d50112-5fb5-4066-b45c-44696b10a49e/download/monthly_combined_dataset.csv

Tags

  • urban-water-supplier
  • urban-water-use
  • conservation
  • water-supply

Topics

Categories