About this Dataset

Drinking Water - Public Water System Operations Monthly Water Production And Conservation Information

Monthly reports of the larger urban water suppliers in California on water production and conservation activities, from the California State Water Resources Control Board's Conservation Portal.
Organization: State of California
Last updated: 2023-07-24T03:39:22.586652
Tags: conservation, drought, production, supplier, urban, uws, water, water-supply

Tables

Urban Water Supplier Monitoring Reports

@usgov.ca_gov_drinking_water_public_water_system_operations_m_6c6b0e7d.urban_water_supplier_monitoring_reports

2.29 MB
42,469 rows
29 columns

CREATE TABLE urban_water_supplier_monitoring_reports (
  "supplier_name" VARCHAR,
  "public_water_system_id" VARCHAR,
  "reporting_month" TIMESTAMP,
  "county" VARCHAR,
  "hydrologic_region" VARCHAR,
  "climate_zone" BIGINT,
  "total_population_served" DOUBLE,
  "reference_2014_population" BIGINT,
  "county_under_drought_declaration" VARCHAR,
  "water_shortage_contingency_stage_invoked" VARCHAR,
  "water_shortage_level_indicator" VARCHAR,
  "dwr_state_standard_level_corresponding_to_stage" VARCHAR,
  "water_production_units" VARCHAR,
  "reported_preliminary_total_potable_water_production" VARCHAR,
  "reported_final_total_potable_water_production" VARCHAR,
  "preliminary_percent_residential_use" VARCHAR,
  "final_percent_residential_use" VARCHAR,
  "reported_preliminary_commercial_agricultural_water" VARCHAR,
  "reported_final_commercial_agricultural_water" VARCHAR,
  "reported_preliminary_commercial_industrial_and_institu_6a74643f" VARCHAR  -- Reported Preliminary Commercial Industrial And Institutional Water,
  "reported_final_commercial_industrial_and_institutional_water" VARCHAR,
  "reported_recycled_water" VARCHAR,
  "reported_non_revenue_water" VARCHAR,
  "calculated_total_potable_water_production_gallons_ag_excluded" DOUBLE,
  "calculated_total_potable_water_production_gallons_2013_2f57baf8" DOUBLE  -- Calculated Total Potable Water Production Gallons 2013 Ag Excluded,
  "calculated_commercial_agricultural_water_gallons" VARCHAR,
  "calculated_commercial_agricultural_water_gallons_2013" DOUBLE,
  "calculated_r_gpcd" DOUBLE,
  "qualification" VARCHAR
);