Yard Waste Data

Annual volume summary of yard waste materials brought to the Ramsey County yard waste collection sites. Brush collection started in 2004. Brush is accepted at only four sites: Arden Hills, Frank & Sims, Midway and White Bear. Site visit counts were discontinued after 2015. Grass & Leaves measured in tons, not cubic yards, starting in 2019. The Maplewood site closed in 2001.

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 \"ramseycounty-us/yard-waste-data-x86f-9kv6\".\"yard_waste_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.