List of Contaminated or Potentially Contaminated Sites - Remediation Division

Data to create the List of Contaminated or Potentially Contaminated Sites - Remediation Division is from historical program information or from new program applications and filings. More information regarding the generation of this list can be found at: https://portal.ct.gov/DEEP/Remediation--Site-Clean-Up/List-of-Contaminated-or-Potentially-Contaminated-Sites-in-Connecticut

A seperate dataset is published for: List of Contaminated Sites or Potentially Contaminated - SASU Case Management System and provide a list of Leaking Underground Storage Tank Sites. The two database systems are maintained by different Divisions within the agency. There may be sites in both databases due to an overlap in responsibilities of the two Divisions. https://data.ct.gov/Environment-and-Natural-Resources/List-of-Contaminated-or-Potentially-Contaminated-S/77ya-7twa

The data is updated when documents are received for responsible parties conducting site remediation. For more information regarding the individual remedial programs visit: https://portal.ct.gov/DEEP/Remediation--Site-Clean-Up/Remediation-Site-Clean-Up

Those seeking additional information about information contained in this dataset may use the DEEP FOIA Process:

https://portal.ct.gov/DEEP/About/FOIA-Requests

Each Row represents a Remediation project (Property Transfer, Brownfield, Enforcement, Federal Remediation, State Remediation, Landfill Monitoring, RCRA Corrective Action, and Voluntary). Data to compile the list was gathered for each site from information provided to DEEP for requirements within each program. Sites may be in multiple Remediation programs and therefore may be listed more than once. Some sites have been fully cleaned up while others have limited information about the environmental conditions. The list includes only sites that been reported to DEEP or EPA.

Additional information for site within the Hazard Notification program can be found at: https://portal.ct.gov/DEEP/Remediation--Site-Clean-Up/Significant-Environmental-Hazard-Program/List-of-Significant-Environmental-Hazards

Significant Environmental Hazard Sites GIS Map:

http://ctdeep.maps.arcgis.com/apps/webappviewer/index.html?id=fb38afc8e3734d8eb7a0f8e49997bd5c

Details on columns which reference ELUR: Environmental Land Use Restriction (ELUR) or Notice and Use Limitation (NAUL) are used to minimize the risk of human exposure to pollutants and hazards to the environment by preventing specific uses or activities at a property or a portion of a property. Link to GIS map of ELUR and restriction type: https://ctdeep.maps.arcgis.com/apps/webappviewer/index.html?id=d37eccb2a5c3491d8f0d389a96d9a912

There may be errors in the data although we strive to minimize them. Examples of errors may include: misspelled or incomplete 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/list-of-contaminated-or-potentially-contaminated-u76p-weqj\".\"list_of_contaminated_or_potentially_contaminated\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.