Bicycle Routes Across New York State

Bicycle routes and recreational activities allowed on the route within New York State - https://www.dot.ny.gov/display/programs/bicycle. This list includes both on- and off-road bicycle routes and even includes information on surface type as well as other types of recreational activities allowed on the route.

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 \"ny-gov/bicycle-routes-across-new-york-state-7bg2-3faq\".\"bicycle_routes_across_new_york_state\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.