Urban Water Management Plans (UWMP) 2015

CREATE TABLE table_2_1_retail_only_public_water_systems (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "public_water_system_number" VARCHAR,
  "public_water_system_name" VARCHAR,
  "number_municipal_connections" DOUBLE,
  "volume_of_water_supplied_af" DOUBLE
);

CREATE TABLE table_2_2_plan_identification (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "individual_uwmp" VARCHAR,
  "regional_uwmp" VARCHAR,
  "ruwmp_incl_regional_alliance" VARCHAR,
  "regional_plan" VARCHAR
);

CREATE TABLE table_2_3_agency_identification (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "agency_is_a_wholesaler" VARCHAR,
  "agency_is_a_retailer" VARCHAR,
  "fiscal_or_calendar_year" VARCHAR,
  "fiscal_month_day_mm_dd" VARCHAR,
  "units_of_measure" VARCHAR
);

CREATE TABLE table_2_4_retail_water_supplier_information_exchange (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "wholesale_water_supplier_name" VARCHAR
);

CREATE TABLE table_2_4_wholesale_water_supplier_information_exchange (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "other_water_supplier_name" 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 table_3_1_retail_population_current_and_projected (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "population_served_2015" DOUBLE,
  "population_served_2020" DOUBLE,
  "population_served_2025" DOUBLE,
  "population_served_2030" DOUBLE,
  "population_served_2035" DOUBLE,
  "population_served_2040" DOUBLE
);

CREATE TABLE table_3_1_wholesale_population_current_and_projected (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "population_served_2015" BIGINT,
  "population_served_2020" BIGINT,
  "population_served_2025" BIGINT,
  "population_served_2030" BIGINT,
  "population_served_2035" BIGINT,
  "population_served_2040" DOUBLE
);

CREATE TABLE table_4_1_retail_demands_for_potable_and_raw_water_actual (
  "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,
  "level_of_treatment" VARCHAR,
  "volume_af" DOUBLE
);

CREATE TABLE table_4_1_wholesale_demands_for_potable_and_raw_water_actual (
  "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,
  "level_of_treatment" VARCHAR,
  "volume_af" DOUBLE
);

CREATE TABLE table_4_2_retail_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_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 table_4_3_retail_total_water_demands (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "water_demand_type" VARCHAR,
  "water_demand_volume_2015_af" DOUBLE,
  "water_demand_volume_2020_af" DOUBLE,
  "water_demand_volume_2025_af" DOUBLE,
  "water_demand_volume_2030_af" DOUBLE,
  "water_demand_volume_2035_af" DOUBLE,
  "water_demand_volume_2040_af" DOUBLE
);

CREATE TABLE table_4_3_wholesale_total_water_demands (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "water_demand_type" VARCHAR,
  "water_demand_volume_2015_af" DOUBLE,
  "water_demand_volume_2020_af" DOUBLE,
  "water_demand_volume_2025_af" DOUBLE,
  "water_demand_volume_2030_af" DOUBLE,
  "water_demand_volume_2035_af" DOUBLE,
  "water_demand_volume_2040_af" DOUBLE
);

CREATE TABLE table_4_4_retail_12_month_water_loss_audit_reporting (
  "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__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 table_4_5_retail_only_inclusion_in_water_use_projections (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "future_water_savings_included" VARCHAR,
  "citation_locations_in_uwmp" VARCHAR,
  "lower_income_res_dem_included" VARCHAR
);

CREATE TABLE table_5_1_baselines_and_targets_summary (
  "org_id" DOUBLE,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "base_10_15_start_year" DOUBLE,
  "base_10_15_end_year" DOUBLE,
  "base_5_start_year" DOUBLE,
  "base_5_end_year" DOUBLE,
  "base_10_15_average_gpcd" DOUBLE,
  "base_5_average_gpcd" DOUBLE,
  "interim_2015_gpcd_target" DOUBLE,
  "confirmed_2020_gpcd_target" DOUBLE
);

CREATE TABLE table_5_2_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 table_6_1_retail_groundwater_volume_pumped (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "groundwater_type" VARCHAR,
  "location_or_basin_name" VARCHAR,
  "groundwater_volume_pumped_2011_af" DOUBLE,
  "groundwater_volume_pumped_2012_af" DOUBLE,
  "groundwater_volume_pumped_2013_af" DOUBLE,
  "groundwater_volume_pumped_2014_af" DOUBLE,
  "groundwater_volume_pumped_2015_af" DOUBLE
);

CREATE TABLE table_6_1_retail_groundwater_volume_pumped_addl_info (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "supplier_does_not_pump_grwater" VARCHAR
);

CREATE TABLE table_6_1_wholesale_groundwater_volume_pumped (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "groundwater_type" VARCHAR,
  "location_or_basin_name" VARCHAR,
  "groundwater_volume_pumped_2011_af" DOUBLE,
  "groundwater_volume_pumped_2012_af" DOUBLE,
  "groundwater_volume_pumped_2013_af" DOUBLE,
  "groundwater_volume_pumped_2014_af" DOUBLE,
  "groundwater_volume_pumped_2015_af" DOUBLE
);

CREATE TABLE table_6_1_wholesale_groundwater_volume_pumped_addl_info (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "supplier_does_not_pump_grwater" VARCHAR
);

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_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_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_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_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_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_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_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_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_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_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 table_6_6_retail_methods_to_expand_future_recycled_water_use (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "worksheet_name" VARCHAR,
  "reviewed_by_dwr" VARCHAR,
  "requirements_addressed" VARCHAR,
  "wp_wuedata_plan_id" BIGINT,
  "name_of_action" VARCHAR,
  "description" VARCHAR,
  "planned_implementation_year" DOUBLE,
  "expected_increase_in_recyc_use_af" DOUBLE
);

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_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
);

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_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 table_6_8_retail_water_supplies_actual (
  "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,
  "actual_volume_af" DOUBLE,
  "water_quality" VARCHAR,
  "total_right_or_safe_yield_af" DOUBLE
);

CREATE TABLE table_6_8_wholesale_water_supplies_actual (
  "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,
  "actual_volume_af" DOUBLE,
  "water_quality" VARCHAR,
  "total_right_or_safe_yield_af" DOUBLE
);

CREATE TABLE table_6_9_retail_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_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 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 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 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 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 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
);

CREATE TABLE table_10_1_wholesale_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
);

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 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_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_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_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 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 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 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_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_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 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
);

CREATE TABLE supplemental_water_supplier_info_hydrologic_region_district (
  "org_id" BIGINT,
  "water_supplier_name" VARCHAR,
  "review_district" VARCHAR,
  "hydrologic_region" VARCHAR
);