Solid Waste - Barrels Collected

Summarized statistics used for performance measures and describes scheduled and collected curbside trash including black, blue and green barrels. Black barrels are considered regular trash destined for landfill. Green barrels are for recycling of green yard waste. Blue barrels are for recycling of paper, some plastics, glass and metal cans.

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 \"citydata-mesaaz-gov/solid-waste-barrels-collected-xs8f-aset\".\"solid_waste_barrels_collected\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.