Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 2 hours ago

DSNY Waste Characterization 2017 – Subsort Results

The Department conducted the 2017 NYC Residential, School, and NYCHA (NYC Housing Authority) Waste Characterization Study over three seasons: spring, summer, and fall. This study builds on decades of research and analysis into the evolving composition of NYC's waste stream. The study team hand sorted samples into 70 main sort categories. Sub-sorting of an additional 172 categories was conducted to get a more detailed understanding of the wide variety of plastic products in the waste stream, as well as a sub-set of Paper products. Results are presented in absolute terms as the quantity by weight of each material type. The quantity of each material is calculated by applying the percent composition to the total quantity of DSNY collections for fiscal year 2017 (July 2016-June 2017).

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/dsny-waste-characterization-2017-subsort-results-phkb-tkts\".\"dsny_waste_characterization_2017_subsort_results\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dsny_waste_characterization_2017_subsort_results
Upstream Metadata