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.
This dataset has the following 14 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Body of Water | body_of_water | text | Body of water on which the canal lock is located | Erie Canal Champlain Canal Oswego Canal Cayuga-Seneca Canal Hudson River view top 100 |
| Mile | mile | number | Mileage along the waterway (in 1/100ths of a mile) | 2.15 1.09 1.60 1.87 3.43 view top 100 |
| Name/Location | name_location | text | Lock number and location name | Black Rock Lock* C11 Comstock C12 Whitehall C1 Waterford C2 Mechanicville view top 100 |
| Lift | lift | text | Lift in feet for lock | 8.0' ↑WB/↓EB 16.0' ↑WB/↓EB 34.5' ↑WB/↓EB 15.0' ↑WB/↓EB 6.0' ↑WB/↓EB view top 100 |
| Attachment | attachment | text | Method of attachment for the lock | Lines Pipes & Lines Cables & Lines Lines; WB use port side Pipes & Cables view top 100 |
| Address | address | text | Address of the canal lock | 1043 State Route 5S 10 Route 350 11500 Lock Rd 115 Rice Rd 116 N Clinton St view top 100 |
| City | city | text | CIty in which the canal lock is located | Waterford Oswego Amsterdam Fort Edward Fort Plain view top 100 |
| State | state | text | State in which the canal lock is located | NY view top 100 |
| Zip | zip | text | ZIP code in which the canal lock is located | 12188 13126 13339 13069 14489 view top 100 |
| Phone | phone | text | Lock phone number with area code | (315) 253-7523 (315) 331-3296 (315) 336-4329 (315) 336-8229 (315) 343-0280 view top 100 |
| Latitude | latitude | number | Latitude in decimal degrees (out to 5 decimal places) | 42.75145 42.78912 42.79486 42.80078 42.80216 view top 100 |
| Longitude | longitude | number | Longitude In decimal degrees (out to 5 decimal places) | -78.906243 -78.69310 -77.56942 -77.54490 -77.30188 view top 100 |
| Georeference | georeference | point | Open Data/Socrata-generated geocoding information from supplied address components. | {"coordinates":[-73.84706,42.80323],"type":"Point"} {"coordinates":[-76.19634,43.23879],"type":"Point"} {"coordinates":[-78.906243,42.934551],"type":"Point"} {"coordinates":[-74.91691,43.01619],"type":"Point"} {"coordinates":[-73.6818,42.78912],"type":"Point"} view top 100 |
| itsuid | itsuid | text | Open Data-generated unique row identifier constructed from dataset columns. | Black Rock Lock* C11 Comstock C12 Whitehall C1 Waterford C2 Mechanicville view top 100 |