Annual Waste Volumes

Annual Waste Volumes provides the number of tonnes of material managed at City of Calgary landfills, through the residential Black (garbage), Blue (recyclables), and Green (food and yard waste) Cart programs, and Household Hazardous Waste program.

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/annual-waste-volumes-ufkw-t69m\".\"annual_waste_volumes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.