About this Dataset

Waterway Locks

The Waterway Locks dataset is periodically updated by the United States Army Corp of Engineers (USACE) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The data included in these files are based upon the annual summary of lock statistics published by the USACE Institute for Water Resources. The data are collected at each Corps owned and/or operated Lock by Corps personnel and towing industry vessel operators. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529089.
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:05:29.366466
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_waterway_locks_ddc5f.table_1

61.86 kB
234 rows
50 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "id" BIGINT,
  "ndccode" VARCHAR,
  "region" VARCHAR,
  "rivercd" VARCHAR,
  "lockcd" VARCHAR,
  "chmbcd" VARCHAR,
  "nochmb" BIGINT,
  "pmsdata" VARCHAR,
  "navstr" VARCHAR,
  "chambn" VARCHAR,
  "chb1" VARCHAR,
  "str1" VARCHAR,
  "pmsname" VARCHAR,
  "status" BIGINT,
  "river" VARCHAR,
  "rivermi" DOUBLE,
  "bank" VARCHAR,
  "lift" BIGINT,
  "length" BIGINT,
  "chmbul" BIGINT,
  "width" BIGINT,
  "chmbuw" BIGINT,
  "audpa" BIGINT,
  "audpb" BIGINT,
  "updpthms" BIGINT,
  "lwdpthms" BIGINT,
  "yearopen" BIGINT,
  "gatetype" VARCHAR,
  "gate" VARCHAR,
  "chnlgth" BIGINT,
  "chndptha" BIGINT,
  "chndpthb" BIGINT,
  "chnwdtha" BIGINT,
  "chnwdthb" BIGINT,
  "wwprjct" VARCHAR,
  "mooring" VARCHAR,
  "multi" VARCHAR,
  "division" VARCHAR,
  "district" VARCHAR,
  "state" VARCHAR,
  "maint1" VARCHAR,
  "oper1" BIGINT,
  "owner1" BIGINT,
  "town" VARCHAR,
  "county1" VARCHAR,
  "mooring_r" VARCHAR,
  "se_anno_cad_data" VARCHAR
);