Schema
River Gauges (USACE IENC) / River Gauges (USACE IENC) / v1.0.0
Schema from river-gauges-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 754Length: — | Examples: 649, 712, 405, 80, 423 Values: — |
| Category_o | string | Yes | 84 | — | — Range: —Length: 67 | Examples: Water Level Staff/Pole, Water Level Staff/Pole, Water Level Staff/Pole, Water Level Staff/Pole, Water Level Staff/Pole Values: Recording Water Level Gauge, Recording Water Level Gauge with Remote Access, Recording Water Level Guage with External Indicator, Recording Water Level Guage with Remote Access and Remote Indicator, Water Level Staff/Pole |
| Object_Nam | string | Yes | 311 | — | — Range: —Length: 56 | Examples: Lock and Dam No. 18 Lower Gage, Pickwick Landing Locks & Dam Upper Gage, Nickajack Lock Lower Gauge, Lock No. 11 Gage, Lock No. 15 Pool Gauge Values: — |
| Elevation | string | Yes | 658 | — | — Range: —Length: 7 | Examples: 139.5, 176.8, 280.2, 162.7, 173.3 Values: — |
| Reference_ | string | Yes | 629 | — | — Range: —Length: 39 | Examples: North American Vertical Datum-NAVD88, Mean Sea Level 1912, Mean Sea Level 1912, Mean Sea Level 1912, Mean Sea Level 1912 Values: Mean Sea Level 1912, National Geodetic Vertical Datum-NGVD29, North American Vertical Datum-NAVD88 |
| Waterway_D | string | Yes | 513 | — | — Range: —Length: 5 | Examples: 168.4, 349.1, 535.3, 414.4, 179.6 Values: — |
| Horizontal | string | No | 0 | — | — Range: —Length: 13 | Examples: Statute Miles, Statute Miles, Statute Miles, Statute Miles, Statute Miles Values: Statute Miles |
| Value_at_R | string | Yes | 697 | — | — Range: —Length: 4 | Examples: 5.55, 5.55, 4.27, 5.18, 6.52 Values: 4.27, 4.57, 5.18, 5.48, 5.49, 5.55, 5.61, 5.94, 6.1, 6.52, 6.67 |
| Name_of_Re | string | Yes | 697 | — | — Range: —Length: 12 | Examples: Lock Closure, Lock Closure, Lock Closure, Lock Closure, Lock Closure Values: Lock Closure |
| Value_at_1 | string | Yes | 666 | — | — Range: —Length: 6 | Examples: 0.51, 4.08, 1.52, 2.07, 5.64 Values: — |
| Name_at_Re | string | Yes | 666 | — | — Range: —Length: 27 | Examples: Pool 22 Flat Pool, Pool 22 Flat Pool, Flat Pool Stage, Flat Pool Stage, Pool 15 Flat Pool Values: FLat Pool Stage, Flat Pool Stage, Low Pool Stage, Pool 11 Flat Pool, Pool 12 Flat Pool, Pool 13 Flat Pool, Pool 14 Flat Pool, Pool 15 Flat Pool, Pool 16 Flat Pool, Pool 17 Flat Pool, Pool 18 Flat Pool, Pool 19 Flat Pool, Pool 20 Low Operating Level, Pool 21 Flat Pool, Pool 22 Flat Pool, Pool 24 Flat Pool |
| Name_of_So | string | Yes | 753 | — | — Range: —Length: 17 | Examples: Pool 14 Flat Pool Values: Pool 14 Flat Pool |
| Scale_Mini | integer | No | 0 | — | — Range: 45000 to 45000Length: — | Examples: 45000, 45000, 45000, 45000, 45000 Values: — |
| Source_Dat | string | No | 0 | — | — Range: —Length: 8 | Examples: 20140910, 20060417, 20101014, 20180917, 20240212 Values: — |
| Source_Ind | string | No | 0 | — | — Range: —Length: 88 | Examples: US,U3,SURVY,MVR_Field_Survey,IENC_14_061, US,U3,graph,St_Paul_SDS_1999, US,U3,SURVY,Seaside Engineering & Surveying, Inc., US,U3,SURVY,SWL_Field_Survey,IENC_18_058, US,U3,SURVY,AGC_MVK,IENC_24_032 Values: — |
| Source_D_1 | string | No | 0 | — | — Range: —Length: 12 | Examples: U37UM432.000, U37UM615.000, U37OH912.000, U37AR246.000, U37RR071.000 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 754Length: — | Examples: 649, 712, 405, 80, 423 Values: — |
