DSNY Organics Collection Participation

The number of NYC households, residential buildings, and new schools receiving curbside organics collection, by Fiscal Year that collection began. Curbside Composting service is currently available to all Queens and Brooklyn residents (no sign-up needed), as well as select community boards in Bronx and Manhattan. Curbside Composting is expanding to ALL NYC residents. For more information, visit: <a href="https://nyc.gov/curbsidecomposting" rel="noopener noreferrer">https://nyc.gov/curbsidecomposting</a>. Note that Curbside Composting service was suspended from May 4, 2020 until October 1, 2021.

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-organics-collection-participation-tiyn-ajjm\".\"dsny_organics_collection_participation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.