Volumetric Annual Report Of Wastewater And Recycled Water by US Government | Environmental and Climate Sciences

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: 2021-09-03T11:12:35.723534
Tags: effluent, influent, recycled-water, treatment, volume, wastewater

Tables

Volumetric Annual Report Facilities

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_facilities

70.93 KB
3682 rows
12 columns


CREATE TABLE volumetric_annual_report_facilities (
  "global_id" VARCHAR,
  "reporting_year" BIGINT,
  "facility_place_id" BIGINT,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "lead_agency" VARCHAR,
  "fac_produce_rec_water" VARCHAR,
  "solely_rec_treat" VARCHAR,
  "facility_type" VARCHAR,
  "submit_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Volumetric Annual Report Influent

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_influent

522.76 KB
44184 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" VARCHAR,
  "wwtp_5" VARCHAR,
  "wwtp_vol_5" VARCHAR
);

Volumetric Annual Report Effluent

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_effluent

455.76 KB
54032 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 Reuse

@usgov.ca_gov_volumetric_annual_report_of_wastewater_and_recy_8705f46e.volumetric_annual_report_reuse

35.33 KB
2758 rows
5 columns


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