Canal System Locks
The New York State Canal System is a 524 mile inland waterway that includes 57 locks, which are used to transfer vessels from a navigation pool at one elevation to another. Information provided in this data set includes the name of each lock, its phone number and specific location by mileage along the canal and geographic coordinates. This dataset excludes the Utica Harbor Lock because at this time it is not open to the public.
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-locks-ta83-js48\".\"canal_system_locks\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
