Environmental response date

TCEQ Complaints — the named Texas Open Data (Socrata) dataset tdzs-qqjn (complaints received by TCEQ, tracked in the Consolidated Compliance and Enforcement Data System / CCEDS, keyed by complaint tracking number incid_track_num). 241,322 rows, full history. No street/city/state/ZIP/lat/lon fields exist in this dataset (only county and TCEQ region); ds_ address/location columns are all 0% fill, accepted by the developer since the COMPLAINTS attribute doesn't require location. ds_COMPLAINTS = true for every row.

TCEQ Emergency Response Spills — the named Texas Open Data (Socrata) dataset xagr-a3x2 (spill notifications to the TCEQ Emergency Response Division, keyed by incident tracking number). 46,043 incidents, one row each. conform.py: ds_street from deliv_txt(+deliv_2_txt) with a phys_loc_desc_txt fallback, ds_city from near_city_name, ds_state constant 'TX', ds_zip from loc_zip_txt; ds_lat/lon from lat_dec_coord_num/long_dec_coord_num. Same reachable Socrata portal as tx_tceq__operating_dry_cleaner_registrations.

All leaking underground storage tank incidents published by DC DOEE through the DC GIS feature layer, from historical records through the present. Each row represents a distinct case number and includes open, closed, no-further-action, administrative-closure, and related statuses; the live endpoint returned 1,952 records on 2026-07-13.

Oklahoma Corporation Commission Oil and Gas Conservation Division's statewide ArcGIS feature layer of oil and gas incidents, including complaint, investigation, enforcement, release, environmental-impact, violation, finding, and resolution details.

Virginia DEQ Pollution Response Program (PREP) incident reports — oil/hazmat spills, sewage discharges, fish kills, open burning, etc. State-native source matching the Chubb PREP description (provider va_deq, no divergence). VA DEQ Environmental Data Hub public ArcGIS layer 'PReP Reports' (apps.deq.virginia.gov/arcgis/.../public/EDMA/MapServer/175). 31,379 point records (within predicted 25000 ±55% = 11250-38750). Single-attribute (SPILLS). Strong fill on BOTH address and coordinates: ds_street 96.7% (PRP_SITE_ADDRESS1), ds_city 97.4%, ds_state 100% (PRP_SITE_STATE, ~99.99% VA), ds_zip 75.2%, ds_lat/lon 100% (point geometry) -> Fit.

EPA Region 1 spreadsheet of leaking underground storage tank releases on Indian land, with facility identity, tribal affiliation, release status, event history, address, coordinates, and land status.

NYSDEC Spill Incidents — the complete New York spill/release archive published on the state open-data portal (data.ny.gov Socrata dataset u44d-k5fk). 570,234 records: chemical and petroleum spills reported to NYSDEC under Article 12 of the Navigation Law, 6 NYCRR 613.8 (PBS) and 595.2 (CBS); spills active as of 1986-04-01 plus all reported since (some records to the late 1970s), current through the fetch date. Native NY source (provider ny_dec) — no provider divergence. Each record: spill number, facility name, street/locality/county/zip, DEC region, spill & received & close dates, contributing factor, source, material name/family, quantity/units, recovered. No coordinate columns.

Connecticut reports of environmental releases received by CT DEEP from January 1996 through June 2022, with incident timing, location, responsible party, substance, quantity, affected media, cause, and response details where reported.

Florida State Watch Office (SWO) oil and hazardous-materials spill/incident archive — the 'Hazardous Materials/Petroleum Spills (SWO Incidents)' feature layers hosted in the FL Division of Emergency Management ArcGIS Online org and published for FL DEP. 22,153 statewide incidents (Hazardous Materials 22,041 + Petroleum Spill 112), full historical archive reported 2011-07 through 2024-08. The two upstream layers (identical schema) are unioned into one source; IncidentType/source_layer distinguish them. Each record carries incident ID/number/type/name, status, county, dates, signed WGS84 coordinates, report URL, and (where available) facility name, address, chemical released, amount, and CERCLA §304 flag.

Statewide bulk extract from the Arkansas DEQ TankStats Access database, table TempRLUSTLOG1, containing one row per leaking underground or aboveground storage tank release notice. Records include facility and owner identifiers, release timing and status, substances, impacts, response and remediation details, and site location.

ADEQ's public, nightly updated ArcGIS layer of reported underground storage tank release cases, including suspected, confirmed, and closed incidents and facility locations.

EPA's national UST Finder ArcGIS FeatureServer (Releases layer), server-side filtered to Maryland releases reported before 1999-01-01 — the frozen pre-1999 slice of MDE's legacy 'Recovery Sites Database,' distinct from MDE's live OCP case system (already covered by md_mde__ocp_case_search). 4,543 rows, no auth, paginated via resultOffset/resultRecordCount. Note: this data overlaps with the separately-scoped us_epa__ust_finder source — both draw from what is verifiably the same underlying UST Finder Releases dataset (published via two distinct-but-data-identical ArcGIS items), and this Maryland/pre-1999 slice is fully reproducible by filtering us_epa__ust_finder's fetched output. Kept as an isolated single-attribute source per the developer's explicit decision (Integration 216) rather than folded into the multi-attribute us_epa__ust_finder source.