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 
"}
EOF

See the Splitgraph documentation for more information.