Open Streets Locations

New York City's Open Streets program transforms streets into public spaces open to all. These public spaces allows a variety of activities including education and cultural programming as well as building communities. For more information please visit: https://www.nyc.gov/html/dot/html/pedestrians/openstreets.shtml

Please note: there may be a delay in updates to the Open Data files.

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/open-streets-locations-uiay-nctu\".\"open_streets_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.