Schema
Lock Gate Areas (USACE IENC) / Lock Gate Areas (USACE IENC) / v1.0.0
Schema from lock-gate-areas-usace-ienc.parquet, gcs-hifld-next-datasets-prod, 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 94Length: — | Examples: 3, 31, 57, 17, 14 Values: — |
| Category_o | string | No | 0 | — | — Range: —Length: 9 | Examples: Lock Gate, Lock Gate, Lock Gate, Lock Gate, Lock Gate Values: Lock Gate |
| Horizontal | string | No | 0 | — | — Range: —Length: 7 | Examples: 17.1, 33.5, 16.8, 33.5, 33.5 Values: 16.8, 17.1, 25.6, 33.5, 55.6, Unknown |
| Vertical_C | string | Yes | 90 | — | — Range: —Length: 4 | Examples: 25.9, 25.9, 24.1, 24.1 Values: 24.1, 25.9 |
| Object_Nam | string | Yes | 77 | — | — Range: —Length: 23 | Examples: LaGrange Lock & Dam, Starved Rock Lock & Dam, Dresden Lock & Dam, Dresden Lock & Dam, Lockport Lock & Dam Values: Brandon Road Lock & Dam, Dresden Lock & Dam, LaGrange Lock & Dam, Lockport Lock & Dam, Marseilles Lock, Peoria Lock & Dam, Starved Rock Lock & Dam |
| Informatio | string | Yes | 94 | — | — Range: —Length: — | Examples: — Values: — |
| Scale_Mini | integer | No | 0 | — | — Range: 22000 to 22000Length: — | Examples: 22000, 22000, 22000, 22000, 22000 Values: — |
| Source_Dat | string | No | 0 | — | — Range: —Length: 8 | Examples: 20140805, 20130725, 20111218, 20090203, 20090203 Values: 20060614, 20090203, 20100430, 20110920, 20110922, 20111217, 20111218, 20120627, 20120628, 20130213, 20130725, 20140805, 20141028, 20150731 |
| Source_Ind | string | No | 0 | — | — Range: —Length: 42 | Examples: US,U3,SURVY,2014_SEAS_LIDAR_Mapping_Survey, US,U3,SURVY,MVR_Field_Survey,IENC_13_037, US,U3,SURVY,2011 SEAS LIDAR Mapping Survey, US,U3,SURVY,SWL_Field_Survey,IENC_09_014, US,U3,SURVY,SWL_Field_Survey,IENC_09_014 Values: US,U3,SURVY,2011 SEAS LIDAR Mapping Survey, US,U3,SURVY,2011_SEAS_LIDAR_Mapping_Survey, US,U3,SURVY,2012_SEAS_LIDAR_Mapping_Survey, US,U3,SURVY,2014_SEAS_LIDAR_Mapping_Survey, US,U3,SURVY,MVK_Field_Survey,IENC_10_000, US,U3,SURVY,MVR_Field_Survey,IENC_13_037, US,U3,SURVY,MVR_Field_Survey,IENC_15_010, US,U3,SURVY,SWL_Field_Survey,IENC_09_014, US,U3,SURVY,SWL_Field_Survey,IENC_13_014, US,U3,SURVY,SWL_Field_Survey,IENC_15_060, US,U3,graph,Arkansas_SDS_2006, US,U3,survy,USACE Cannelton foot print, US,U3,survy,USACE JT Myers L&D FootPrint, US,U3,survy,USACE Newburgh footprint |
| Source_D_1 | string | No | 0 | — | — Range: —Length: 12 | Examples: U37AG001.000, U37IL137.000, U37OH582.000, U37AR063.000, U37AR001.000 Values: U37AG001.000, U37AR001.000, U37AR063.000, U37AR308.000, U37IL005.000, U37IL137.000, U37IL199.000, U37IL257.000, U37IL285.000, U37LM520.000, U37OH439.000, U37OH582.000, U37OH644.000, U37OH736.000, U37OU005.000, U37OU089.000, U37OU178.000, U37OU256.000 |
| SHAPE_Leng | float | No | 0 | — | — Range: 0.000199533632151 to 0.00100748512605Length: — | Examples: 0.000487171843156, 0.000854115898468, 0.000386036845234, 0.000775853530375, 0.000692934982561 Values: — |
| SHAPE_Area | float | No | 0 | — | — Range: 3.11545e-10 to 1.60768e-8Length: — | Examples: 3.308445e-09, 8.008085e-09, 4.08362e-09, 5.22308e-09, 4.917325e-09 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 94Length: — | Examples: 3, 31, 57, 17, 14 Values: — |
