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.11 MB
51508 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,
  "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,
  "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,
  "npdes_ca" VARCHAR,
  "major_minor" VARCHAR,
  "npdes_type" VARCHAR,
  "reclamation" VARCHAR,
  "dredge_fill_fee" VARCHAR,
  "n_301h" VARCHAR,
  "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_revise_renew" TIMESTAMP,
  "wdr_review_rescind" TIMESTAMP,
  "wdr_review_no_action_required" TIMESTAMP,
  "wdr_review_pending" TIMESTAMP,
  "wdr_review_planned" VARCHAR,
  "status_enrollee" VARCHAR,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "direction_voice" VARCHAR,
  "enforcement_id_eid" VARCHAR,
  "region" VARCHAR,
  "order_resolution_number" VARCHAR,
  "enforcement_action_type" VARCHAR,
  "enf_action_effective_date" VARCHAR,
  "adoption_issuance_date" VARCHAR,
  "achieve_date" VARCHAR,
  "enf_action_term_date" VARCHAR,
  "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,
  "latest_milestone_completion_date" VARCHAR,
  "total_assessment_amount" VARCHAR,
  "initial_assessed_amount" VARCHAR,
  "liability_amount" VARCHAR,
  "project_amount" VARCHAR,
  "liability_paid" VARCHAR,
  "project_completed" VARCHAR,
  "total_paid_completed_amount" VARCHAR,
  "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.78 MB
241393 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

25.8 MB
322974 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_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
);