Brownfield Cleanup Program, Certificates of Completion
This dataset shows Brownfield Cleanup Program (BCP) Sites that have been completed and issued a Certificate of Completion (COC) in the State of New York. Included in the data is the program site identification number; site name; site locality; site acreage; year certificate issued; length of time from the date the New York State Department of Environmental Conservation (NYSDEC) approved the BCP application to the date the COC was issued; and, highest allowable future use for the site and its potential redevelopment (as determined by: remedial program soil cleanup objectives; see 6NYCRR Part 375-6: http://www.dec.ny.gov/regs/15507.html.)
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 \"ny-gov/brownfield-cleanup-program-certificates-of-ir93-7qzi\".\"brownfield_cleanup_program_certificates_of\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.