DSNY - PlowNYC Data

A table containing physical ID (a unique street segment identifier) and the date/time with which it was last associated with a GPS signal emitted by a NYC Department of Sanitation (DSNY) snow clearing vehicle. The PlowNYC website (https://plownyc.cityofnewyork.us/plownyc/) allows you to track the progress of DSNY snow removal vehicles. To learn more about DSNY’s Snow Response, visit: https://www.nyc.gov/site/dsny/what-we-do/snow-response.page.

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-plownyc-data-rmhc-afj9\".\"dsny_plownyc_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.