Schema
NHD / Flowline - Small Scale (HI, PR, VI, Pacific Territories) / v1.0.0
Schema from flowline-small-scale-hi-pr-vi-pacific-territories-2.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
Please use 3DHP for updated data The USGS National Hydrography Dataset (NHD) service from The National Map is a comprehensive set of digital spatial data that encodes information about naturally occurring and constructed bodies of surface water (lakes, ponds, and reservoirs), paths through which water flows (canals, ditches, streams, and rivers), and related entities such as point features (springs, wells, stream gages, and dams). The information encoded about these features includes classification and other characteristics, delineation, geographic name, position and related measures, a "reach code" through which other information can be related to the NHD, and the direction of water flow. The network of reach codes delineating water and transported material flow allows users to trace movement in upstream and downstream directions. In addition to this geographic information, the dataset contains metadata that supports the exchange of future updates and improvements to the data. The NHD is available nationwide in two seamless datasets, one based on 1:24,000 (or larger) scale and referred to as high resolution NHD, and the other based on 1:100,000 scale and referred to as medium resolution NHD. The NHD from The National Map supports many applications, such as making maps, geocoding observations, flow modeling, data maintenance, and stewardship. The NHD is commonly combined with other data themes, such as boundaries, elevation, structures, and transportation, to produce general reference base maps. The National Map download client allows free downloads of public domain NHD data in either Esri File Geodatabase or Shapefile formats. For additional information on the NHD, go to https://www.usgs.gov/national-hydrography/national-hydrography-dataset. See https://apps.nationalmap.gov/help/ for assistance with The National Map viewer, download client, services, or metadata. Data Refreshed January, 2024.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| Permanent_ | string | No | 0 | — | — Range: —Length: 38 | Examples: 26348628, 26359571, 26362429, 26362095, 26350174 Values: — |
| FDate | string | No | 0 | — | — Range: —Length: 10 | Examples: 2012-03-10, 2012-03-10, 2012-03-10, 2012-03-10, 2012-03-10 Values: 2012-03-10, 2013-07-14, 2013-07-15, 2013-07-25, 2013-07-28, 2013-11-09, 2013-11-10, 2013-11-11, 2014-04-01, 2014-07-26, 2014-07-30, 2014-08-06, 2014-08-12, 2014-09-09, 2014-10-08 |
| Resolution | string | No | 0 | — | — Range: —Length: 4 | Examples: High, High, High, High, High Values: High |
| GNIS_ID | string | Yes | 3,656 | — | — Range: —Length: 7 | Examples: 1612477, 1612417, 1612435, 1612469, 1612614 Values: — |
| GNIS_Name | string | Yes | 3,656 | — | — Range: —Length: 21 | Examples: Río Coco, Río de Caguana, Río Blanco, Río Cialitos, Río Toro Negro Values: — |
| LengthKM | float | No | 0 | — | — Range: 0.00334904 to 16.46170833Length: — | Examples: 0.454, 0.694, 0.52, 1.425, 0.335 Values: — |
| ReachCode | string | No | 0 | — | — Range: —Length: 14 | Examples: 21010002001191, 21010003001063, 21010003001928, 21010003001699, 21010002001410 Values: — |
| FlowDir | string | No | 0 | — | — Range: —Length: 13 | Examples: WithDigitized, WithDigitized, WithDigitized, WithDigitized, WithDigitized Values: WithDigitized |
| WBArea_Per | string | Yes | 4,374 | — | — Range: —Length: 38 | Examples: 26337370, 26350316, 120006949, 26335618, 120006949 Values: — |
| FTYPE | string | No | 0 | — | — Range: —Length: 14 | Examples: StreamRiver, StreamRiver, StreamRiver, StreamRiver, StreamRiver Values: ArtificialPath, CanalDitch, Coastline, Connector, Pipeline, StreamRiver |
| FCode | integer | No | 0 | — | — Range: 33400 to 56600Length: — | Examples: 46003, 46003, 46003, 46003, 46003 Values: — |
| ComID | integer | No | 0 | — | — Range: 800023730 to 800041589Length: — | Examples: 800035212, 800039151, 800030414, 800026191, 800024021 Values: — |
| WbAreaComi | integer | No | 0 | — | — Range: 0 to 800046378Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| StreamLeve | integer | No | 0 | — | — Range: 0 to 7Length: — | Examples: 4, 3, 2, 3, 3 Values: — |
| StreamOrde | integer | No | 0 | — | — Range: 0 to 6Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| StreamCalc | integer | No | 0 | — | — Range: 0 to 6Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| FromNode | integer | No | 0 | — | — Range: 880000001 to 880015388Length: — | Examples: 880013598, 880014832, 880012120, 880010821, 880010140 Values: — |
| ToNode | integer | No | 0 | — | — Range: 880000000 to 880015916Length: — | Examples: 880000413, 880006093, 880007185, 880006044, 880001377 Values: — |
| HydroSeq | integer | No | 0 | — | — Range: 880000001 to 880015513Length: — | Examples: 880012166, 880010995, 880013567, 880014794, 880015428 Values: — |
| LevelPathI | integer | No | 0 | — | — Range: 880000001 to 880015513Length: — | Examples: 880012166, 880010995, 880013567, 880007509, 880007375 Values: — |
| Pathlength | float | No | 0 | — | — Range: -9999 to 89.963Length: — | Examples: 8.835, 32.459, 7.372, 24.726, 6.044 Values: — |
| TerminalPa | integer | No | 0 | — | — Range: 880000001 to 880010267Length: — | Examples: 880001948, 880001796, 880004013, 880001796, 880004206 Values: — |
| ArbolateSu | float | No | 0 | — | — Range: -9999 to 905.675Length: — | Examples: 0.453, 0.694, 0.519, 1.425, 0.335 Values: — |
| Divergence | integer | No | 0 | — | — Range: 0 to 2Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| StartFlag | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| TerminalFl | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DnLevel | integer | No | 0 | — | — Range: 0 to 6Length: — | Examples: 3, 2, 1, 3, 3 Values: — |
| UpLevelPat | integer | No | 0 | — | — Range: 0 to 880010371Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| UpHydroSeq | integer | No | 0 | — | — Range: 0 to 880015511Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DnLevelPat | integer | No | 0 | — | — Range: 0 to 880010371Length: — | Examples: 880006065, 880007948, 880004013, 880007509, 880007375 Values: — |
| DnMinorHyd | integer | No | 0 | — | — Range: 0 to 880010275Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DnDrainCou | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| DnHydroSeq | integer | No | 0 | — | — Range: 0 to 880010373Length: — | Examples: 880008069, 880008962, 880006369, 880008976, 880010036 Values: — |
| FromMeas | float | No | 0 | — | — Range: 0 to 99.86066Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 84.40542 Values: — |
| ToMeas | float | No | 0 | — | — Range: 0.07022 to 100Length: — | Examples: 100.0, 100.0, 100.0, 100.0, 100.0 Values: — |
| RtnDiv | integer | No | 0 | — | — Range: 0 to 9Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| VPUIn | integer | No | 0 | — | — Range: 0 to 0Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| VPUOut | integer | No | 0 | — | — Range: 0 to 0Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| AreaSqKm | float | No | 0 | — | — Range: 0 to 86.6293Length: — | Examples: 0.3045, 0.4924, 0.4392, 1.0299, 0.0703 Values: — |
| TotDASqKm | float | No | 0 | — | — Range: -9999 to 540.7837Length: — | Examples: 0.3045, 0.4924, 0.4392, 1.0299, 0.0703 Values: — |
| DivDASqKm | float | No | 0 | — | — Range: -9999 to 540.7837Length: — | Examples: 0.3045, 0.4924, 0.4392, 1.0299, 0.0703 Values: — |
| Tidal | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| TOTMA | float | No | 0 | — | — Range: -9999 to 0.982161984046Length: — | Examples: 0.0299501379914, 0.0335707563513, 0.0270538528396, 0.0640686194063, 0.0239289137787 Values: — |
| WBAreaType | string | Yes | 4,379 | — | — Range: —Length: 11 | Examples: StreamRiver, StreamRiver, StreamRiver, LakePond, StreamRiver Values: CanalDitch, LakePond, Reservoir, StreamRiver, SwampMarsh |
| HWNodeSqKM | string | Yes | 3,101 | — | — Range: —Length: 21 | Examples: 0.0546, 0.1007, 0.0598, 0.0755, 0.1319 Values: — |
| MaxElevRaw | string | Yes | 144 | — | — Range: —Length: 6 | Examples: -9998, -9998, -9998, 83, 73947 Values: — |
| MinElevRaw | string | Yes | 144 | — | — Range: —Length: 6 | Examples: 8032, 100, 68019, 41, 62271 Values: — |
| MaxElevSmo | string | Yes | 144 | — | — Range: —Length: 6 | Examples: 8089, 100, 71510, 96, 73947 Values: — |
| MinElevSmo | string | Yes | 144 | — | — Range: —Length: 6 | Examples: 8089, 100, 68019, 96, 62271 Values: — |
| Slope | string | Yes | 144 | — | — Range: —Length: 21 | Examples: 1e-05, 1e-05, 0.2342953, 1e-05, 0.18074303 Values: — |
| ElevFixed | string | Yes | 144 | — | — Range: —Length: 1 | Examples: 0, 0, 1, 0, 1 Values: 0, 1 |
| HWType | string | Yes | 3,082 | — | — Range: —Length: 1 | Examples: H, H, H, H, H Values: E, H |
| SlopeLenKm | string | Yes | 144 | — | — Range: —Length: 20 | Examples: 0.312000006437302, 0.298000007867813, 0.149000003933907, 0.197999998927116, 0.646000027656555 Values: — |
| QA_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| VA_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| QC_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| VC_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| QE_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| VE_MA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| LakeFract | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| SurfArea | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| RAreaHLoad | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| RPUID | string | Yes | 46 | — | — Range: —Length: 3 | Examples: 21a, 21a, 21a, 21a, 21a Values: 21a |
| VPUID | string | No | 0 | — | — Range: —Length: 2 | Examples: 21, 21, 21, 21, 21 Values: 21 |
| Enabled | integer | No | 0 | — | — Range: 1 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| Shape_Leng | float | No | 0 | — | — Range: 3.547579964755099 to 16448.03588124108Length: — | Examples: 481.52233766079365, 731.6862380672821, 548.0718382971695, 1502.012728966842, 353.166205390563 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
