Baselight

Waterway Locks

Federal Geographic Data Committee

@usgov.fgdc_gov_waterway_locks_ddc5f

Loading...
Loading...

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
  • 60.41 KB
  • 234 rows
  • 50 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.