About this Dataset

Canal System Guard Gates

The New York State Canal System is a 524 mile inland waterway that includes 20 guard gates, which are used to close off a section of canal seasonally or in rare instances in an emergency so that a section can be dewatered. Information provided in this data set includes the name of each guard gate, its phone number (where applicable), and specific location by mileage along the canal and geographic coordinates.
Organization: State of New York
Last updated: 2020-11-12T03:59:50.531822
Tags: canal, cayuga-seneca-canal, champlain-canal, erie-canal, guard-gate, oswego-canal, waterway

Tables

Table 1

@usgov.state_of_new_york_canal_system_guard_gates.table_1

7.56 KB
20 rows
8 columns


CREATE TABLE table_1 (
  "canal_name" VARCHAR,
  "mile" DOUBLE,
  "name_location" VARCHAR,
  "phone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "georeference" VARCHAR,
  "itsuid" VARCHAR
);