Underground Storage Tanks (USTs) - Compliance Details

This list provides Underground Storage Tank (UST) site, tank, contact and Enforcement information for the approximately 45,000 commercial underground storage tanks (USTs) previously or currently registered in Connecticut, of which about 8,000 are still in use.

Compliance Details are the individual inspected compliance points that are referenced in a Field Notice of Violation (FNOV), Warning Letter, or Red Tag which can be issued by the Agency and contain information about how and when the compliance point has been resolved. The UST Site ID, Field NOV and Warning Letter numbers are included to cross-reference to the Enforcement Summary.

(There are 3 other related data sets: 1-Facility and Tank Details, 2-Contacts, and

3-Enforcement Summary.)

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ct-gov/underground-storage-tanks-usts-compliance-details-jis9-5rj9\".\"underground_storage_tanks_usts_compliance_details\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.