Recycling Diversion and Capture Rates

For each Community District, its Recycling Diversion rate (percentage of total municipal solid waste collected by the Department of Sanitation that is disposed of by recycling) and Capture Rate (percentage of total Paper or Metal/Glass/Plastic in the waste stream that is disposed of by recycling). For more information about DSNY's recycling programs, see: https://www1.nyc.gov/assets/dsny/site/services/recycling. Capture rate is the amount of materials set out for residential recycling collection as a percentage of designated recyclable materials in both recycling and refuse streams. This ratio measures how much of the targeted materials are actually being recycled, which is a measure of how successfully such materials are recycled. Please note that since 2013, DSNY no longer uses capture rate information. For information on what is in NYC's waste, see: http://www1.nyc.gov/assets/dsny/site/resources/reports/waste-characterization.

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/recycling-diversion-and-capture-rates-gaq9-z3hz\".\"recycling_diversion_and_capture_rates\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.