2020 UWMP Data Export Tables

Description

This dataset is a compilation of the data export tables available on [WUEdata](https://wuedata.water.ca.gov/) for the 2020 Urban Water Management Plans (UWMPs). * "2020_UWMP_Tables.xlsx" contains each of the 99 tables as a separate worksheet * The individual tables are also stored separately as TSV files in "2020_UWMP_TSV_Export.zip" * Column definitions, data types, and table locations are included in "2020_Data_Dictionary.xlsx" * Shortened versions of the table names are used in the XLSX worksheet names and TSV filenames; "Table_Name_Key.xlsx" links the shortened names and original names * For reference, the 2020 UWMP Guidebook that was provided to water suppliers is included in this dataset

Resources

Name Format Description Link
53 This file contains the original names of the UWMP tables as well as their shortened names that are used in "2020_UWMP_Tables.xlsx" and "2020_UWMP_TSV_Export.zip". The shortened names appear in the XLSX worksheet names and TSV filenames, while the original names are from WUEdata. https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/4a334807-823f-41ce-b528-ef87d6b474a0/download/table_name_key.xlsx
33 This guidebook was provided to water suppliers to assist with the completion of their UWMPs. It contains additional information about the UWMP requirements and DWR's recommendations to streamline the process. 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
49 A zip file containing 99 tab-separated values (TSV) files. Each file corresponds to one UWMP table. https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/46e3548d-b8d0-411f-be40-37c375cd3163/download/2020_uwmp_tsv_export.zip
53 This file contains all 99 data export tables on WUEdata for the 2020 UWMPs. Each worksheet corresponds to a different UWMP table. https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/270c8311-1c6c-4d2c-ae78-e859ba3d9f97/download/2020_uwmp_tables.xlsx
53 This file contains the column definitions for all 99 UWMP tables. It also includes: * The column data type ("DATA_TYPE") * An extended column name ("LABEL") * The XLSX worksheet names and TSV filenames where the column appears ("SHEET_LOCATIONS") * The UWMP table names where the column appears ("TABLE_LOCATIONS") https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/486f73a7-8938-4996-8708-0515b074710c/download/2020_data_dictionary.xlsx

Tags

  • wuedata
  • energy-intensity
  • 2020-urban-water-management-plans
  • wastewater
  • urban-water-use
  • urban
  • water-use-efficiency
  • gpcd
  • water-supplier
  • recycled-water
  • water
  • wscp
  • sb-x7-7
  • water-supply
  • uwmp
  • water-shortage-contingency-plan
  • california-department-of-water-resources

Topics

Categories