About this Dataset

Volumetric Annual Report Of Wastewater And Recycled Water

The Water Quality Control Policy for Recycled Water (Recycled Water Policy) requires wastewater and recycled water dischargers (including dischargers that do not produce any recycled water) to annually report monthly volumes of influent, wastewater produced, and effluent, including treatment level and discharge type. As applicable, dischargers are additionally required to annually report recycled water use by volume and category of reuse. Data is self reported and submitted by dischargers through a reporting module in GeoTracker and collected on an annual basis.
Organization: State of California
Last updated: 2025-09-23T12:42:57.656722
Tags: effluent, influent, recycled-water, treatment, volume, wastewater

Tables

Data Dictionary - Volumetric Annual Report Facilities

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.data_dictionary_volumetric_annual_report_facilities

3.48 kB
12 rows
4 columns

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

Volumetric Annual Report Effluent

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_effluent

551.31 kB
64,825 rows
13 columns

CREATE TABLE volumetric_annual_report_effluent (
  "global_id" VARCHAR,
  "reporting_year" BIGINT,
  "reporting_month" BIGINT,
  "treatment_level" VARCHAR,
  "discharged_to" VARCHAR,
  "discharge_volume" DOUBLE,
  "discharge_type" VARCHAR,
  "estimate_description" VARCHAR,
  "has_minumum_instream_flow" VARCHAR,
  "stream_name" VARCHAR,
  "minimum_instream_flow" DOUBLE,
  "recycled_facility_name" VARCHAR,
  "discharge_0_explanation" VARCHAR
);

Volumetric Annual Report Influent

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_influent

634.12 kB
53,016 rows
19 columns

CREATE TABLE volumetric_annual_report_influent (
  "global_id" VARCHAR,
  "reporting_year" BIGINT,
  "reporting_month" BIGINT,
  "non_operational" VARCHAR,
  "influent_volume" DOUBLE,
  "influent_type" VARCHAR,
  "influent_type_est_explanation" VARCHAR,
  "eff_not_within_20_explanation" VARCHAR,
  "influent_0_explanation" VARCHAR,
  "wwtp_1" VARCHAR,
  "wwtp_vol_1" DOUBLE,
  "wwtp_2" VARCHAR,
  "wwtp_vol_2" DOUBLE,
  "wwtp_3" VARCHAR,
  "wwtp_vol_3" DOUBLE,
  "wwtp_4" VARCHAR,
  "wwtp_vol_4" DOUBLE,
  "wwtp_5" VARCHAR,
  "wwtp_vol_5" VARCHAR
);

Volumetric Annual Report Reuse

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_reuse

41.76 kB
3,331 rows
5 columns

CREATE TABLE volumetric_annual_report_reuse (
  "global_id" VARCHAR,
  "reporting_year" BIGINT,
  "reuse_category" VARCHAR,
  "reuse_volume" DOUBLE,
  "other_description" VARCHAR
);