About this Dataset

Surface Water - Water Quality Regulatory Information

This data set lists active and historical enforcement actions records that are stored in the California Integrated Water Quality System (CIWQS). Enforcement actions are generally issued in response to one or more instances of non-compliance (violations) of a base regulatory measure. Enforcement actions can be monetary or non-monetary.
Organization: State of California
Last updated: 2025-09-23T12:41:17.678184
Tags: ciwqs, corrective-action, enforcement, environment, non-compliance, pollution, regulatory, violation, violations, wastewater, water

Tables

Wastewater Enforcement Actions

@usgov.ca_gov_surface_water_water_quality_regulatory_information.wastewater_enforcement_actions

7.58 MB
52,309 rows
88 columns

CREATE TABLE wastewater_enforcement_actions (
  "facility_id" VARCHAR,
  "facility_name" VARCHAR,
  "agency_name" VARCHAR,
  "place_type" VARCHAR,
  "place_subtype" VARCHAR,
  "facility_type" VARCHAR,
  "agency_type" VARCHAR,
  "n__of_agencies" VARCHAR  -- # OF AGENCIES,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "place_latitude" VARCHAR,
  "place_longitude" VARCHAR,
  "sic_code_1" VARCHAR,
  "sic_desc_1" VARCHAR,
  "sic_code_2" VARCHAR,
  "sic_desc_2" VARCHAR,
  "sic_code_3" VARCHAR,
  "sic_desc_3" VARCHAR,
  "naics_code_1" VARCHAR,
  "naics_desc_1" VARCHAR,
  "naics_code_2" VARCHAR,
  "naics_desc_2" VARCHAR,
  "naics_code_3" VARCHAR,
  "naics_desc_3" VARCHAR,
  "n__of_places" VARCHAR  -- # OF PLACES,
  "source_of_facility" VARCHAR,
  "design_flow" VARCHAR,
  "threat_to_water_quality" VARCHAR,
  "complexity" VARCHAR,
  "pretreatment" VARCHAR,
  "facility_waste_type" VARCHAR,
  "facility_waste_type_2" VARCHAR,
  "facility_waste_type_3" VARCHAR,
  "facility_waste_type_4" VARCHAR,
  "wdid" VARCHAR,
  "reg_measure_id" VARCHAR,
  "reg_measure_type" VARCHAR,
  "order" VARCHAR  -- ORDER #,
  "npdes_ca" VARCHAR  -- NPDES # CA#,
  "major_minor" VARCHAR,
  "npdes_type" VARCHAR,
  "reclamation" VARCHAR,
  "dredge_fill_fee" VARCHAR,
  "n_301h" VARCHAR  -- 301H,
  "application_fee_amt_received" VARCHAR,
  "status" VARCHAR,
  "status_date" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_review_date" TIMESTAMP,
  "termination_date" TIMESTAMP,
  "wdr_review_amend" TIMESTAMP  -- WDR REVIEW - AMEND,
  "wdr_review_revise_renew" TIMESTAMP  -- WDR REVIEW - REVISE/RENEW,
  "wdr_review_rescind" TIMESTAMP  -- WDR REVIEW - RESCIND,
  "wdr_review_no_action_required" TIMESTAMP  -- WDR REVIEW - NO ACTION REQUIRED,
  "wdr_review_pending" TIMESTAMP  -- WDR REVIEW - PENDING,
  "wdr_review_planned" VARCHAR  -- WDR REVIEW - PLANNED,
  "status_enrollee" VARCHAR,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "direction_voice" VARCHAR,
  "enforcement_id_eid" VARCHAR  -- ENFORCEMENT ID (EID),
  "region" VARCHAR,
  "order_resolution_number" VARCHAR  -- ORDER / RESOLUTION NUMBER,
  "enforcement_action_type" VARCHAR,
  "enf_action_effective_date" VARCHAR,
  "adoption_issuance_date" VARCHAR  -- ADOPTION / ISSUANCE DATE,
  "achieve_date" VARCHAR,
  "enf_action_term_date" VARCHAR  -- ENF ACTION TERM. DATE,
  "acl_issuance_date" VARCHAR,
  "epl_issuance_date" VARCHAR,
  "enf_action_status" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "n__of_programs" VARCHAR  -- # OF PROGRAMS,
  "latest_milestone_completion_date" VARCHAR,
  "total_assessment_amount" VARCHAR,
  "initial_assessed_amount" VARCHAR,
  "liability_amount" VARCHAR  -- LIABILITY $ AMOUNT,
  "project_amount" VARCHAR  -- PROJECT $ AMOUNT,
  "liability_paid" VARCHAR  -- LIABILITY $ PAID,
  "project_completed" VARCHAR  -- PROJECT $ COMPLETED,
  "total_paid_completed_amount" VARCHAR  -- TOTAL $ PAID/COMPLETED AMOUNT,
  "agency_issuing_enf" VARCHAR,
  "date_of_oldest_violation_linked_to_enforcement_action" TIMESTAMP
);

Wastewater Violations Linked To Enforcement Actions, 2005-2016

@usgov.ca_gov_surface_water_water_quality_regulatory_information.wastewater_violations_linked_to_enforcement_actions_2005_2016

1.87 MB
241,393 rows
3 columns

CREATE TABLE wastewater_violations_linked_to_enforcement_actions_2005_2016 (
  "violation_id" BIGINT,
  "enforcement_action_id" BIGINT,
  "date_added_to_enforcement" TIMESTAMP
);