Description
This dataset is a compilation of the data export tables available on WUEdata 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 |
|---|---|---|---|
| 2020 UWMP Data Export Tables [XLSX] | XLS | This file contains all 99 data export tables on WUEdata for the 2020 UWMPs. Each worksheet corresponds to a different UWMP table. | Open resource |
| 2020 UWMP Data Export Tables [TSV] | TSV | A zip file containing 99 tab-separated values (TSV) files. Each file corresponds to one UWMP table. | Open resource |
| 2020 UWMP Data Dictionary | XLS | 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") | Open resource |
| 2020 UWMP Table Name Key | XLS | 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. | Open resource |
| 2020 UWMP Guidebook | 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. | Open resource |