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-07-23T14:30:21.804871
Tags: ab1668, making-conservation-a-california-way-of-life, managing-urban-water-use, sb606, urban-water-conservation-objectives

Tables

Annual Weather Data

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.annual_weather_data

34.94 KB
818 rows
14 columns


CREATE TABLE annual_weather_data (
  "dwr_id" BIGINT,
  "supplier_name" VARCHAR,
  "supplier_number" DOUBLE,
  "supplier_id" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "eto_inches" DOUBLE,
  "total_precipitation_inches" DOUBLE,
  "effective_precipitation_inches" DOUBLE,
  "alternative_data_provided" VARCHAR,
  "alternative_data_approval_status" VARCHAR,
  "alternative_data_approval_date" VARCHAR,
  "eto_inches_alternative" VARCHAR,
  "effective_precipitation_inches_alternative" VARCHAR
);

Data Dictionary - Annual Weather Data

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_annual_weather_data

3.51 KB
14 rows
4 columns


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

Data Dictionary - Potable Water Produced By URWS, Per Source

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_potable_water_produced_by_urws_per_source

5.51 KB
14 rows
4 columns


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

Data Dictionary - Real Water Loss: Data From Water Loss Audits

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_real_water_loss_data_from_water_loss_audits

7.62 KB
12 rows
4 columns


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

Data Dictionary - Seasonal Weather Data

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.data_dictionary_seasonal_weather_data

3.3 KB
11 rows
4 columns


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

Data Dictionary - Real Water Loss Budget: System-Specific Standards

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_real_water_loss_budget_system_specific_standards

3.77 KB
9 rows
4 columns


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

Data Dictionary - Res-Outdoor Budget: Landscape Area Measurement

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_res_outdoor_budget_landscape_area_measurement

3.67 KB
36 rows
4 columns


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

Data Dictionary - SB X7-7 Targets For Urban Retail Water Suppliers

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.n__dictionary_sb_x7_7_targets_for_urban_retail_water_suppliers

4.74 KB
8 rows
4 columns


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

Potable And Non-Potable Water Deliveries For URWS

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.potable_and_non_potable_water_deliveries_for_urws

532.34 KB
12185 rows
21 columns


CREATE TABLE potable_and_non_potable_water_deliveries_for_urws (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "reporting_period_start_date" TIMESTAMP,
  "reporting_period_end_date" TIMESTAMP,
  "residential_singlefamily_gal" DOUBLE,
  "residential_multifamily_gal" DOUBLE,
  "commercial_institutional_gal" DOUBLE,
  "nonresidential_metered_irrigation_gal" DOUBLE,
  "industrial_gal" DOUBLE,
  "other_gal" DOUBLE,
  "agriculture_gal" DOUBLE,
  "nonpotable_demand_residential_recycled_water_gal" DOUBLE,
  "nonpotable_demand_residential_nonpotable_water_gal" DOUBLE,
  "nonpotable_demand_residential_metered_landscape_irrigation_gal" DOUBLE,
  "nonpotable_demand_nonresidential_recycled_water_gal" DOUBLE,
  "nonpotable_demand_nonresidential_nonpotable_water_gal" DOUBLE,
  "nonpotable_demand_nonresidential_metered_irrigation_gal" DOUBLE,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

Potable Supply And Sold/Exported For URWS

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.potable_supply_and_sold_exported_for_urws

156.14 KB
12185 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
);

Potable Water Produced By URWS, Per Source

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.potable_water_produced_by_urws_per_source

772.57 KB
113090 rows
14 columns


CREATE TABLE potable_water_produced_by_urws_per_source (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "facility_name" VARCHAR,
  "facility_id" BIGINT,
  "facility_type" VARCHAR,
  "index_facility_id" VARCHAR,
  "sdwis_water_type" VARCHAR,
  "reporting_period_start_date" TIMESTAMP,
  "reporting_period_end_date" TIMESTAMP,
  "amount_produced_gallon" DOUBLE,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

Real Water Loss Budget: System-Specific Standards

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.real_water_loss_budget_system_specific_standards

36.19 KB
1060 rows
9 columns


CREATE TABLE real_water_loss_budget_system_specific_standards (
  "org_id" DOUBLE,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "real_water_loss_standard" DOUBLE,
  "standard_type" VARCHAR,
  "notes" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

Real Water Loss: Data From Water Loss Audits

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.real_water_loss_data_from_water_loss_audits

50.15 KB
1065 rows
12 columns


CREATE TABLE real_water_loss_data_from_water_loss_audits (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "pwsid" VARCHAR,
  "pws_name" VARCHAR,
  "reporting_start_date" TIMESTAMP,
  "reporting_end_date" TIMESTAMP,
  "wl_real_losses_vol_af" DOUBLE,
  "sd_num_service_conn" DOUBLE,
  "sd_length_mains_miles" DOUBLE,
  "latest_status" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP
);

SB X7-7 Targets For Urban Retail Water Suppliers

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.sb_x7_7_targets_for_urban_retail_water_suppliers

16.74 KB
404 rows
8 columns


CREATE TABLE sb_x7_7_targets_for_urban_retail_water_suppliers (
  "org_id" BIGINT,
  "supplier_name" VARCHAR,
  "confirmed_target_2020" DOUBLE,
  "indirect_recycled_water_vol" DOUBLE,
  "process_water_vol" DOUBLE,
  "units_of_measure" VARCHAR,
  "regional_alliance_name" VARCHAR,
  "alliance_met_target" VARCHAR
);

Seasonal Weather Data

@usgov.ca_gov_urban_water_use_objectives_conservation_64e6f.seasonal_weather_data

32.34 KB
818 rows
11 columns


CREATE TABLE seasonal_weather_data (
  "dwr_id" BIGINT,
  "supplier_name" VARCHAR,
  "supplier_number" DOUBLE,
  "supplier_id" VARCHAR,
  "fy_start_date" TIMESTAMP,
  "fy_end_date" TIMESTAMP,
  "seasonal_eto_inches" DOUBLE,
  "seasonal_peff_inches" DOUBLE,
  "seasonal_kc" DOUBLE,
  "seasonal_ie" DOUBLE,
  "seasonal_etf" DOUBLE
);