Back to fileView metadata
Schema
NHD / Flowline / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
35 columns
Features
3,268,534
Geometry
3D MultiLineString
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| id3dhp | string | No | 0 | — | — Range: —Length: 6 | Examples: 6B30U, E5KS0, DUKJO, 92IK2, C2LYY Values: — |
| featuredate | string | No | 0 | — | — Range: —Length: 25 | Examples: 2023-09-14T00:00:00+00:00, 2023-09-14T00:00:00+00:00, 2023-09-14T00:00:00+00:00, 2023-09-14T00:00:00+00:00, 2023-09-14T00:00:00+00:00 Values: 2023-09-14T00:00:00+00:00, 2024-03-04T21:14:00+00:00 |
| mainstemid | string | No | 0 | — | — Range: —Length: 44 | Examples: https://geoconnex.us/usgs/mainstems/9497244, https://geoconnex.us/usgs/mainstems/6687351, https://geoconnex.us/usgs/mainstems/3635779, https://geoconnex.us/usgs/mainstems/6675149, https://geoconnex.us/usgs/mainstems/3323782 Values: — |
| gnisid | float | Yes | 4,533 | — | — Range: 1397793 to 1894360Length: — | Examples: 1416406.0, 1398336.0, 1407625.0, 1406572.0, 1402053.0 Values: — |
| gnisidlabel | string | Yes | 4,533 | — | — Range: —Length: 28 | Examples: Susitna River, Anvik River, Oshetna River, Moose Creek, Finland Creek Values: — |
| featuretype | integer | No | 0 | — | — Range: 1 to 7Length: — | Examples: 1, 1, 5, 1, 1 Values: — |
| featuretypelabel | string | No | 0 | — | — Range: —Length: 26 | Examples: Channel Line, Channel Line, Waterbody Connector, Channel Line, Channel Line Values: Channel Line, Drainageway, Hydro Unenforced Connector, Surface Connector, Waterbody Connector |
| lengthkm | float | No | 0 | — | — Range: 0.00233835 to 12.821Length: — | Examples: 0.07745110000000001, 0.6297693000000001, 0.05389434, 0.262, 1.43136802 Values: — |
| waterbodyid3dhp | string | Yes | 4,000 | — | — Range: —Length: 6 | Examples: OEUL8, OJ4M1, OGR98, OG6QQ, MDUD1 Values: — |
| flowdirection | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| flowdirectionlabel | string | No | 0 | — | — Range: —Length: 81 | Examples: Flow direction is in digitized direction, and z-values on vertices flow downslope, Flow direction is in digitized direction, and z-values on vertices flow downslope, Flow direction is in digitized direction, and z-values on vertices flow downslope, Flow direction is in digitized direction, and z-values on vertices flow downslope, Flow direction is in digitized direction, and z-values on vertices flow downslope Values: Flow direction is in digitized direction, and z-values on vertices flow downslope, Flow direction is unable to be determined from elevation surface |
| onsurface | integer | No | 0 | — | — Range: 1 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| onsurfacelabel | string | No | 0 | — | — Range: —Length: 72 | Examples: Feature is on the land surface, Feature is on the land surface, Feature is on the land surface, Feature is on the land surface, Feature is on the land surface Values: Feature is above another hydrography feature, elevated above the surface, Feature is on the land surface |
| catchmentid3dhp | string | Yes | 4,985 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| flowpathid3dhp | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| streamlevel | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| startflag | float | Yes | 4,985 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 1.0, 0.0 Values: — |
| terminalflag | float | Yes | 4,985 | — | — Range: 0 to 0Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| streamorder | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| streamcalculator | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| hydrosequence | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| dnhydrosequence | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| uphydrosequence | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| dnlevelpath | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| uplevelpath | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| pathlength | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| arbolatesum | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| divergence | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| divergencelabel | string | No | 0 | — | — Range: —Length: 28 | Examples: Main path through divergence, Main path through divergence, Main path through divergence, Main path through divergence, Main path through divergence Values: Main path through divergence, No divergence |
| rtrndivergence | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| levelpath | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| terminalpath | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| workunitid | string | No | 0 | — | — Range: —Length: 8 | Examples: NHD, NHD, NHD, NHD, NHD Values: 19050401, NHD |
| shape_Length | float | No | 0 | — | — Range: 2.338382490958563 to 12821.195549787944Length: — | Examples: 77.45108519042755, 629.7692227520939, 53.89431225600141, 261.74535068995584, 1431.368029298651 Values: — |
Invalid geometry count: 0
Columns hash: 9f736a25e404c1f69ab1e315c2b87d79db32029789c673be08982666259b6dc4