DSNY Litter Basket Inventory

Locations and types of refuse litter baskets tracked by DSNY. This data is collected through periodic surveys by DSNY field personnel. Each record represents the approximate location, ownership, and physical type of a single refuse litter basket. Litter basket locations are subject to frequent change, for reasons that include but are not limited to: litter basket damage, nearby construction, graffiti, or regular illegal use of basket for household or commercial waste. There is often a lag time between a change in basket type or location and the reflection of that change in this dataset. This dataset includes information on BID-owned and Privately-owned litter baskets. Non-profit and private entities wishing to place a litter basket on a public street must receive permission from the Department of Sanitation. Location data for these baskets may be less accurate than for baskets that are owned by DSNY. This dataset does not track public litter baskets placed by other City, State, or Federal agencies, notably the NYC Department of Parks and Recreation. Recycling baskets are also not tracked in this dataset.

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 \"cityofnewyork-us/dsny-litter-basket-inventory-8znf-7b2c\".\"dsny_litter_basket_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.