Cleanup Sites in Washington State

This is a list of cleanup sites in Washington State. It includes sites and associated websites. It includes location data, Cleanup Status, Site Rank – if the site is ranked, and if the site has an Environmental Covenant.

Over half the cleanup sites have a status of “No Further Action Required/Decision” or NFA. If a site has a NFA it includes the latest NFA date and NFA reason.

The Washington Department of Ecology (Toxics Cleanup Program) works to clean up contaminated sites/properties throughout the state of Washington. This data was downloaded from the Integrated Site Information System (ISIS) database and is monthly.

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 \"wa-gov/cleanup-sites-in-washington-state-vtkh-65is\".\"cleanup_sites_in_washington_state\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.