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__0_1a_voluntary_energy_intensity_water_supply_proces_6e98cb92 (
"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_extract_and_divert_af" DOUBLE,
"volume_place_into_storage_af" DOUBLE,
"volume_conveyance_af" DOUBLE,
"volume_treatment_af" DOUBLE,
"volume_distribution_af" DOUBLE,
"volume_total_utility_af" DOUBLE,
"volume_hydropower_af" DOUBLE,
"volume_net_utility_af" DOUBLE,
"energy_extract_and_divert_kwh" DOUBLE,
"energy_place_into_storage_kwh" DOUBLE,
"energy_conveyance_kwh" DOUBLE,
"energy_treatment_kwh" DOUBLE,
"energy_distribution_kwh" DOUBLE,
"energy_total_utility_kwh" DOUBLE,
"energy_hydropower_kwh" DOUBLE,
"energy_net_utility_kwh" DOUBLE,
"self_generated_renewable_kwh" DOUBLE,
"data_quality" VARCHAR,
"data_quality_narrative" VARCHAR,
"narrative" VARCHAR
);CREATE TABLE n__0_1c_voluntary_energy_intensity_multiple_water_deli_4f59c7e1 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"reporting_period_start_date" TIMESTAMP,
"reporting_period_end_date" TIMESTAMP,
"self_generated_renewable_kwh" VARCHAR,
"data_quality" VARCHAR,
"data_quality_narrative" VARCHAR,
"narrative" VARCHAR
);CREATE TABLE n__0_1c_voluntary_energy_intensity_multiple_water_deli_a47e312b (
"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,
"water_delivery_product_units" VARCHAR,
"product_extract_and_divert" DOUBLE,
"product_place_into_storage" VARCHAR,
"product_conveyance" VARCHAR,
"product_treatment" VARCHAR,
"product_distribution" VARCHAR,
"product_total_utility_kwh" DOUBLE,
"product_hydropower" VARCHAR,
"product_net_utility_kwh" DOUBLE,
"production_volume_in_acre_feet" VARCHAR,
"product_total_utility_kwh_af" VARCHAR,
"product_net_utility_kwh_af" VARCHAR
);CREATE TABLE n__0_2_voluntary_energy_intensity_wastewater_recycled_water (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"reporting_period_start_date" TIMESTAMP,
"reporting_period_end_date" TIMESTAMP,
"wastewtr_collection_convey_af" DOUBLE,
"wastewtr_treatment_af" DOUBLE,
"wastewtr_discharge_distrib_af" DOUBLE,
"wastewtr_total_af" DOUBLE,
"wastewtr_collection_convey_kwh" DOUBLE,
"wastewtr_treatment_kwh" DOUBLE,
"wastewtr_discharge_distrib_kwh" DOUBLE,
"wastewtr_total_kwh" DOUBLE,
"recycwtr_collection_convey_af" DOUBLE,
"recycwtr_treatment_af" DOUBLE,
"recycwtr_discharge_distrib_af" DOUBLE,
"recycwtr_total_af" BIGINT,
"recycwtr_collection_convey_kwh" DOUBLE,
"recycwtr_treatment_kwh" DOUBLE,
"recycwtr_discharge_distrib_kwh" DOUBLE,
"recycwtr_total_kwh" DOUBLE,
"self_generated_renewable_kwh" DOUBLE,
"data_quality" VARCHAR,
"data_quality_narrative" VARCHAR,
"narrative" VARCHAR
);CREATE TABLE n__10_1_wholesale_notification_to_cities_and_counties__f2bc9bd8 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"over_10_city_county_notified" VARCHAR,
"entity_list_location_in_uwmp" VARCHAR
);CREATE TABLE n__2_4_wholesale_water_supplier_information_exchange_addl_info (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"over_10_suppliers_informed" VARCHAR,
"supplier_list_location_in_uwmp" VARCHAR
);CREATE TABLE n__4_2_wholesale_demands_for_potable_and_raw_water_projected (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"use_type" VARCHAR,
"additional_description" VARCHAR,
"projected_water_use_2020_af" DOUBLE,
"projected_water_use_2025_af" DOUBLE,
"projected_water_use_2030_af" DOUBLE,
"projected_water_use_2035_af" DOUBLE,
"projected_water_use_2040_af" DOUBLE
);CREATE TABLE n__4_4_wholesale_water_loss_summary_most_recent_12_mon_02272ec1 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"rep_period_start_month_year" VARCHAR,
"water_losses_volume_af" DOUBLE
);CREATE TABLE n__6_2_retail_wastewater_collected_within_service_area_6b3e0a19 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"wastewater_not_collect_in_area" VARCHAR,
"percent_2015_area_covered_wwcs" DOUBLE,
"percent_2015_pop_covered_wwcs" DOUBLE
);CREATE TABLE n__6_2_retail_wastewater_collected_within_service_area_in_2015 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"wastewater_collection_agency" VARCHAR,
"volume_metered_or_estimated" VARCHAR,
"volume_collected_2015_af" DOUBLE,
"wastewater_treatment_agency" VARCHAR,
"treatment_plant_name" VARCHAR,
"wwtp_located_within_uwmp_area" VARCHAR,
"wwtp_contracted_to_3rd_party" VARCHAR
);CREATE TABLE n__6_3_retail_wastewater_treatment_and_discharge_withi_0a64000f (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"wastewater_treatment_plant" VARCHAR,
"discharge_location_name_or_id" VARCHAR,
"discharge_location_description" VARCHAR,
"wastewater_discharge_id_number" VARCHAR,
"method_of_disposal" VARCHAR,
"treats_ww_generated_out_area" VARCHAR,
"treatment_level" VARCHAR,
"wastewater_treated_volume_af" DOUBLE,
"discharge_treated_ww_volume_af" DOUBLE,
"recycled_within_area_volume_af" DOUBLE,
"recycled_outside_area_volume_af" DOUBLE
);CREATE TABLE n__6_3_retail_wastewater_treatment_and_discharge_withi_b0073af2 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"ww_not_treat_disposed_in_area" VARCHAR
);CREATE TABLE n__6_3_wholesale_wastewater_treatment_and_discharge_wi_43900680 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"wastewater_treatment_plant" VARCHAR,
"discharge_location_name_or_id" VARCHAR,
"discharge_location_description" VARCHAR,
"wastewater_discharge_id_number" DOUBLE,
"method_of_disposal" VARCHAR,
"treats_ww_generated_out_area" VARCHAR,
"treatment_level" VARCHAR,
"wastewater_treated_volume_af" BIGINT,
"discharge_treated_ww_volume_af" DOUBLE,
"recycled_within_area_volume_af" DOUBLE,
"recycled_outside_area_volume_af" DOUBLE
);CREATE TABLE n__6_3_wholesale_wastewater_treatment_and_discharge_wi_74938c53 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"recycled_water_not_sup_treated" VARCHAR
);CREATE TABLE n__6_4_retail_current_and_projected_recycled_water_dir_1bbd075d (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"recycled_water_not_used" VARCHAR,
"agency_treating_recycled_water" VARCHAR,
"agency_operating_treatment_sys" VARCHAR,
"supplemental_water_volume_af" DOUBLE,
"source_of_supplemental_water" VARCHAR
);CREATE TABLE n__6_4_retail_current_and_projected_recycled_water_dir_a1319a2f (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"recycled_water_not_used" VARCHAR,
"agency_treating_recycled_water" VARCHAR,
"agency_operating_treatment_sys" VARCHAR,
"supplemental_water_volume" DOUBLE,
"source_of_supplemental_water" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"beneficial_use_type" VARCHAR,
"description" VARCHAR,
"level_of_treatment" VARCHAR,
"beneficial_use_volume_2015" DOUBLE,
"beneficial_use_volume_2020" DOUBLE,
"beneficial_use_volume_2025" DOUBLE,
"beneficial_use_volume_2030" DOUBLE,
"beneficial_use_volume_2035" DOUBLE,
"beneficial_use_volume_2040" DOUBLE,
"ut_uwmp_table_6_4_r_info_id" BIGINT,
"units_of_measure" VARCHAR
);CREATE TABLE n__6_4_wholesale_current_and_projected_retailers_provi_290ee98b (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"recycled_water_not_treat_dist" VARCHAR
);CREATE TABLE n__6_4_wholesale_current_and_projected_retailers_provi_33beb32c (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"receiving_supplier_direct_use" VARCHAR,
"level_of_treatment" VARCHAR,
"beneficial_use_volume_2015_af" DOUBLE,
"beneficial_use_volume_2020_af" DOUBLE,
"beneficial_use_volume_2025_af" DOUBLE,
"beneficial_use_volume_2030_af" DOUBLE,
"beneficial_use_volume_2035_af" DOUBLE,
"beneficial_use_volume_2040_af" DOUBLE
);CREATE TABLE n__6_5_retail_2010_uwmp_recycled_water_use_projection__8885cde4 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"recyc_water_not_proj_for_use" VARCHAR
);CREATE TABLE n__6_5_retail_2010_uwmp_recycled_water_use_projection__e3471c37 (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"use_type" VARCHAR,
"use_type_other" VARCHAR,
"projections_in_2010_for_2015_af" DOUBLE,
"actual_2015_use_af" DOUBLE,
"other_flag" VARCHAR
);CREATE TABLE n__6_5_wholesale_2010_uwmp_recycled_water_use_projecti_2125357d (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"recyc_water_not_proj_for_use" VARCHAR
);CREATE TABLE n__6_5_wholesale_2010_uwmp_recycled_water_use_projecti_ee88d55b (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"receiving_supplier_direct_use" VARCHAR,
"projections_in_2010_for_2015_af" DOUBLE,
"actual_2015_use_af" BIGINT
);CREATE TABLE n__6_6_retail_methods_to_expand_future_recycled_water__3b247caa (
"org_id" BIGINT,
"water_supplier_name" VARCHAR,
"worksheet_name" VARCHAR,
"reviewed_by_dwr" VARCHAR,
"requirements_addressed" VARCHAR,
"wp_wuedata_plan_id" BIGINT,
"supplier_no_plans_expansion" VARCHAR,
"does_not_plan_location_in_uwmp" VARCHAR
);CREATE TABLE n__6_7_retail_expected_future_water_supply_projects_or_67de615d (
"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__6_7_retail_expected_future_water_supply_projects_or_programs (
"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
);Anyone who has the link will be able to view this.