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: 2021-09-08T16:15:38.641075
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.46 MB
51,508 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
);

Water Board Wastewater Violations, 2001-2016

@usgov.ca_gov_surface_water_water_quality_regulatory_information.water_board_wastewater_violations_2001_2016

27.05 MB
322,974 rows
26 columns

CREATE TABLE water_board_wastewater_violations_2001_2016 (
  "violated_facility_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_meas_type" VARCHAR,
  "violation_id_vid" BIGINT  -- VIOLATION ID (VID),
  "violation_type" VARCHAR,
  "violation_subtype" VARCHAR,
  "violation_description" VARCHAR,
  "status" VARCHAR,
  "occurred_on" TIMESTAMP,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "parameter" VARCHAR,
  "limit" DOUBLE,
  "result" DOUBLE,
  "units" VARCHAR,
  "period" VARCHAR,
  "monitoring_location" VARCHAR,
  "location_1" VARCHAR
);