About this Dataset

Surface Water - Water Quality Regulated Facility Information

Information regarding site visits of facilities that discharge wastewater, from the California Integrated Water Quality System (CIWQS).
Organization: State of California
Last updated: 2025-10-23T12:45:38.085712
Tags: animals, ciwqs, compliance, dairies, discharge, inspection, permits, regulations, site-visit, wastewater

Tables

Confined Animal Facilities Regulated By The Water Boards

@usgov.ca_gov_surface_water_water_quality_regulated_facility__e737ae70.confined_animal_facilities_regulated_by_the_water_boards

602.13 kB
4,874 rows
47 columns

CREATE TABLE confined_animal_facilities_regulated_by_the_water_boards (
  "reg_measure_id" BIGINT,
  "reg_measure_type" VARCHAR,
  "reg_measure_title" VARCHAR,
  "reg_measure_description" VARCHAR,
  "order_number" VARCHAR,
  "npdes_number_ca_number" VARCHAR,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "wdid" VARCHAR,
  "region" VARCHAR,
  "status" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_review_date" TIMESTAMP,
  "termination_date" TIMESTAMP,
  "adoption_date" TIMESTAMP,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "facility_waste_type" VARCHAR,
  "facility_waste_type_2" VARCHAR,
  "number_of_amendments" BIGINT,
  "most_recent_amendment_number" VARCHAR,
  "most_recent_amendment_date" VARCHAR,
  "most_recent_amendment_comments" VARCHAR,
  "rescission_number" VARCHAR,
  "rescission_date" TIMESTAMP,
  "rescission_comments" VARCHAR,
  "facility_id" VARCHAR,
  "facility_region" VARCHAR,
  "facility_name" VARCHAR,
  "place_type" VARCHAR,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "latitude_decimal_degrees" VARCHAR,
  "longitude_decimal_degrees" VARCHAR,
  "approved_cnty_reg_prog" VARCHAR,
  "cafo_subtype" VARCHAR,
  "cafo_type" VARCHAR,
  "onsite" VARCHAR,
  "cafo_population" VARCHAR,
  "quality_assurance" VARCHAR,
  "sic_code_1" VARCHAR,
  "sic_desc_1" VARCHAR,
  "animal_equivalent_units_aeu" VARCHAR,
  "agency_name" VARCHAR,
  "agency_type" VARCHAR
);

Wastewater Enforcement Actions

@usgov.ca_gov_surface_water_water_quality_regulated_facility__e737ae70.wastewater_enforcement_actions

4.95 MB
44,585 rows
32 columns

CREATE TABLE wastewater_enforcement_actions (
  "region" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "agency_name" VARCHAR,
  "place_type" VARCHAR,
  "place_subtype" VARCHAR,
  "place_latitude" DOUBLE,
  "place_longitude" DOUBLE,
  "wdid" VARCHAR,
  "reg_measure_id" DOUBLE,
  "reg_measure_type" VARCHAR,
  "enforcement_id_eid" BIGINT  -- ENFORCEMENT ID (EID),
  "order_resolution_number" VARCHAR  -- ORDER / RESOLUTION NUMBER,
  "enforcement_action_type" VARCHAR,
  "effective_date" VARCHAR,
  "adoption_issuance_date" VARCHAR  -- ADOPTION / ISSUANCE DATE,
  "termination_date" VARCHAR,
  "acl_issuance_date" TIMESTAMP,
  "epl_issuance_date" VARCHAR,
  "status" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "total_assessment_amount" DOUBLE,
  "initial_assessed_amount" DOUBLE,
  "liability_amount" DOUBLE  -- LIABILITY $ AMOUNT,
  "project_amount" DOUBLE  -- PROJECT $ AMOUNT,
  "liability_paid" DOUBLE  -- LIABILITY $ PAID,
  "project_completed" BIGINT  -- PROJECT $ COMPLETED,
  "total_paid_completed_amount" DOUBLE  -- TOTAL $ PAID/COMPLETED AMOUNT,
  "location_1" VARCHAR
);

Wastewater Facilities Permits & Orders

@usgov.ca_gov_surface_water_water_quality_regulated_facility__e737ae70.wastewater_facilities_permits_orders

7.88 MB
104,286 rows
40 columns

CREATE TABLE wastewater_facilities_permits_orders (
  "reg_measure_id" DOUBLE,
  "reg_measure_type" VARCHAR,
  "order_number" VARCHAR,
  "npdes_number_ca_number" VARCHAR,
  "program_category" VARCHAR,
  "wdid" VARCHAR,
  "major_minor" VARCHAR,
  "status" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_review_date" VARCHAR,
  "termination_date" VARCHAR,
  "adoption_date" TIMESTAMP,
  "wdr_review_amend" TIMESTAMP,
  "wdr_review_revise_renew" TIMESTAMP,
  "wdr_review_rescind" TIMESTAMP,
  "wdr_review_no_action_required" TIMESTAMP,
  "wdr_review_pending" TIMESTAMP,
  "wdr_review_planned" TIMESTAMP,
  "status_enrollee" VARCHAR,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "design_flow" VARCHAR,
  "threat_to_water_quality" VARCHAR,
  "complexity" VARCHAR,
  "pretreatment" VARCHAR,
  "population_ms4_acres" VARCHAR,
  "reclamation" VARCHAR,
  "facility_waste_type" VARCHAR,
  "facility_waste_type_2" VARCHAR,
  "number_of_amendments" BIGINT,
  "facility_id" VARCHAR,
  "facility_region" VARCHAR,
  "facility_name" VARCHAR,
  "place_type" VARCHAR,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "latitude_decimal_degrees" VARCHAR,
  "longitude_decimal_degrees" VARCHAR
);