Underground Storage Tanks (USTs) - Enforcement Summary by US Government | Demographics and Population Studies

About this Dataset

Underground Storage Tanks (USTs) - Enforcement Summary

This list provides Underground Storage Tank (UST) site, tank, contact and Enforcement information for the approximately 45,000 commercial underground storage tanks (USTs) previously and currently registered in Connecticut, of which about 8,000 are still in use.
(There are 3 other related data sets: 1-Facility and Tank Details, 2-Contacts, and
3-Compliance Details.)

Annually, or when a UST is installed, removed, or altered, a notification form must be completed via EZFile and submitted to CT DEEP. Notification is required for non-residential underground storage tanks, including those for oil, petroleum and chemical liquids, as well as residential home heating oil tanks serving five or more units. See online at: https://www.ct.gov/deep/cwp/view.asp?q=322600

The underground storage tank regulations and the Connecticut underground storage tank enforcement program have been in effect since November 1985. This list is based on notification information submitted by the public since 1985, and is updated weekly. This list contains information on both active and on non-active USTs, as well as federally regulated and state regulated USTs.

Factors to Consider When Using this data:

-Not every required notification form is submitted to the DEEP. We can only enter the information we receive.

-We know there are errors in the data although we strive to minimize them. Error examples may include: notification forms completed incorrectly by the owner/operator, data entry errors, duplicate site information, misspelled names and addresses and/or missing data.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:38.933079
Tags: compliance, enforcement, red-tag, storage, summary, tank, underground, ust, violation, warning

Tables

Table 1

@usgov.state_of_connecticut_underground_storage_tanks_usts_en_592f8691.table_1

497.51 KB
8339 rows
22 columns


CREATE TABLE table_1 (
  "enforcement_action_id" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "action_date" TIMESTAMP,
  "resolution_date" TIMESTAMP,
  "resolution_type" VARCHAR,
  "site_name" VARCHAR,
  "site_address" VARCHAR,
  "site_city" VARCHAR,
  "site_state" VARCHAR,
  "site_zip" DOUBLE,
  "number_of_violations" DOUBLE,
  "ust_site_id_number" VARCHAR,
  "affiliation" VARCHAR,
  "client_name_last" VARCHAR,
  "client_name_first" VARCHAR,
  "client_suffix" VARCHAR,
  "client_address_line_1" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" DOUBLE,
  "client_zip4" DOUBLE
);