About this Dataset

Urban Water Data - Drought Planning And Management

This data package aims to pilot an approach for providing usable data for analyses related to drought planning and management for urban water suppliers--ultimately contributing to improvements in communication around drought. This project was convened by the California Water Data Consortium in partnership with the Department of Water Resources (DWR) and the State Water Resources and Control Board (SWB) and is one of two use cases of this working group that aim to improve data submitted by urban water suppliers in terms of accessibility and useability. The datasets from DWR and the SWB are compiled in a standard format to allow interested parties to synthesize and analyze these data into a cohesive message. This package includes a data management plan describing its development and maintenance. All code related to preparing this data package can be found on GitHub. Please note that the "org_id" (DWR's Organization ID) and the "pwsid" (SWB's Public Water System ID) can be used to connect to the various data tables in this package.

We acknowledge that data quality issues may exist. Making these data available in a usable format will help identify and address data quality issues. If you identify any data quality issues, please contact the data steward (see contact information). We plan to iteratively update this data package to incorporate new data and to update existing data with quality fixes. The purpose of this project is to demonstrate how data from two agencies, when made publicly available, can be used in relevant analyses; if you found this data package useful, please contact the data steward (see contact information) to share your experience.
Organization: State of California
Last updated: 2024-11-27T00:52:53.161826
Tags: awsda, california-department-of-water-resources, conservation, ear, urban, uwmp, water-supply, water-use

Tables

Actual Water Shortage Level

@usgov.ca_gov_urban_water_data_drought_planning_and_management_2dd23.actual_water_shortage_level

26.52 KB
12313 rows
6 columns


CREATE TABLE actual_water_shortage_level (
  "org_id" BIGINT,
  "pwsid" VARCHAR,
  "supplier_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "state_standard_shortage_level" VARCHAR
);

Five Year Water Shortage Outlook

@usgov.ca_gov_urban_water_data_drought_planning_and_management_2dd23.five_year_water_shortage_outlook

57.9 KB
2195 rows
11 columns


CREATE TABLE five_year_water_shortage_outlook (
  "org_id" BIGINT,
  "pwsid" VARCHAR,
  "is_multiple_pwsid" VARCHAR,
  "supplier_name" VARCHAR,
  "uwmp_year" BIGINT,
  "forecast_start_date" TIMESTAMP,
  "forecast_end_date" TIMESTAMP,
  "water_use_acre_feet" VARCHAR,
  "water_supplies_acre_feet" VARCHAR,
  "benefit_supply_augmentation_acre_feet" VARCHAR,
  "benefit_demand_reduction_acre_feet" VARCHAR
);

Historical Production And Delivery

@usgov.ca_gov_urban_water_data_drought_planning_and_management_2dd23.historical_production_and_delivery

3.9 MB
902112 rows
8 columns


CREATE TABLE historical_production_and_delivery (
  "pwsid" VARCHAR,
  "water_system_name" VARCHAR,
  "org_id" BIGINT,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "water_type" VARCHAR,
  "quantity_acre_feet" VARCHAR
);

Monthly Water Shortage Outlook

@usgov.ca_gov_urban_water_data_drought_planning_and_management_2dd23.monthly_water_shortage_outlook

65.95 KB
6136 rows
18 columns


CREATE TABLE monthly_water_shortage_outlook (
  "org_id" BIGINT,
  "pwsid" VARCHAR,
  "is_multiple_pwsid" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "reporting_interval" VARCHAR,
  "reporting_start_date" TIMESTAMP,
  "reporting_end_date" TIMESTAMP,
  "forecast_start_date" TIMESTAMP,
  "forecast_end_date" TIMESTAMP,
  "forecast_month" VARCHAR,
  "is_annual" BOOLEAN,
  "is_wscp_action" BOOLEAN,
  "shortage_surplus_acre_feet" VARCHAR,
  "shortage_surplus_percent" VARCHAR,
  "state_standard_shortage_level" VARCHAR,
  "benefit_demand_reduction_acre_feet" VARCHAR,
  "benefit_supply_augmentation_acre_feet" VARCHAR
);

Source Name

@usgov.ca_gov_urban_water_data_drought_planning_and_management_2dd23.source_name

323.87 KB
10650 rows
10 columns


CREATE TABLE source_name (
  "pwsid" VARCHAR,
  "org_id" VARCHAR,
  "source_facility_id" VARCHAR,
  "source_facility_name" VARCHAR,
  "source_facility_activity_status" VARCHAR,
  "source_facility_availability" VARCHAR,
  "source_facility_type" VARCHAR,
  "water_type" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR
);