calgary-ca/waste-composition-2019-garbage-p2fv-5peq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 2 hours ago

Waste Composition 2019 - Garbage

Waste Composition studies are periodically conducted by Waste and Recycling Services to help assess the performance of diversion and education programs and inform improvements and new program design.

In 2019, The City of Calgary assessed the waste composition of Black Carts and garbage bins, in the residential (single family and multi-family) sector and for businesses and organizations. More detailed information about each sector can be found in the description of the filtered datasets.

The weight per cent composition is provided for a number of material categories and subcategories. Definitions are attached: <a href="https://data.calgary.ca/api/views/p2fv-5peq/files/9b592564-c3c0-43ad-aebf-49498b74c8fa?download=true&filename=Waste%20Material%20Types%20and%20Definitions.pdf">Waste Material Types and Definitions</a>

Please visit <a href="https://www.calgary.ca/UEP/WRS/Pages/Garbage-collection-information/Residential-services/Garbage-Collection.aspx">Black Cart garbage collection</a> for more information.

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 \"calgary-ca/waste-composition-2019-garbage-p2fv-5peq\".\"waste_composition_2019_garbage\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • waste_composition_2019_garbage
     
     
     
     
     
Upstream Metadata