Urban Water Management Plans (UWMP) 2015
State of California
@usgov.ca_gov_urban_water_management_plans_uwmp_2015_cbec8
State of California
@usgov.ca_gov_urban_water_management_plans_uwmp_2015_cbec8
Urban Water Management Plans (UWMPs) are prepared by California's urban water suppliers to support their long-term resource planning, and ensure adequate water supplies are available to meet existing and future water demands.
Every urban water supplier that either provides over 3,000 acre-feet of water annually, or serves more than 3,000 urban connections is required to assess the reliability of its water sources over a 20-year planning horizon, and report its progress on 20% reduction in per-capita urban water consumption by the year 2020, as required in the Water Conservation Bill of 2009 SBX7-7.
The plans must be prepared every 5 years and submitted to the Department of Water Resources (DWR). DWR staff then reviews the submitted plans to make sure they have completed the requirements identified in the Water Code, Sections §10608– 10656, then submits a report to the Legislature summarizing the status of the plans.
For each round of UWMPs, DWR provides guidance for urban water suppliers. This includes preparation of a Guidebook, workshops, and program staff to assist in preparing comprehensive and useful water management plans, implementation of water conservation programs, and understanding the requirements of the Act.
For additional information please visit: http://www.water.ca.gov/urbanwatermanagement/
Organization: State of California
Last updated: 2023-09-15T13:43:50.493892
Tags: california-department-of-water-resources, urban, uwmp, water-supply
CREATE TABLE table_6_9_wholesale_water_supplies_projected (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"water_supply" VARCHAR,
"additional_water_supply_detail" VARCHAR,
"reasonably_avail_volume_2020_af" DOUBLE,
"total_right_or_safe_yield_2020_af" DOUBLE,
"reasonably_avail_volume_2025_af" DOUBLE,
"total_right_or_safe_yield_2025_af" DOUBLE,
"reasonably_avail_volume_2030_af" DOUBLE,
"total_right_or_safe_yield_2030_af" DOUBLE,
"reasonably_avail_volume_2035_af" DOUBLE,
"total_right_or_safe_yield_2035_af" DOUBLE,
"reasonably_avail_volume_2040_af" DOUBLE,
"total_right_or_safe_yield_2040_af" DOUBLE
);CREATE TABLE table_7_1_retail_basis_of_water_year_data (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"source_name" VARCHAR,
"year_type" VARCHAR,
"base_year" VARCHAR,
"volume_available_af" DOUBLE,
"percentage_of_average_supply" DOUBLE
);CREATE TABLE table_7_1_retail_basis_of_water_year_data_addl_info (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"ut_uwmp_table_7_1_r_source_id" BIGINT,
"quantification_not_compatible" VARCHAR,
"quantification_loc_in_uwmp" VARCHAR
);CREATE TABLE table_7_1_wholesale_basis_of_water_year_data (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"source_name" VARCHAR,
"year_type" VARCHAR,
"base_year" VARCHAR,
"volume_available_af" DOUBLE,
"percentage_of_average_supply" DOUBLE
);CREATE TABLE table_7_1_wholesale_basis_of_water_year_data_addl_info (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"ut_uwmp_table_7_1_w_source_id" BIGINT,
"quantification_not_compatible" VARCHAR,
"quantification_loc_in_uwmp" VARCHAR
);CREATE TABLE table_7_2_retail_normal_year_supply_and_demand_comparison (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"total_type" VARCHAR,
"total_volume_2020_af" DOUBLE,
"total_volume_2025_af" DOUBLE,
"total_volume_2030_af" DOUBLE,
"total_volume_2035_af" DOUBLE,
"total_volume_2040_af" DOUBLE
);CREATE TABLE table_7_2_wholesale_normal_year_supply_and_demand_comparison (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"total_type" VARCHAR,
"total_volume_2020_af" DOUBLE,
"total_volume_2025_af" DOUBLE,
"total_volume_2030_af" DOUBLE,
"total_volume_2035_af" DOUBLE,
"total_volume_2040_af" DOUBLE
);CREATE TABLE table_7_3_retail_single_dry_year_supply_and_demand_comparison (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"total_type" VARCHAR,
"total_volume_2020_af" DOUBLE,
"total_volume_2025_af" DOUBLE,
"total_volume_2030_af" DOUBLE,
"total_volume_2035_af" DOUBLE,
"total_volume_2040_af" DOUBLE
);CREATE TABLE table_8_1_retail_stages_of_wscp (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"stage" VARCHAR,
"percent_supply_reduction" VARCHAR,
"water_supply_condition" VARCHAR
);CREATE TABLE table_8_1_wholesale_stages_of_wscp (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"stage" VARCHAR,
"supply_reduction" VARCHAR,
"water_supply_condition" VARCHAR
);CREATE TABLE table_8_4_retail_minimum_supply_next_three_years (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"available_water_supply_2016_af" DOUBLE,
"available_water_supply_2017_af" DOUBLE,
"available_water_supply_2018_af" DOUBLE
);CREATE TABLE table_8_4_wholesale_minimum_supply_next_three_years (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"available_water_supply_2016_af" DOUBLE,
"available_water_supply_2017_af" DOUBLE,
"available_water_supply_2018_af" DOUBLE
);CREATE TABLE uwmp_note_fields (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"uwmp_worksheet_id" VARCHAR,
"note_index" BIGINT,
"note_contents" VARCHAR,
"source_name" VARCHAR,
"table_record_id" DOUBLE
);Anyone who has the link will be able to view this.