About this Dataset

Water Pollution Control Facilities

Water Pollution Control Facilities represents data extracted from permit applications submitted to DEEP. Alias is the facility name utilized in DEEPs internal system whereas the Facility Name is the name utilized on the permit itself. Permittee Address is the address utilized for correspondence and Facility Address is the location of the plant. The Class field differentiates 4 levels of plants in CT (I, II, III, and IV) with I being the lowest and IV being the highest based on complexity of treatment and SCADA present at the plant. Permit ID is the NPDES or State Subsurface permit number. Facility ID is a State of Connecticut ID number assigned to each facility in the state for internal use.
Organization: State of Connecticut
Last updated: 2025-01-31T21:57:07.902106
Tags: control, control-facilities, facilities, facility, pollution, water, water-pollution, water-pollution-control-facilities, wpcf

Tables

Table 1

@usgov.state_of_connecticut_water_pollution_control_facilities.table_1

28.3 kB
91 rows
20 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "permitte" VARCHAR,
  "permittee_address" VARCHAR,
  "alias" VARCHAR,
  "facility_name" VARCHAR,
  "facility_address" VARCHAR,
  "zip" VARCHAR,
  "town" VARCHAR,
  "state" VARCHAR,
  "phone" VARCHAR,
  "owner" VARCHAR,
  "class" VARCHAR,
  "permit_id" VARCHAR,
  "discharge_type" VARCHAR,
  "facility_id" VARCHAR,
  "receiving_waterbody" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);