Return to search results
2020 UWMP Data Export Tables
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 workbook (Last Updated 2024)
* The worksheets for each table are also individually stored separately as TSV files in "2020_UWMP_TSV_Export.zip" (Last Updated 2023)
* 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
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "Kyle Miller",
"@type": "vcard:Contact",
"hasEmail": "mailto:uwmphelp@water.ca.gov"
}
|
| 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 workbook (Last Updated 2024) * The worksheets for each table are also individually stored separately as TSV files in "2020_UWMP_TSV_Export.zip" (Last Updated 2023) * 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 |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "2020 UWMP Data Dictionary",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=542b3759-9fb7-4c22-95a4-6d1e76220bcc&limit=0",
"description": "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")",
"downloadURL": "https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/486f73a7-8938-4996-8708-0515b074710c/download/2020_data_dictionary.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2020 UWMP Table Name Key",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=dc108a88-5486-4a72-a617-0bec459f1a54&limit=0",
"description": "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.",
"downloadURL": "https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/4a334807-823f-41ce-b528-ef87d6b474a0/download/table_name_key.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2020 UWMP Data Export Tables [TSV]",
"format": "TSV",
"mediaType": "text/tab-separated-values",
"description": "A zip file containing 99 tab-separated values (TSV) files. Each file corresponds to one UWMP table.",
"downloadURL": "https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/46e3548d-b8d0-411f-be40-37c375cd3163/download/2020_uwmp_tsv_export.zip"
},
{
"@type": "dcat:Distribution",
"title": "Data Dictionary - 2020 UWMP Table Name Key",
"format": "CSV",
"mediaType": "text/csv",
"description": "Data Dictionary for https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/4a334807-823f-41ce-b528-ef87d6b474a0/download/table_name_key.xlsx",
"downloadURL": "https://data.ca.gov/datastore/dictionary_download/dc108a88-5486-4a72-a617-0bec459f1a54",
"isDataDictionary": true
},
{
"@type": "dcat:Distribution",
"title": "2020 UWMP Data Export Tables [XLSX]",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This file contains all 99 data export tables on WUEdata for the 2020 UWMPs. Each worksheet corresponds to a different UWMP table.",
"downloadURL": "https://data.cnra.ca.gov/dataset/036373ad-544d-40ea-91e8-cd5fd03c7687/resource/270c8311-1c6c-4d2c-ae78-e859ba3d9f97/download/2020_uwmp_tables_07032024.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2020 UWMP Guidebook",
"format": "PDF",
"mediaType": "application/pdf",
"description": "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.",
"downloadURL": "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"
}
]
|
| identifier | 6a77613f-b903-43d6-b919-785ad2aea49a |
| issued | 2022-05-02T22:15:07.968858 |
| keyword |
[
"2020 Urban Water Management Plans",
"Energy Intensity",
"GPCD",
"Recycled Water",
"SB X7-7",
"UWMP",
"Urban",
"Urban Water Use",
"WSCP",
"WUEdata",
"Wastewater",
"Water",
"Water Shortage Contingency Plan",
"Water Supplier",
"Water Supply",
"Water Use Efficiency",
"california department of water resources"
]
|
| modified | 2025-12-24T01:19:03.798535 |
| publisher |
{
"name": "California Department of Water Resources",
"@type": "org:Organization"
}
|
| theme |
[
"Natural Resources",
"Water"
]
|
| title | 2020 UWMP Data Export Tables |
