Schema

Locks (USACE IENC) / Locks (USACE IENC) / v1.0.0

Schema from locks-usace-ienc-1.parquet, gcp-portolan-published, v1.0.0.

The Navigation Data Center (NDC) produces and stores data on lock characteristics nationwide in the Lock Performance Monitoring System (LPMS) and the Lock Characteristics database. These data sets are developed using input from surveys conducted by NDC staff. Information collected includes the physical aspects of all USACE built, maintained, owned, or operated locks. The data set captures six major characteristics including location, physical characteristics, site information, site characteristics, management information, and historical changes.

Columns

49 columns

Features

234

Geometry

Point

Version

Search columns

Column	Type	Nullable	Unique	Description	Examples / Values
geometry	geometry	No	—	— Range: —Length: —	Examples: — Values: —
OBJECTID	integer	No	—	— Range: 1 to 234Length: —	Examples: 222, 102, 214, 191, 138 Values: —
ID	integer	No	—	— Range: 1 to 234Length: —	Examples: 222, 127, 214, 191, 80 Values: —
NDCCODE	string	No	—	— Range: —Length: 10	Examples: 4326220601, 4421620601, 1183396001, 4274450601, 3279690601 Values: —
REGION	string	No	—	— Range: —Length: 2	Examples: IN, IN, AT, IN, IN Values: AT, GL, GU, IN, PC
RIVERCD	string	No	—	— Range: —Length: 2	Examples: AG, CU, FR, OH, MI Values: —
LOCKCD	string	No	—	— Range: —Length: 2	Examples: 49, 24, 01, 22, 03 Values: —
CHMBCD	string	No	—	— Range: —Length: 1	Examples: 1, 1, 1, 2, 1 Values: , 1, 2
NOCHMB	integer	No	—	— Range: 1 to 5Length: —	Examples: 1, 1, 1, 2, 1 Values: —
PMSDATA	string	No	—	— Range: —Length: 1	Examples: N, Y, N, Y, Y Values: N, Y
NAVSTR	string	No	—	— Range: —Length: 29	Examples: 9, OLD HICKORY, 1, RACINE, 3 Values: —
CHAMBN	string	No	—	— Range: —Length: 9	Examples: MAIN, MAIN, MAIN, MAIN, MAIN Values: AUXILLARY, CNTRL, MAIN, MAIN1
CHB1	string	No	—	— Range: —Length: 1	Examples: M, M, M, M, M Values: A, C, M
STR1	string	No	—	— Range: —Length: 1	Examples: L, L, L, L, L Values: B, C, F, L
PMSNAME	string	No	—	— Range: —Length: 33	Examples: LOCK & DAM 9, OLD HICKORY LOCK & DAM, LOCK & DAM 1, RACINE LOCKS & DAM, LOCK & DAM 3 Values: —
STATUS	string	No	—	— Range: —Length: 1	Examples: 6, 1, 1, 1, 2 Values: 1, 2, 5, 6, 7, 8
RIVER	string	No	—	— Range: —Length: 35	Examples: ALLEGHENY, CUMBERLAND, CAPE FEAR, OHIO, MISSISSIPPI Values: —
RIVERMI	float	No	—	— Range: 0 to 964.4Length: —	Examples: 62.2, 216.2, 39.0, 237.5, 796.9 Values: —
BANK	string	No	—	— Range: —Length: 1	Examples: L, L, R, L, R Values: , -, C, L, R
LIFT	integer	No	—	— Range: 0 to 110Length: —	Examples: 22, 60, 11, 22, 8 Values: —
LENGTH	integer	No	—	— Range: 0 to 1205Length: —	Examples: 360, 400, 200, 1200, 600 Values: —
CHMBUL	integer	No	—	— Range: 0 to 1200Length: —	Examples: 360, 397, 200, 1200, 600 Values: —
WIDTH	integer	No	—	— Range: 18 to 110Length: —	Examples: 56, 84, 40, 110, 110 Values: —
CHMBUW	integer	No	—	— Range: 0 to 110Length: —	Examples: 56, 84, 40, 110, 105 Values: —
AUDPA	integer	No	—	— Range: 0 to 34Length: —	Examples: 9, 9, 8, 9, 9 Values: —
AUDPB	integer	No	—	— Range: 0 to 30Length: —	Examples: 9, 9, 8, 9, 9 Values: —
UPDPTHMS	integer	No	—	— Range: 0 to 50Length: —	Examples: 11, 14, 9, 37, 17 Values: —
LWDPTHMS	integer	No	—	— Range: 0 to 35Length: —	Examples: 11, 13, 9, 15, 14 Values: —
YEAROPEN	integer	No	—	— Range: 1836 to 2018Length: —	Examples: 1938, 1954, 1915, 1967, 1938 Values: —
GATETYPE	string	No	—	— Range: —Length: 50	Examples: Miter, Miter, Miter, Miter, (L) 4 Miter (D) Moveable, 4 Roller gates Values: —
GATE	string	No	—	— Range: —Length: 1	Examples: 1, 1, 1, 1, 1 Values: , 1, 2, 3, 4, 5, 6, 7
CHNLGTH	integer	No	—	— Range: 0 to 3700Length: —	Examples: 10, 97, 32, 34, 18 Values: —
CHNDPTHA	integer	No	—	— Range: 0 to 50Length: —	Examples: 9, 9, 8, 9, 9 Values: —
CHNDPTHB	integer	No	—	— Range: 0 to 50Length: —	Examples: 9, 9, 8, 9, 9 Values: —
CHNWDTHA	integer	No	—	— Range: 0 to 470Length: —	Examples: 200, 150, 100, 300, 300 Values: —
CHNWDTHB	integer	No	—	— Range: 0 to 350Length: —	Examples: 200, 150, 100, 300, 300 Values: —
WWPRJCT	string	No	—	— Range: —Length: 48	Examples: ALLEGHENY, CUMBERLAND RIVER, TN & KY, CAPE FEAR RIVER, OHIO RIVER, MISSISSIPPI R BETWN MISSOURI R & MINNEAPOLIS, MN Values: —
MOORING	string	No	—	— Range: —Length: 1	Examples: Y, Y, Y, Y, N Values: , L, N, Y
MULTI	string	No	—	— Range: —Length: 6	Examples: NP, NPRF, N, NRCP, N Values: —
DIVISION	string	No	—	— Range: —Length: 3	Examples: LRD, LRD, SAD, LRD, MVD Values: LRD, MVD, NAD, NWD, SAD, SPD, SWD
DISTRICT	string	No	—	— Range: —Length: 3	Examples: LRP, LRN, SAW, LRH, MVP Values: —
STATE	string	No	—	— Range: —Length: 2	Examples: PA, TN, NC, WV, MN Values: —
MAINT1	string	No	—	— Range: —Length: 1	Examples: 1, 1, 1, 1, 1 Values: 1, 4, 7, 8, Y
OPER1	string	No	—	— Range: —Length: 1	Examples: 1, 1, 1, 1, 1 Values: 1, 4, 5, 7, 8
OWNER1	string	No	—	— Range: —Length: 1	Examples: 1, 1, 1, 1, 1 Values: 1, 2, 4
TOWN	string	No	—	— Range: —Length: 17	Examples: Rimer, Old Hickory, Kings Bluff, Letart, Red Wing Values: —
COUNTY1	string	No	—	— Range: —Length: 23	Examples: ARMSTRONG, DAVIDSON, BLADEN, MASON, GOODHUE Values: —
MOORING_R	string	No	—	— Range: —Length: 70	Examples: 1 UPPER, a. 2 cells upstream 300' apart. b. 2 cells below 250'., 8 sets cluster piling/ 9 sets coffer cells/ & fender system., 2 EMERGENCY CELLS UPSTREAM, NONE Values: —
SE_ANNO_CAD_DATA	string	No	—	— Range: —Length: 0	Examples: , , , , Values:

Quality checks: Passed

Invalid geometry count: 0

Columns hash: 04a146b097fd77b653ebf6b4de7be13be4e1ee0f3eca2df6241c57c96b497902