Thruway Interchanges and Exits
The Interchanges and Exit Listings is a tool for travelers along the Thruway System that provides patrons with a directory of exit numbers, road signage descriptions and mileposts. The csv file contains the latitude and longitude of the location of the interchange and the route name where the interchange is on. Along with interchanges, toll barriers are included as well.
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/thruway-interchanges-and-exits-7jkf-259w\".\"thruway_interchanges_and_exits\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.