About this Dataset

Urban Water Use Objectives – Compiled Report Data

The Making Conservation a California Way of Life regulation requires urban retail water suppliers 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 the information submitted to the State Water Resources Control Board and the Department of Water Resources on the required reporting form. The values have been aggregated into individual tables that roughly correspond to the sections within the reporting form. The original submitted files can be found at the WUE Data Portal

To view the source data that pre-filled many of the fields within the reporting form, please visit this page.
Organization: State of California
Last updated: 2025-07-23T20:08:25.043500
Tags: ab1668, making-conservation-a-california-way-of-life, managing-urban-water-use, sb606, urban-water-conservation-objectives

Tables

Actual Water Use

@usgov.ca_gov_urban_water_use_objectives_compiled_report_data.actual_water_use

109.97 kB
361 rows
39 columns

CREATE TABLE actual_water_use (
  "supplier_name" VARCHAR,
  "org_id" BIGINT,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "awu_missing_data_flags" VARCHAR,
  "awu_volume_unit_flag" VARCHAR,
  "pwsid_incomplete_data_flag" VARCHAR,
  "awu_potable_sf_res_gal" DOUBLE,
  "awu_potable_mf_res_gal" DOUBLE,
  "awu_potable_total_res_gal" DOUBLE,
  "awu_recycl_res_gal" DOUBLE,
  "awu_nonpotable_non_recycl_res_gal" DOUBLE,
  "awu_nonpotable_res_irr_gal" DOUBLE,
  "awu_nonpotable_total_res_gal" DOUBLE,
  "awu_res_lam_excluded_irr_gal" DOUBLE,
  "awu_total_res_gal" DOUBLE,
  "awu_total_res_rgpcd" DOUBLE,
  "awu_potable_cii_dims_gal" DOUBLE,
  "awu_nonpotable_cii_dims_gal" DOUBLE,
  "awu_total_cii_dims_gal" DOUBLE,
  "awu_rwl_total_gal" DOUBLE,
  "awu_total_obj_relevant_demands_gal" DOUBLE,
  "awu_potable_ci_gal" DOUBLE,
  "awu_potable_i_gal" DOUBLE,
  "awu_potable_o_gal" DOUBLE,
  "awu_nonpotable_nonres_gal" DOUBLE,
  "awu_total_excl_demands_gal" DOUBLE,
  "awu_potable_comm_ag_gal" DOUBLE,
  "awu_nonpotable_comm_ag_gal" DOUBLE,
  "awu_sf_res_90pctile_gal" DOUBLE,
  "awu_mf_res_90pctile_gal" DOUBLE,
  "awu_cost_of_service_highest_users" DOUBLE,
  "awu_cost_of_service_analysis_link" VARCHAR,
  "awu_res_lam_excluded_irr_yn" VARCHAR,
  "awu_res_lam_assoc_dim_yn" VARCHAR,
  "awu_res_lam_assoc_dim_irr_gal" DOUBLE,
  "awu_res_lam_supplier_cii_yn" VARCHAR,
  "awu_res_lam_supplier_cii_gal" DOUBLE,
  "awu_comments" VARCHAR
);

Calculated Objectives

@usgov.ca_gov_urban_water_use_objectives_compiled_report_data.calculated_objectives

95.14 kB
361 rows
38 columns

CREATE TABLE calculated_objectives (
  "supplier_name" VARCHAR,
  "org_id" BIGINT,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "obj_ri_budget_gal" DOUBLE,
  "obj_ri_varn_prov_budget_gal" DOUBLE,
  "obj_ro_budget_gal" DOUBLE,
  "obj_ro_varn_prov_budget_gal" DOUBLE,
  "obj_ro_flag" VARCHAR,
  "obj_cii_dims_budget_gal" DOUBLE,
  "obj_cii_dims_varn_prov_budget_gal" BIGINT,
  "obj_rwl_budget_gal" DOUBLE,
  "obj_bi_budget_gal" DOUBLE,
  "obj_sum_no_ini_budget_gal" DOUBLE,
  "awu_potable_total_res_gal" DOUBLE,
  "awu_nonpotable_total_res_gal" DOUBLE,
  "awu_potable_cii_dims_gal" DOUBLE,
  "awu_nonpotable_cii_dims_gal" DOUBLE,
  "awu_rwl_total_gal" DOUBLE,
  "awu_total_obj_relevant_demands_gal" DOUBLE,
  "awu_volume_unit_flag" VARCHAR,
  "obj_ro_budget_20pct_ini_gal" DOUBLE,
  "obj_ini_included_yn" VARCHAR,
  "obj_sum_no_sbx_cap_gal" DOUBLE,
  "excl_demands_gal" DOUBLE,
  "obj_based_total_use_gal" DOUBLE,
  "sbx_target_gpcd" VARCHAR,
  "sbx_target_gal" DOUBLE,
  "sbx_process_water_gal" DOUBLE,
  "sbx_indirect_recycled_gal" DOUBLE,
  "sbx_target_total_use_gal" DOUBLE,
  "sbx_target_more_efficient_yn" VARCHAR,
  "sbx_minus_excl_flag" VARCHAR,
  "obj_budget_after_sbx_cap_gal" DOUBLE,
  "regional_alliance_name" VARCHAR,
  "regional_target_met" VARCHAR,
  "obj_final_gal" DOUBLE,
  "objective_flag" VARCHAR
);

Data Dictionary - Actual Water Use

@usgov.ca_gov_urban_water_use_objectives_compiled_report_data.data_dictionary_actual_water_use

8.49 kB
39 rows
4 columns

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

Data Dictionary - Calculated Objectives

@usgov.ca_gov_urban_water_use_objectives_compiled_report_data.data_dictionary_calculated_objectives

10.65 kB
38 rows
4 columns

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