Back to fileView metadata
Schema
Locks (USACE IENC) / locks-usace-ienc-1 / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
49 columns
Features
234
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 234Length: — | Examples: 222, 102, 214, 191, 138 Values: — |
| ID | integer | No | 0 | — | — Range: 1 to 234Length: — | Examples: 222, 127, 214, 191, 80 Values: — |
| NDCCODE | string | No | 0 | — | — Range: —Length: 10 | Examples: 4326220601, 4421620601, 1183396001, 4274450601, 3279690601 Values: — |
| REGION | string | No | 0 | — | — Range: —Length: 2 | Examples: IN, IN, AT, IN, IN Values: AT, GL, GU, IN, PC |
| RIVERCD | string | No | 0 | — | — Range: —Length: 2 | Examples: AG, CU, FR, OH, MI Values: — |
| LOCKCD | string | No | 0 | — | — Range: —Length: 2 | Examples: 49, 24, 01, 22, 03 Values: — |
| CHMBCD | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 2, 1 Values: , 1, 2 |
| NOCHMB | integer | No | 0 | — | — Range: 1 to 5Length: — | Examples: 1, 1, 1, 2, 1 Values: — |
| PMSDATA | string | No | 0 | — | — Range: —Length: 1 | Examples: N, Y, N, Y, Y Values: N, Y |
| NAVSTR | string | No | 0 | — | — Range: —Length: 29 | Examples: 9, OLD HICKORY, 1, RACINE, 3 Values: — |
| CHAMBN | string | No | 0 | — | — Range: —Length: 9 | Examples: MAIN, MAIN, MAIN, MAIN, MAIN Values: AUXILLARY, CNTRL, MAIN, MAIN1 |
| CHB1 | string | No | 0 | — | — Range: —Length: 1 | Examples: M, M, M, M, M Values: A, C, M |
| STR1 | string | No | 0 | — | — Range: —Length: 1 | Examples: L, L, L, L, L Values: B, C, F, L |
| PMSNAME | string | No | 0 | — | — Range: —Length: 33 | Examples: LOCK & DAM 9, OLD HICKORY LOCK & DAM, LOCK & DAM 1, RACINE LOCKS & DAM, LOCK & DAM 3 Values: — |
| STATUS | string | No | 0 | — | — Range: —Length: 1 | Examples: 6, 1, 1, 1, 2 Values: 1, 2, 5, 6, 7, 8 |
| RIVER | string | No | 0 | — | — Range: —Length: 35 | Examples: ALLEGHENY, CUMBERLAND, CAPE FEAR, OHIO, MISSISSIPPI Values: — |
| RIVERMI | float | No | 0 | — | — Range: 0 to 964.4Length: — | Examples: 62.2, 216.2, 39.0, 237.5, 796.9 Values: — |
| BANK | string | No | 0 | — | — Range: —Length: 1 | Examples: L, L, R, L, R Values: , -, C, L, R |
| LIFT | integer | No | 0 | — | — Range: 0 to 110Length: — | Examples: 22, 60, 11, 22, 8 Values: — |
| LENGTH | integer | No | 0 | — | — Range: 0 to 1205Length: — | Examples: 360, 400, 200, 1200, 600 Values: — |
| CHMBUL | integer | No | 0 | — | — Range: 0 to 1200Length: — | Examples: 360, 397, 200, 1200, 600 Values: — |
| WIDTH | integer | No | 0 | — | — Range: 18 to 110Length: — | Examples: 56, 84, 40, 110, 110 Values: — |
| CHMBUW | integer | No | 0 | — | — Range: 0 to 110Length: — | Examples: 56, 84, 40, 110, 105 Values: — |
| AUDPA | integer | No | 0 | — | — Range: 0 to 34Length: — | Examples: 9, 9, 8, 9, 9 Values: — |
| AUDPB | integer | No | 0 | — | — Range: 0 to 30Length: — | Examples: 9, 9, 8, 9, 9 Values: — |
| UPDPTHMS | integer | No | 0 | — | — Range: 0 to 50Length: — | Examples: 11, 14, 9, 37, 17 Values: — |
| LWDPTHMS | integer | No | 0 | — | — Range: 0 to 35Length: — | Examples: 11, 13, 9, 15, 14 Values: — |
| YEAROPEN | integer | No | 0 | — | — Range: 1836 to 2018Length: — | Examples: 1938, 1954, 1915, 1967, 1938 Values: — |
| GATETYPE | string | No | 0 | — | — Range: —Length: 50 | Examples: Miter, Miter, Miter, Miter, (L) 4 Miter (D) Moveable, 4 Roller gates Values: — |
| GATE | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: , 1, 2, 3, 4, 5, 6, 7 |
| CHNLGTH | integer | No | 0 | — | — Range: 0 to 3700Length: — | Examples: 10, 97, 32, 34, 18 Values: — |
| CHNDPTHA | integer | No | 0 | — | — Range: 0 to 50Length: — | Examples: 9, 9, 8, 9, 9 Values: — |
| CHNDPTHB | integer | No | 0 | — | — Range: 0 to 50Length: — | Examples: 9, 9, 8, 9, 9 Values: — |
| CHNWDTHA | integer | No | 0 | — | — Range: 0 to 470Length: — | Examples: 200, 150, 100, 300, 300 Values: — |
| CHNWDTHB | integer | No | 0 | — | — Range: 0 to 350Length: — | Examples: 200, 150, 100, 300, 300 Values: — |
| WWPRJCT | string | No | 0 | — | — 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 | 0 | — | — Range: —Length: 1 | Examples: Y, Y, Y, Y, N Values: , L, N, Y |
| MULTI | string | No | 0 | — | — Range: —Length: 6 | Examples: NP, NPRF, N, NRCP, N Values: — |
| DIVISION | string | No | 0 | — | — Range: —Length: 3 | Examples: LRD, LRD, SAD, LRD, MVD Values: LRD, MVD, NAD, NWD, SAD, SPD, SWD |
| DISTRICT | string | No | 0 | — | — Range: —Length: 3 | Examples: LRP, LRN, SAW, LRH, MVP Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: PA, TN, NC, WV, MN Values: — |
| MAINT1 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 1, 4, 7, 8, Y |
| OPER1 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 1, 4, 5, 7, 8 |
| OWNER1 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 1, 2, 4 |
| TOWN | string | No | 0 | — | — Range: —Length: 17 | Examples: Rimer, Old Hickory, Kings Bluff, Letart, Red Wing Values: — |
| COUNTY1 | string | No | 0 | — | — Range: —Length: 23 | Examples: ARMSTRONG, DAVIDSON, BLADEN, MASON, GOODHUE Values: — |
| MOORING_R | string | No | 0 | — | — 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 | 0 | — | — Range: —Length: 0 | Examples: , , , , Values: |
Invalid geometry count: 0
Columns hash: 04a146b097fd77b653ebf6b4de7be13be4e1ee0f3eca2df6241c57c96b497902