DSNY Planned Commercial Waste Zones

On November 20, 2019, Mayor de Blasio signed into law LL199 of 2019, requiring the establishment of Commercial Waste Zones throughout New York City. The result of years of planning, analysis, and stakeholder engagement by DSNY, the Commercial Waste Zones (CWZ) program will create a safe and efficient commercial waste collection system that advances the City’s Green New Deal and zero waste goals while providing high-quality, low-cost service to NYC businesses. For more information, see: <a href="https://www1.nyc.gov/assets/dsny/site/resources/reports/commercial-waste-zones-plan">https://www1.nyc.gov/assets/dsny/site/resources/reports/commercial-waste-zones-plan</a>.

The zone map did change slightly after <a href="https://a856-cityrecord.nyc.gov/RequestDetail/20200210107">DSNY adopted final rules in February 2020.</a> The map presented here reflects the changes made when the final rules were adopted.

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 \"cityofnewyork-us/dsny-planned-commercial-waste-zones-8ev8-jjxq\".\"dsny_planned_commercial_waste_zones\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.