Canal System Lift Bridges
The New York State Canal System is a 524 mile inland waterway that includes 16 lift bridges, which are operationally left in the down position to allow vehicular road traffic to pass over the canal, but then are lifted on demand to allow vessels to pass beneath. Information provided in this dataset includes the name of each lift bridge, its phone number, and specific location by mileage along the canal and geographic coordinates.
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/canal-system-lift-bridges-pe3j-9bkg\".\"canal_system_lift_bridges\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
