About this Dataset

Urban Water Use Objectives – Relevant Data

The Making Conservation a California Way of Life regulation requires urban retail water suppliers (URWS) to annually calculate their Urban Water Use Objective (UWUO), which is the sum of efficiency budgets for a subset of urban water uses: residential indoor water use, residential outdoor water use, real water loss and commercial, industrial and institutional landscapes with dedicated irrigation meters. Each efficiency budget will be calculated using a statewide efficiency standard and local service area characteristics such as population, climate, and landscape area. Where relevant, suppliers may also include in their objective “variances” for unique uses, or a bonus incentive for potable recycled water use.

This dataset contains information gathered from reports submitted to the State Water Board, the Department of Water Resources, and other relevant information sources. It also contains information derived by the Board and the Department for the purpose of the regulation. The values in these tables are used to pre-fill a number of fields within the UWUO reporting form that URWS are required to submit by January 1 of each year, starting in 2025.

To view the submitted values, please visit this page.
Organization: State of California
Last updated: 2025-09-23T12:47:37.612370
Tags: ab1668, making-conservation-a-california-way-of-life, managing-urban-water-use, sb606, urban-water-conservation-objectives

Tables

CII Service Connections

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.cii_service_connections

40.73 kB
1,058 rows
12 columns

CREATE TABLE cii_service_connections (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "ci_metered" BIGINT,
  "ci_unmetered" DOUBLE,
  "i_metered" BIGINT,
  "i_unmetered" DOUBLE,
  "li_metered" BIGINT,
  "li_unmetered" DOUBLE,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

Data Dictionary - CII Service Connections

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_cii_service_connections

3.4 kB
12 rows
4 columns

CREATE TABLE data_dictionary_cii_service_connections (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Potable Supply And Sold/Exported For URWS

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_potable_supply_and_sold_exported_for_urws

4.78 kB
10 rows
4 columns

CREATE TABLE data_dictionary_potable_supply_and_sold_exported_for_urws (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Emergency And High Total Dissolved Solids (TDS) Variances

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.emergency_and_high_total_dissolved_solids_tds_variances

37.16 kB
404 rows
37 columns

CREATE TABLE emergency_and_high_total_dissolved_solids_tds_variances (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "rod_thresh_5pct_vol" VARCHAR,
  "rod_thresh_1pct_vol" VARCHAR,
  "rod_varn_state_local_emergency_yn" VARCHAR,
  "rod_varn_high_tds_yn" VARCHAR,
  "rod_varn_state_local_emergency_ro_water_gal" VARCHAR,
  "rod_varn_state_local_emergency_dim_gal" VARCHAR,
  "rod_varn_state_local_emergency_gal" VARCHAR,
  "rod_varn_state_local_emergency_5pct_thresh_met_yn" VARCHAR,
  "rod_varn_high_tds_method" VARCHAR,
  "rod_varn_high_tds_ro_sqft" VARCHAR,
  "rod_varn_high_tds_dim_sqft" VARCHAR,
  "rod_varn_high_tds_concentration" VARCHAR,
  "rod_varn_high_tds_lef" VARCHAR,
  "rod_varn_high_tds_5pct_thresh_ro_gal" VARCHAR,
  "rod_varn_high_tds_5pct_thresh_dim_gal" VARCHAR,
  "rod_varn_high_tds_5pct_thresh_gal" VARCHAR,
  "rod_varn_high_tds_5pct_thresh_met_yn" VARCHAR,
  "rod_varn_high_tds_plant_factor" VARCHAR,
  "rod_varn_high_tds_recycl_salinity" VARCHAR,
  "rod_varn_high_tds_plant_salinity_thresh" VARCHAR,
  "rod_varn_high_tds_leach_req" VARCHAR,
  "rod_varn_high_tds_sprinkler_lef" VARCHAR,
  "rod_varn_high_tds_drip_lef" VARCHAR,
  "rod_varn_high_tds_sprinkler_ro_sqft" VARCHAR,
  "rod_varn_high_tds_sprinkler_dim_sqft" VARCHAR,
  "rod_varn_high_tds_drip_ro_sqft" VARCHAR,
  "rod_varn_high_tds_drip_dim_sqft" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_sprinkler_ro_gal" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_sprinkler_dim_gal" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_drip_ro_gal" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_drip_dim_gal" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_gal" VARCHAR,
  "rod_varn_high_tds_1pct_thresh_met_yn" VARCHAR
);

Data Dictionary - Emergency And High Total Dissolved Solids (TDS) Variances

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_emergency_and_high_total_dissolved_solid_0002f04b

7.88 kB
37 rows
4 columns

CREATE TABLE n__dictionary_emergency_and_high_total_dissolved_solid_0002f04b (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Potable And Non-Potable Water Deliveries For URWS

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_potable_and_non_potable_water_deliveries_for_urws

6.85 kB
21 rows
4 columns

CREATE TABLE n__dictionary_potable_and_non_potable_water_deliveries_for_urws (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Residential Indoor Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_residential_indoor_variances_and_tempora_1b86f4a0

9.72 kB
46 rows
4 columns

CREATE TABLE n__dictionary_residential_indoor_variances_and_tempora_1b86f4a0 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Residential Outdoor Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_residential_outdoor_variances_and_tempor_2214d0ab

9.58 kB
57 rows
4 columns

CREATE TABLE n__dictionary_residential_outdoor_variances_and_tempor_2214d0ab (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Submissions And Approvals For Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_submissions_and_approvals_for_variances__b7d841af

5.46 kB
35 rows
4 columns

CREATE TABLE n__dictionary_submissions_and_approvals_for_variances__b7d841af (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Potable Supply And Sold/Exported For URWS

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.potable_supply_and_sold_exported_for_urws

161.89 kB
12,545 rows
10 columns

CREATE TABLE potable_supply_and_sold_exported_for_urws (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "reporting_period_start_date" TIMESTAMP,
  "reporting_period_end_date" TIMESTAMP,
  "total_potablesupply_gal" DOUBLE,
  "pd_volumesold_delivered_other_watersystems_gal" DOUBLE,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

Residential Indoor Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.residential_indoor_variances_and_temporary_provisions

42.24 kB
404 rows
46 columns

CREATE TABLE residential_indoor_variances_and_temporary_provisions (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "ri_thresh_5pct_vol" VARCHAR,
  "ri_thresh_1pct_vol" VARCHAR,
  "ri_varn_evap_cooler_yn" VARCHAR,
  "ri_varn_sn_pop_yn" VARCHAR,
  "ri_provn_wastewater_yn" VARCHAR,
  "ri_varn_evap_cooler_n_res_sc" VARCHAR,
  "ri_varn_evap_cooler_n_sc_ss" VARCHAR,
  "ri_varn_evap_cooler_num" VARCHAR,
  "ri_varn_evap_cooler_num_op_days" VARCHAR,
  "ri_varn_evap_cooler_avg_daily_hours" VARCHAR,
  "ri_varn_evap_cooler_avg_air_er" VARCHAR,
  "ri_varn_evap_cooler_avg_daily_dtbulb" VARCHAR,
  "ri_varn_evap_cooler_efficiency" VARCHAR,
  "ri_varn_evap_cooler_unit_conv" VARCHAR,
  "ri_varn_evap_cooler_rec" VARCHAR,
  "ri_varn_evap_cooler_gal" VARCHAR,
  "ri_varn_evap_cooler_5pct_thresh_met_yn" VARCHAR,
  "ri_varn_sn_pop_occ_rate_calc_method" VARCHAR,
  "ri_varn_sn_pop_indoor_gpcd_jul_dec" VARCHAR,
  "ri_varn_sn_pop_num_dwell_jul_dec" VARCHAR,
  "ri_varn_sn_pop_n_srooms_jul_dec" VARCHAR,
  "ri_varn_sn_pop_prooms_jul_dec" VARCHAR,
  "ri_varn_sn_pop_avg_pph_jul_dec" VARCHAR,
  "ri_varn_sn_pop_avg_sdays_jul_dec" VARCHAR,
  "ri_varn_sn_pop_wso_jul_dec" VARCHAR,
  "ri_varn_sn_pop_wpo_jul_dec" VARCHAR,
  "ri_varn_sn_pop_occ_rate_jul_dec" VARCHAR,
  "ri_varn_sn_pop_gal_jul_dec" VARCHAR,
  "ri_varn_sn_pop_indoor_gpcd_jan_jun" VARCHAR,
  "ri_varn_sn_pop_num_dwell_jan_jun" VARCHAR,
  "ri_varn_sn_pop_n_srooms_jan_jun" VARCHAR,
  "ri_varn_sn_pop_prooms_jan_jun" VARCHAR,
  "ri_varn_sn_pop_avg_pph_jan_jun" VARCHAR,
  "ri_varn_sn_pop_avg_sdays_jan_jun" VARCHAR,
  "ri_varn_sn_pop_wso_jan_jun" VARCHAR,
  "ri_varn_sn_pop_wpo_jan_jun" VARCHAR,
  "ri_varn_sn_pop_occ_rate_jan_jun" VARCHAR,
  "ri_varn_sn_pop_gal_jan_jun" VARCHAR,
  "ri_varn_sn_pop_gal" VARCHAR,
  "ri_varn_sn_pop_5pct_thresh_met_yn" VARCHAR,
  "ri_varn_sn_pop_1pct_thresh_met_yn" VARCHAR,
  "ri_provn_wastewater_gal" VARCHAR
);

Residential Outdoor Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.residential_outdoor_variances_and_temporary_provisions

51.69 kB
404 rows
57 columns

CREATE TABLE residential_outdoor_variances_and_temporary_provisions (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "ro_thresh_5pct_vol" VARCHAR,
  "ro_thresh_1pct_vol" VARCHAR,
  "ro_varn_livestock_yn" VARCHAR,
  "ro_varn_dust_control_yn" VARCHAR,
  "ro_varn_res_ag_yn" VARCHAR,
  "ro_varn_ponds_lakes_yn" VARCHAR,
  "ro_provn_new_climate_ready_trees_yn" VARCHAR,
  "ro_provn_qual_landscapes_yn" VARCHAR,
  "ro_varn_livestock_num_sheep" VARCHAR,
  "ro_varn_livestock_water_use_sheep" VARCHAR,
  "ro_varn_livestock_num_hogs_goats" VARCHAR,
  "ro_varn_livestock_water_use_hogs_goats" VARCHAR,
  "ro_varn_livestock_num_med" VARCHAR,
  "ro_varn_livestock_water_use_med" VARCHAR,
  "ro_varn_livestock_num_over_500_lbs" VARCHAR,
  "ro_varn_livestock_water_use_over_500_lbs" VARCHAR,
  "ro_varn_livestock_num_horses_mules" VARCHAR,
  "ro_varn_livestock_water_use_horses_mules" VARCHAR,
  "ro_varn_livestock_num_cows" VARCHAR,
  "ro_varn_livestock_water_use_cows" VARCHAR,
  "ro_varn_livestock_gal" VARCHAR,
  "ro_varn_livestock_5pct_thresh_met_yn" VARCHAR,
  "ro_varn_dust_control_corral_sqft" VARCHAR,
  "ro_varn_dust_control_alt_corral_sqft" VARCHAR,
  "ro_varn_dust_control_water_ndays_week" VARCHAR,
  "ro_varn_dust_control_water_ndays_year" VARCHAR,
  "ro_varn_dust_control_conv_factor_ft_per_day" VARCHAR,
  "ro_varn_dust_control_conv_factor_gal_per_cuft" VARCHAR,
  "ro_varn_dust_control_gal" VARCHAR,
  "ro_varn_dust_control_5pct_thresh_met_yn" VARCHAR,
  "ro_varn_res_ag_method" VARCHAR,
  "ro_varn_res_ag_sqft" VARCHAR,
  "ro_varn_res_ag_seasonal_et0" VARCHAR,
  "ro_varn_res_ag_seasonal_eff_precip" VARCHAR,
  "ro_varn_res_ag_seasonal_net_et0" VARCHAR,
  "ro_varn_res_ag_crop_coeff" VARCHAR,
  "ro_varn_res_ag_irr_eff" VARCHAR,
  "ro_varn_res_ag_seasonal_lef" VARCHAR,
  "ro_varn_res_ag_5pct_thresh_gal" VARCHAR,
  "ro_varn_res_ag_5pct_thresh_met_yn" VARCHAR,
  "ro_varn_res_ag_1pct_thresh_gal" VARCHAR,
  "ro_varn_res_ag_1pct_thresh_met_yn" VARCHAR,
  "ro_varn_ponds_lakes_sqft" VARCHAR,
  "ro_varn_ponds_lakes_ann_precip" VARCHAR,
  "ro_varn_ponds_lakes_gal" VARCHAR,
  "ro_provn_new_climate_ready_trees_lef" VARCHAR,
  "ro_provn_new_climate_ready_trees_num" VARCHAR,
  "ro_provn_new_climate_ready_trees_ndays_week" VARCHAR,
  "ro_provn_new_climate_ready_trees_ndays_year" VARCHAR,
  "ro_provn_new_climate_ready_trees_gal" VARCHAR,
  "ro_provn_qual_landscapes_lef" VARCHAR,
  "ro_provn_qual_landscapes_sqft" VARCHAR,
  "ro_provn_qual_landscapes_gal" VARCHAR
);

Submissions And Approvals For Variances And Temporary Provisions

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.submissions_and_approvals_for_variances_and_temporary__c9e96f7b

36.33 kB
405 rows
35 columns

CREATE TABLE submissions_and_approvals_for_variances_and_temporary__c9e96f7b (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "ri_varn_evap_cooler_submission_date" VARCHAR,
  "ri_varn_evap_cooler_approval_status" VARCHAR,
  "ri_varn_evap_cooler_approval_date" VARCHAR,
  "ri_varn_sn_pop_submission_date" VARCHAR,
  "ri_varn_sn_pop_approval_status" VARCHAR,
  "ri_varn_sn_pop_approval_date" VARCHAR,
  "ri_provn_wastewater_submission_date" VARCHAR,
  "ri_provn_wastewater_approval_status" VARCHAR,
  "ri_provn_wastewater_approval_date" VARCHAR,
  "ro_varn_livestock_submission_date" VARCHAR,
  "ro_varn_livestock_approval_status" VARCHAR,
  "ro_varn_livestock_approval_date" VARCHAR,
  "ro_varn_dust_control_submission_date" VARCHAR,
  "ro_varn_dust_control_approval_status" VARCHAR,
  "ro_varn_dust_control_approval_date" VARCHAR,
  "ro_varn_res_ag_submission_date" VARCHAR,
  "ro_varn_res_ag_approval_status" VARCHAR,
  "ro_varn_res_ag_approval_date" VARCHAR,
  "ro_varn_ponds_lakes_submission_date" VARCHAR,
  "ro_varn_ponds_lakes_approval_status" VARCHAR,
  "ro_varn_ponds_lakes_approval_date" VARCHAR,
  "ro_provn_new_climate_ready_trees_submission_date" VARCHAR,
  "ro_provn_new_climate_ready_trees_approval_status" VARCHAR,
  "ro_provn_new_climate_ready_trees_approval_date" VARCHAR,
  "ro_provn_qual_landscapes_submission_date" VARCHAR,
  "ro_provn_qual_landscapes_approval_status" VARCHAR,
  "ro_provn_qual_landscapes_approval_date" VARCHAR,
  "ro_varn_state_local_emergency_submission_date" VARCHAR,
  "ro_varn_state_local_emergency_approval_status" VARCHAR,
  "ro_varn_state_local_emergency_approval_date" VARCHAR,
  "ro_varn_high_tds_submission_date" VARCHAR,
  "ro_varn_high_tds_approval_status" VARCHAR,
  "ro_varn_high_tds_approval_date" VARCHAR
);