Schema
NHD / Flowline / v1.0.0
Schema from flowline.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
The USGS 3D Hydrography Program (3DHP) ArcGIS REST service (3DHP_all) from The National Map is the first of several data services that will be delivered by the 3D Hydrography Program. The 3DHP_all comprises a national network of flowlines, hydrolocations, and water bodies, and will include catchments, drainage areas, and flow network derivatives as they are populated in the future. The 3DHP_all service will provide access to a 3D-enabled geospatial hydrography vector dataset built from 3DHP data and intended to provide the most comprehensive but general rendering of 3DHP data. 3DHP data is derived from elevation-derived hydrography (EDH) Elevation-Derived Hydrography Specifications | U.S. Geological Survey (usgs.gov) where available. Where EDH has not been collected, 3DHP data will be supplemented by data from the National Hydrography Dataset (NHD) National Hydrography Dataset | U.S. Geological Survey (usgs.gov). As further EDH data is collected, the EDH data will replace the NHD data in that data collection area. 3DHP data ingested from EDH sources will include catchments, drainage areas derived from catchments, and flowline network attribute derivatives.For additional information on the 3DHP, go to https://www.usgs.gov/3dhp.See https://apps.nationalmap.gov/help/ for assistance with The National Map viewer, download client, services, or metadata.
| 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: — |
