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 n__6_7_wholesale_expected_future_water_supply_projects_05d0759a (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"name_of_projects_or_programs" VARCHAR,
"joint_project_with_others" VARCHAR,
"joint_project_agency_name" VARCHAR,
"description" VARCHAR,
"planned_implementation_year" DOUBLE,
"year_type" VARCHAR,
"expected_increase_in_supply" VARCHAR,
"units_of_measure" VARCHAR
);CREATE TABLE n__6_7_wholesale_expected_future_water_supply_projects_c5eb12d5 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"no_expected_increase_in_supply" VARCHAR,
"projects_incompatible_with_tbl" VARCHAR,
"project_narrative_loc_in_uwmp" VARCHAR
);CREATE TABLE n__7_3_wholesale_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 n__7_4_retail_multiple_dry_years_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,
"year_type" 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 n__7_4_wholesale_multiple_dry_years_supply_and_demand__53f272c3 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"year_type" 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 n__8_2_retail_only_restrictions_and_prohibitions_on_end_uses (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"stage" VARCHAR,
"restrictions_and_prohibitions" VARCHAR,
"additional_explanation_or_ref" VARCHAR,
"penalty_charge_or_other_enf" VARCHAR
);CREATE TABLE n__8_3_retail_only_stages_of_wscp_consumption_reduction_methods (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"stage" VARCHAR,
"consumption_reduction_methods" VARCHAR,
"additional_explanation_or_ref" VARCHAR
);CREATE TABLE sb_x7_7_table_0_units_of_measure_used (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"units_of_measure" VARCHAR
);CREATE TABLE sb_x7_7_table_1_baseline_period_ranges (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"base_10_15_2008_water_delivery_af" DOUBLE,
"base_10_15_2008_recyc_delivery_af" DOUBLE,
"base_10_15_2008_percent" DOUBLE,
"base_10_15_beginning_year" DOUBLE,
"base_10_15_number_of_years" DOUBLE,
"base_10_15_ending_year" DOUBLE,
"base_5_beginning_year" DOUBLE,
"base_5_ending_year" DOUBLE
);CREATE TABLE sb_x7_7_table_2_method_for_population_estimates (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"department_of_finance_used" VARCHAR,
"persons_per_connection_used" VARCHAR,
"dwr_population_tool_used" VARCHAR,
"other_method_used" VARCHAR
);CREATE TABLE sb_x7_7_table_3_service_area_population (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"baseline_type" VARCHAR,
"baseline_order" BIGINT,
"baseline_year_1_to_15" BIGINT,
"baseline_year" DOUBLE,
"population" DOUBLE
);CREATE TABLE sb_x7_7_table_4_a_annual_gross_water_use (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"source_name" VARCHAR,
"own_or_purchased_imported" VARCHAR,
"baseline_type" VARCHAR,
"baseline_order" BIGINT,
"baseline_year_1_to_15" BIGINT,
"baseline_year" DOUBLE,
"source_volume_af" DOUBLE,
"meter_adjustment_af" DOUBLE,
"corrected_volume_af" DOUBLE
);CREATE TABLE sb_x7_7_table_4_annual_gross_water_use (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"baseline_type" VARCHAR,
"baseline_order" BIGINT,
"baseline_year_1_to_15" BIGINT,
"baseline_year" DOUBLE,
"volume_into_distrib_system_af" DOUBLE,
"exported_water_vol_af" DOUBLE,
"change_in_system_storage_vol_af" DOUBLE,
"indirect_recycled_water_vol_af" DOUBLE,
"water_deliv_for_ag_use_vol_af" DOUBLE,
"process_water_vol_af" DOUBLE,
"annual_gross_water_use_af" DOUBLE
);CREATE TABLE sb_x7_7_table_4_b_indirect_recycled_water_use_deduction (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"baseline_type" VARCHAR,
"baseline_order" BIGINT,
"baseline_year_1_to_15" BIGINT,
"baseline_year" DOUBLE,
"sra_vol_disch_from_reservoir_af" DOUBLE,
"sra_percent_recycled_water" DOUBLE,
"sra_recyc_water_delivered_af" BIGINT,
"sra_trans_treatment_loss_af" DOUBLE,
"sra_recyc_volume_enter_distrib_af" BIGINT,
"gr_recyc_pumped_by_utility_af" DOUBLE,
"gr_trans_treatment_loss_af" DOUBLE,
"gr_recyc_volume_enter_distrib_af" DOUBLE,
"total_deductible_volume_af" DOUBLE
);CREATE TABLE sb_x7_7_table_5_gallons_per_capita_per_day_gpcd (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"baseline_type" VARCHAR,
"baseline_order" BIGINT,
"baseline_year_1_to_15" BIGINT,
"baseline_year" DOUBLE,
"population" DOUBLE,
"annual_gross_water_use_af" DOUBLE,
"gpcd" DOUBLE
);CREATE TABLE sb_x7_7_table_6_gallons_per_capita_per_day (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"gpcd_10_15_year" DOUBLE,
"gpcd_5_year" DOUBLE,
"gpcd_2015" DOUBLE
);CREATE TABLE sb_x7_7_table_7_2020_target_method (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"target_method_for_2020" VARCHAR
);CREATE TABLE sb_x7_7_table_7_a_target_method_1_20_reduction (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"gpcd_10_15_year" DOUBLE,
"gpcd_20_percent_reduction" DOUBLE
);CREATE TABLE sb_x7_7_table_7_e_target_method_3 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"hydrologic_region_name" VARCHAR,
"hydrologic_region_selected" VARCHAR,
"hydrologic_region_percentage" DOUBLE,
"hydrologic_region_2020_target" BIGINT,
"hydrologic_region_meth3_target" BIGINT
);CREATE TABLE sb_x7_7_table_7_f_confirmed_minimum_reduction_for_2020_target (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"baseline_5_yr_gpcd" DOUBLE,
"maximum_2020_gpcd_target" DOUBLE,
"maximum_2020_gpcd_trgt_display" DOUBLE,
"calculated_2020_gpcd_target" DOUBLE,
"confirmed_2020_gpcd_target" DOUBLE
);CREATE TABLE sb_x7_7_table_8_2015_interim_target_gpcd (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"confirmed_2020_gpcd_target" DOUBLE,
"baseline_10_15_yr_gpcd" DOUBLE,
"interim_2015_gpcd_target" DOUBLE
);CREATE TABLE sb_x7_7_table_9_2015_compliance (
"org_id" DOUBLE,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"actual_2015_gpcd" DOUBLE,
"interim_2015_gpcd_target" DOUBLE,
"adj_from_extraordinary_events" DOUBLE,
"adj_from_weather_normalization" DOUBLE,
"adj_from_economic_adjustment" DOUBLE,
"adj_total" DOUBLE,
"adjusted_2015_gpcd" DOUBLE,
"gpcd_2015_adj_if_applicable" DOUBLE,
"reached_2015_reduction_target" VARCHAR,
"regional_alliance_name" VARCHAR
);CREATE TABLE supplemental_water_supplier_info_hydrologic_region_district (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"review_district" VARCHAR,
"hydrologic_region" VARCHAR
);CREATE TABLE table_0_1b_voluntary_energy_intensity_total_utility_approach (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"water_delivery_product" VARCHAR,
"reporting_period_start_date" TIMESTAMP,
"reporting_period_end_date" TIMESTAMP,
"volume_total_utility_af" DOUBLE,
"volume_hydropower_af" DOUBLE,
"volume_net_utility_af" DOUBLE,
"energy_total_utility_kwh" DOUBLE,
"energy_hydropower_kwh" DOUBLE,
"energy_net_utility_kwh" BIGINT,
"self_generated_renewable_kwh" DOUBLE,
"data_quality" VARCHAR,
"data_quality_narrative" VARCHAR,
"narrative" VARCHAR
);CREATE TABLE table_10_1_retail_notification_to_cities_and_counties (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"city_or_county" VARCHAR,
"name" VARCHAR,
"notice_60_day" VARCHAR,
"notice_of_public_hearing" VARCHAR
);Anyone who has the link will be able to view this.