Schema
Lock Gate Lines (USACE IENC) / Lock Gate Lines (USACE IENC) / v1.0.0
Schema from lock-gate-lines-usace-ienc-2.parquet, gcp-portolan-published, v1.0.0.
The USACE IENCs coverage area consists of 7,260 miles across 21 rivers primarily located in the Central United States. IENCs apply to inland waterways that are maintained for navigation by USACE for shallow-draft vessels (e.g., maintained at a depth of 9-14 feet, dependent upon the waterway project authorization). Generally, IENCs are produced for those commercially navigable waterways which the National Oceanic and Atmospheric Administration (NOAA) does not produce Electronic Navigational Charts (ENCs). However, Special Purpose IENCs may be produced in agreement with NOAA. IENC POC: IENC_POC@usace.army.mil
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 299Length: — | Examples: 207, 189, 13, 220, 238 Values: — |
| Category_o | string | No | 0 | — | — Range: —Length: 18 | Examples: Lock Gate, Lock Gate, Lock Gate, Lock Gate, Lock Gate Values: Flood Barrage Gate, Lock Gate |
| Horizontal | string | No | 0 | — | — Range: —Length: 7 | Examples: 33.5, 33.5, Unknown, 33.5, 33.5 Values: 17.1, 18.3, 22.4, 22.5, 22.9, 24.4, 25.6, 26.6, 32.5, 33.5, 33.52, 33.53, 7.92, Unknown |
| Vertical_C | string | Yes | 286 | — | — Range: —Length: 7 | Examples: Unknown, Unknown, Unknown, Unknown, Unknown Values: Unknown |
| Object_Nam | string | Yes | 290 | — | — Range: —Length: 41 | Examples: Lock 25 Main Lock Downstream Miter Gate, Mel Price Aux Lock Upstream Miter Gate, Jerry F. Costello Upstream Miter Gate, Mel Price Main Lock Downstream Miter Gate, Lock 25 Aux Miter Gate Values: Jerry F. Costello Downstream Miter Gate, Jerry F. Costello Upstream Miter Gate, Lock 25 Aux Miter Gate, Lock 25 Main Lock Downstream Miter Gate, Lock 25 Main Lock Upstream Miter Gate, Mel Price Aux Lock Downtream Miter Gate, Mel Price Aux Lock Upstream Miter Gate, Mel Price Main Lock Downstream Miter Gate, Mel Price Main Lock Upstream Lift Gate |
| Informatio | string | Yes | 288 | — | — Range: —Length: 96 | Examples: Auxillary Lock Chamber, Auxilliary Gate, Lift gate, Harbor closure flood gate. Gates close with river stages over 18' on the Dubuque RR Bridge gage., Main Lock Chamber Values: Auxillary Lock Chamber, Auxilliary Gate, Gate is located within main lock chamber., Harbor closure flood gate. Gates close with river stages over 18' on the Dubuque RR Bridge gage., Lift gate, Lockage Size = 84ft x 705ft, Main Lock Chamber |
| Scale_Mini | integer | No | 0 | — | — Range: 22000 to 90000Length: — | Examples: 22000, 22000, 22000, 22000, 22000 Values: — |
| Source_Dat | string | No | 0 | — | — Range: —Length: 8 | Examples: 20200716, 20200716, 20130701, 19991201, 20140910 Values: — |
| Source_Ind | string | No | 0 | — | — Range: —Length: 88 | Examples: US,U3,SURVY,SAM_Field_Survey,IENC_20_050, US,U3,SURVY,SAM_Field_Survey,IENC_20_050, US,U3,SURVY,SWL_Field_Survey,IENC_13_033, US,U3,graph,St_Louis_SDS_1999, US,U3,SURVY,MVR_Field_Survey,IENC_14_061 Values: — |
| Source_D_1 | string | No | 0 | — | — Range: —Length: 12 | Examples: U37TT385.000, U37TT218.000, U37AR246.000, U37UM218.000, U37UM432.000 Values: — |
| SHAPE_Leng | float | No | 0 | — | — Range: 0.000040521599186 to 0.00046864274995Length: — | Examples: 0.000407944398657, 0.000406391611348, 0.000347739478856, 0.000332604878673, 0.000369295647617 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 299Length: — | Examples: 207, 189, 13, 220, 238 Values: — |