About this Dataset

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.
Organization: State of New York
Last updated: 2020-11-12T04:00:26.695485
Tags: canal, cayuga-seneca-canal, champlain-canal, erie-canal, locks, oswego-canal, waterway

Tables

Table 1

@usgov.state_of_new_york_canal_system_locks.table_1

16.41 KB
56 rows
14 columns


CREATE TABLE table_1 (
  "body_of_water" VARCHAR,
  "mile" DOUBLE,
  "name_location" VARCHAR,
  "lift" VARCHAR,
  "attachment" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "phone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "georeference" VARCHAR,
  "itsuid" VARCHAR
);