Schema
NHD / flowline-small-scale-2 / v1.0.0
Schema from flowline-small-scale-2.parquet, gcp-portolan-published, 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: — |
| FDATE | integer | No | 0 | — | — Range: 927763200000 to 1265932800000Length: — | Examples: 930009600000, 1217289600000, 930009600000, 1215648000000, 1219881600000 Values: — |
| GNIS_ID | string | No | 0 | — | — Range: —Length: 7 | Examples: , , , 573551, 575797 Values: — |
| GNIS_NAME | string | No | 0 | — | — Range: —Length: 40 | Examples: , , , Pocwock Stream, South Branch Russell Brook Values: — |
| LENGTHKM | float | No | 0 | — | — Range: 0.001 to 42.503Length: — | Examples: 4.051, 0.037, 2.469, 0.121, 1.365 Values: — |
| REACHCODE | string | No | 0 | — | — Range: —Length: 14 | Examples: 01010002000368, 01010004002121, 01010007008070, 01010007007915, 01010002000577 Values: — |
| FCODE | integer | No | 0 | — | — Range: 33400 to 55800Length: — | Examples: 46003, 55800, 46003, 55800, 55800 Values: — |
| Shape_Length | float | No | 0 | — | — Range: 1.0068154367966191 to 61506.8850496721Length: — | Examples: 5913.525684213643, 53.29221439389987, 3602.2857967881423, 177.86251920688716, 1970.9490409860161 Values: — |
| COMID | integer | No | 0 | — | — Range: 717008 to 931010009Length: — | Examples: 717970, 807839, 4289443, 4288663, 720168 Values: — |
| RESOLUTION | string | No | 0 | — | — Range: —Length: 6 | Examples: Medium, Medium, Medium, Medium, Medium Values: Medium |
| FLOWDIR | string | No | 0 | — | — Range: —Length: 14 | Examples: With Digitized, With Digitized, With Digitized, With Digitized, With Digitized Values: With Digitized |
| WBAREACOMI | integer | No | 0 | — | — Range: -9998 to 166421060Length: — | Examples: 0, 806323, 0, 120049636, 719572 Values: — |
| FTYPE | string | No | 0 | — | — Range: —Length: 14 | Examples: StreamRiver, ArtificialPath, StreamRiver, ArtificialPath, ArtificialPath Values: ArtificialPath, Connector, StreamRiver |
| StreamLeve | integer | No | 0 | — | — Range: 2 to 10Length: — | Examples: 7, 5, 5, 5, 7 Values: — |
| StreamOrde | integer | No | 0 | — | — Range: 1 to 5Length: — | Examples: 1, 3, 1, 3, 1 Values: — |
| StreamCalc | integer | No | 0 | — | — Range: 0 to 5Length: — | Examples: 1, 3, 1, 3, 1 Values: — |
| FromNode | integer | No | 0 | — | — Range: 150000866 to 150067860Length: — | Examples: 150049040, 150003309, 150055081, 150015162, 150001497 Values: — |
| ToNode | integer | No | 0 | — | — Range: 150000866 to 150068765Length: — | Examples: 150000942, 150003129, 150015476, 150015161, 150001428 Values: — |
| Hydroseq | integer | No | 0 | — | — Range: 150003082 to 150067568Length: — | Examples: 150067516, 150016950, 150061597, 150026858, 150031612 Values: — |
| LevelPathI | integer | No | 0 | — | — Range: 150002518 to 150067567Length: — | Examples: 150067516, 150010388, 150045075, 150026858, 150022507 Values: — |
| Pathlength | float | No | 0 | — | — Range: 0 to 384.932Length: — | Examples: 158.898, 197.192, 254.216, 163.569, 270.436 Values: — |
| TerminalPa | integer | No | 0 | — | — Range: 150002434 to 150047956Length: — | Examples: 150002518, 150003082, 150002518, 150002518, 150002518 Values: — |
| ArbolateSu | float | No | 0 | — | — Range: 0.035 to 3859.837Length: — | Examples: 4.051, 34.175, 2.469, 60.839, 4.264 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, 0, 1, 0, 0 Values: — |
| TerminalFl | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DnLevel | integer | No | 0 | — | — Range: 0 to 9Length: — | Examples: 6, 5, 5, 4, 7 Values: — |
| UpLevelPat | integer | No | 0 | — | — Range: 0 to 150048670Length: — | Examples: 0, 150010388, 0, 150026858, 150022507 Values: — |
| UpHydroseq | integer | No | 0 | — | — Range: 0 to 150067568Length: — | Examples: 0, 150022440, 0, 150030516, 150037669 Values: — |
| DnLevelPat | integer | No | 0 | — | — Range: 0 to 150048670Length: — | Examples: 150022519, 150010388, 150045075, 150002518, 150022507 Values: — |
| DnMinorHyd | integer | No | 0 | — | — Range: 0 to 150048376Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DnDrainCou | integer | No | 0 | — | — Range: 0 to 2Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| DnHydroseq | integer | No | 0 | — | — Range: 0 to 150048670Length: — | Examples: 150024760, 150016048, 150045075, 150003623, 150027651 Values: — |
| FromMeas | float | No | 0 | — | — Range: 0 to 99.89607Length: — | Examples: 0.0, 0.0, 2.38457, 0.0, 0.0 Values: — |
| ToMeas | float | No | 0 | — | — Range: 0.22102 to 100Length: — | Examples: 100.0, 100.0, 100.0, 1.72768, 100.0 Values: — |
| RtnDiv | integer | No | 0 | — | — Range: 0 to 1Length: — | 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 663.1722Length: — | Examples: 4.7376, 0.0072, 5.0031, 0.0225, 2.9043 Values: — |
| TotDASqKM | float | No | 0 | — | — Range: 0 to 6353.1936Length: — | Examples: 4.7376, 52.7877, 5.0031, 177.1713, 16.0074 Values: — |
| DivDASqKM | float | No | 0 | — | — Range: 0 to 6310.5588Length: — | Examples: 4.7376, 52.7877, 5.0031, 177.1713, 16.0074 Values: — |
| HWNodeSqKM | string | Yes | 3,374 | — | — Range: —Length: 19 | Examples: 0.0549, 1.0044, 0.0891, 0.2448, 1.9107 Values: — |
| MAXELEVRAW | integer | No | 0 | — | — Range: -9998 to 59970Length: — | Examples: 28587, -9998, 35350, -9998, -9998 Values: — |
| MINELEVRAW | integer | No | 0 | — | — Range: -9998 to 59969Length: — | Examples: 25536, 22963, 31382, 21170, 34464 Values: — |
| MAXELEVSMO | integer | No | 0 | — | — Range: 7700 to 59970Length: — | Examples: 28587, 22963, 35350, 21319, 34638 Values: — |
| MINELEVSMO | integer | No | 0 | — | — Range: 7500 to 59969Length: — | Examples: 25547, 22963, 31382, 21170, 34464 Values: — |
| SLOPE | float | No | 0 | — | — Range: -9998 to 0.6775Length: — | Examples: 0.02596071, 1e-05, 0.01711082, 0.01231404, 0.00127472 Values: — |
| ELEVFIXED | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1 |
| HWTYPE | string | No | 0 | — | — Range: —Length: 1 | Examples: H, , H, , Values: , E, H |
| SLOPELENKM | float | No | 0 | — | — Range: 0.00100000005 to 42.5029984Length: — | Examples: 1.171, 0.0370000005, 2.31900001, 0.120999999, 1.36500001 Values: — |
| QA_MA | float | No | 0 | — | — Range: 0 to 4069.716Length: — | Examples: 2.295, 29.281, 2.646, 93.717, 9.153 Values: — |
| VA_MA | float | No | 0 | — | — Range: -9998 to 2.76183Length: — | Examples: 0.89926, -9998.0, 0.87233, 1.52302, -9998.0 Values: — |
| QC_MA | float | No | 0 | — | — Range: 0 to 4069.716Length: — | Examples: 2.295, 32.307, 2.646, 101.434, 10.294 Values: — |
| VC_MA | float | No | 0 | — | — Range: -9998 to 2.76183Length: — | Examples: 0.89926, -9998.0, 0.87233, 1.53083, -9998.0 Values: — |
| QE_MA | float | No | 0 | — | — Range: 0 to 4161.833Length: — | Examples: 2.295, 32.307, 2.646, 101.434, 10.294 Values: — |
| VE_MA | float | No | 0 | — | — Range: -9998 to 2.78731Length: — | Examples: 0.89926, -9998.0, 0.87233, 1.53083, -9998.0 Values: — |
| QA_01 | float | No | 0 | — | — Range: 0 to 947.596Length: — | Examples: 0.564, 8.278, 0.672, 21.067, 2.352 Values: — |
| VA_01 | float | No | 0 | — | — Range: -9998 to 1.55259Length: — | Examples: 0.58883, -9998.0, 0.58077, 0.85824, -9998.0 Values: — |
| QC_01 | float | No | 0 | — | — Range: 0 to 1434.297Length: — | Examples: 0.564, 21.822, 0.672, 53.316, 6.552 Values: — |
| VC_01 | float | No | 0 | — | — Range: -9998 to 1.94617Length: — | Examples: 0.58883, -9998.0, 0.58077, 1.17716, -9998.0 Values: — |
| QE_01 | float | No | 0 | — | — Range: 0 to 1282.771Length: — | Examples: 0.564, 21.822, 0.672, 53.316, 6.552 Values: — |
| VE_01 | float | No | 0 | — | — Range: -9998 to 1.93921Length: — | Examples: 0.58883, -9998.0, 0.58077, 1.17716, -9998.0 Values: — |
| QA_02 | float | No | 0 | — | — Range: 0 to 472.701Length: — | Examples: 0.254, 4.248, 0.336, 10.52, 1.127 Values: — |
| VA_02 | float | No | 0 | — | — Range: -9998 to 1.16784Length: — | Examples: 0.49199, -9998.0, 0.4969, 0.68867, -9998.0 Values: — |
| QC_02 | float | No | 0 | — | — Range: 0 to 1244.829Length: — | Examples: 0.254, 20.146, 0.336, 47.594, 5.726 Values: — |
| VC_02 | float | No | 0 | — | — Range: -9998 to 1.82823Length: — | Examples: 0.49199, -9998.0, 0.4969, 1.12634, -9998.0 Values: — |
| QE_02 | float | No | 0 | — | — Range: 0 to 1377.556Length: — | Examples: 0.254, 20.146, 0.336, 47.594, 5.726 Values: — |
| VE_02 | float | No | 0 | — | — Range: -9998 to 1.82431Length: — | Examples: 0.49199, -9998.0, 0.4969, 1.12634, -9998.0 Values: — |
| QA_03 | float | No | 0 | — | — Range: 0 to 250.646Length: — | Examples: 0.127, 2.129, 0.187, 4.764, 0.643 Values: — |
| VA_03 | float | No | 0 | — | — Range: -9998 to 0.92252Length: — | Examples: 0.43546, -9998.0, 0.44649, 0.55809, -9998.0 Values: — |
| QC_03 | float | No | 0 | — | — Range: 0 to 1224.382Length: — | Examples: 0.127, 31.189, 0.187, 57.972, 12.423 Values: — |
| VC_03 | float | No | 0 | — | — Range: -9998 to 1.73999Length: — | Examples: 0.43546, -9998.0, 0.44649, 1.21666, -9998.0 Values: — |
| QE_03 | float | No | 0 | — | — Range: 0 to 2139.963Length: — | Examples: 0.127, 31.189, 0.187, 57.972, 12.423 Values: — |
| VE_03 | float | No | 0 | — | — Range: -9998 to 2.13742Length: — | Examples: 0.43546, -9998.0, 0.44649, 1.21666, -9998.0 Values: — |
| QA_04 | float | No | 0 | — | — Range: 0 to 3327.623Length: — | Examples: 2.143, 28.159, 2.287, 76.704, 7.655 Values: — |
| VA_04 | float | No | 0 | — | — Range: -9998 to 2.73224Length: — | Examples: 0.87815, -9998.0, 0.83032, 1.40045, -9998.0 Values: — |
| QC_04 | float | No | 0 | — | — Range: 0 to 3327.623Length: — | Examples: 2.143, 28.159, 2.287, 76.704, 7.655 Values: — |
| VC_04 | float | No | 0 | — | — Range: -9998 to 2.73224Length: — | Examples: 0.87815, -9998.0, 0.83032, 1.36225, -9998.0 Values: — |
| QE_04 | float | No | 0 | — | — Range: 0 to 10831.093Length: — | Examples: 2.143, 28.159, 2.287, 76.704, 7.655 Values: — |
| VE_04 | float | No | 0 | — | — Range: -9998 to 4.54967Length: — | Examples: 0.87815, -9998.0, 0.83032, 1.36225, -9998.0 Values: — |
| QA_05 | float | No | 0 | — | — Range: 0 to 11480.487Length: — | Examples: 8.044, 94.562, 8.661, 301.089, 28.19 Values: — |
| VA_05 | float | No | 0 | — | — Range: -9998 to 4.98715Length: — | Examples: 1.45846, -9998.0, 1.36689, 2.56572, -9998.0 Values: — |
| QC_05 | float | No | 0 | — | — Range: 0 to 11480.487Length: — | Examples: 8.044, 73.482, 8.661, 228.491, 22.455 Values: — |
| VC_05 | float | No | 0 | — | — Range: -9998 to 4.98715Length: — | Examples: 1.45846, -9998.0, 1.36689, 2.18989, -9998.0 Values: — |
| QE_05 | float | No | 0 | — | — Range: 0 to 13861.034Length: — | Examples: 8.044, 73.482, 8.661, 228.491, 22.455 Values: — |
| VE_05 | float | No | 0 | — | — Range: -9998 to 4.86411Length: — | Examples: 1.45846, -9998.0, 1.36689, 2.18989, -9998.0 Values: — |
| QA_06 | float | No | 0 | — | — Range: 0 to 9916.552Length: — | Examples: 4.825, 63.062, 5.482, 218.162, 20.723 Values: — |
| VA_06 | float | No | 0 | — | — Range: -9998 to 4.1421Length: — | Examples: 1.1851, -9998.0, 1.13866, 2.21078, -9998.0 Values: — |
| QC_06 | float | No | 0 | — | — Range: 0 to 9916.552Length: — | Examples: 4.825, 41.034, 5.482, 120.968, 15.565 Values: — |
| VC_06 | float | No | 0 | — | — Range: -9998 to 4.1421Length: — | Examples: 1.1851, -9998.0, 1.13866, 1.65067, -9998.0 Values: — |
| QE_06 | float | No | 0 | — | — Range: 0 to 5835.917Length: — | Examples: 4.825, 41.034, 5.482, 120.968, 15.565 Values: — |
| VE_06 | float | No | 0 | — | — Range: -9998 to 3.29517Length: — | Examples: 1.1851, -9998.0, 1.13866, 1.65067, -9998.0 Values: — |
| QA_07 | float | No | 0 | — | — Range: 0 to 5402.089Length: — | Examples: 2.597, 33.238, 2.936, 115.739, 10.915 Values: — |
| VA_07 | float | No | 0 | — | — Range: -9998 to 3.08797Length: — | Examples: 0.93935, -9998.0, 0.90435, 1.66707, -9998.0 Values: — |
| QC_07 | float | No | 0 | — | — Range: 0 to 5402.089Length: — | Examples: 2.597, 20.016, 2.936, 62.354, 7.259 Values: — |
| VC_07 | float | No | 0 | — | — Range: -9998 to 3.08797Length: — | Examples: 0.93935, -9998.0, 0.90435, 1.25249, -9998.0 Values: — |
| QE_07 | float | No | 0 | — | — Range: 0 to 3675.139Length: — | Examples: 2.597, 20.016, 2.936, 62.354, 7.259 Values: — |
| VE_07 | float | No | 0 | — | — Range: -9998 to 2.48783Length: — | Examples: 0.93935, -9998.0, 0.90435, 1.25249, -9998.0 Values: — |
| QA_08 | float | No | 0 | — | — Range: 0 to 3604.248Length: — | Examples: 1.44, 18.477, 1.614, 66.133, 5.986 Values: — |
| VA_08 | float | No | 0 | — | — Range: -9998 to 2.56293Length: — | Examples: 0.76972, -9998.0, 0.74214, 1.31776, -9998.0 Values: — |
| QC_08 | float | No | 0 | — | — Range: 0 to 3604.248Length: — | Examples: 1.44, 14.595, 1.614, 44.679, 5.429 Values: — |
| VC_08 | float | No | 0 | — | — Range: -9998 to 2.56293Length: — | Examples: 0.76972, -9998.0, 0.74214, 1.09934, -9998.0 Values: — |
| QE_08 | float | No | 0 | — | — Range: 0 to 2659.375Length: — | Examples: 1.44, 14.595, 1.614, 44.679, 5.429 Values: — |
| VE_08 | float | No | 0 | — | — Range: -9998 to 2.17053Length: — | Examples: 0.76972, -9998.0, 0.74214, 1.09934, -9998.0 Values: — |
| QA_09 | float | No | 0 | — | — Range: 0 to 4026.993Length: — | Examples: 1.654, 19.73, 2.354, 76.699, 7.807 Values: — |
| VA_09 | float | No | 0 | — | — Range: -9998 to 2.69941Length: — | Examples: 0.80494, -9998.0, 0.83838, 1.40042, -9998.0 Values: — |
| QC_09 | float | No | 0 | — | — Range: 0 to 4026.993Length: — | Examples: 2.124, 16.988, 2.856, 53.057, 7.806 Values: — |
| VC_09 | float | No | 0 | — | — Range: -9998 to 2.69941Length: — | Examples: 0.87546, -9998.0, 0.89567, 1.17492, -9998.0 Values: — |
| QE_09 | float | No | 0 | — | — Range: 0 to 2871.99Length: — | Examples: 2.124, 16.988, 2.856, 53.057, 7.806 Values: — |
| VE_09 | float | No | 0 | — | — Range: -9998 to 2.24327Length: — | Examples: 0.87546, -9998.0, 0.89567, 1.17492, -9998.0 Values: — |
| QA_10 | float | No | 0 | — | — Range: 0 to 4780.855Length: — | Examples: 2.558, 29.398, 3.139, 105.757, 10.352 Values: — |
| VA_10 | float | No | 0 | — | — Range: -9998 to 2.91251Length: — | Examples: 0.9343, -9998.0, 0.92589, 1.60353, -9998.0 Values: — |
| QC_10 | float | No | 0 | — | — Range: 0 to 4780.855Length: — | Examples: 2.558, 24.642, 3.139, 80.379, 9.398 Values: — |
| VC_10 | float | No | 0 | — | — Range: -9998 to 2.91251Length: — | Examples: 0.9343, -9998.0, 0.92589, 1.38877, -9998.0 Values: — |
| QE_10 | float | No | 0 | — | — Range: 0 to 4127.597Length: — | Examples: 2.558, 24.642, 3.139, 80.379, 9.398 Values: — |
| VE_10 | float | No | 0 | — | — Range: -9998 to 2.6688Length: — | Examples: 0.9343, -9998.0, 0.92589, 1.38877, -9998.0 Values: — |
| QA_11 | float | No | 0 | — | — Range: 0 to 3885.999Length: — | Examples: 2.255, 33.873, 2.761, 86.245, 9.514 Values: — |
| VA_11 | float | No | 0 | — | — Range: -9998 to 2.94064Length: — | Examples: 0.89377, -9998.0, 0.88522, 1.4706, -9998.0 Values: — |
| QC_11 | float | No | 0 | — | — Range: 0 to 3885.999Length: — | Examples: 2.255, 28.544, 2.761, 71.656, 8.173 Values: — |
| VC_11 | float | No | 0 | — | — Range: -9998 to 2.94064Length: — | Examples: 0.89377, -9998.0, 0.88522, 1.32484, -9998.0 Values: — |
| QE_11 | float | No | 0 | — | — Range: 0 to 4278.152Length: — | Examples: 2.255, 28.544, 2.761, 71.656, 8.173 Values: — |
| VE_11 | float | No | 0 | — | — Range: -9998 to 2.89311Length: — | Examples: 0.89377, -9998.0, 0.88522, 1.32484, -9998.0 Values: — |
| QA_12 | float | No | 0 | — | — Range: 0 to 1894.852Length: — | Examples: 1.097, 16.495, 1.345, 42.245, 4.657 Values: — |
| VA_12 | float | No | 0 | — | — Range: -9998 to 2.1059Length: — | Examples: 0.70766, -9998.0, 0.70211, 1.10399, -9998.0 Values: — |
| QC_12 | float | No | 0 | — | — Range: 0 to 1987.815Length: — | Examples: 1.097, 24.675, 1.345, 63.307, 6.95 Values: — |
| VC_12 | float | No | 0 | — | — Range: -9998 to 2.21979Length: — | Examples: 0.70766, -9998.0, 0.70211, 1.26013, -9998.0 Values: — |
| QE_12 | float | No | 0 | — | — Range: 0 to 1916.096Length: — | Examples: 1.097, 24.675, 1.345, 63.307, 6.95 Values: — |
| VE_12 | float | No | 0 | — | — Range: -9998 to 2.22178Length: — | Examples: 0.70766, -9998.0, 0.70211, 1.26013, -9998.0 Values: — |
| RPUID | string | No | 0 | — | — Range: —Length: 3 | Examples: 01a, 01a, 01a, 01a, 01a Values: , 01a |
| VPUID | string | No | 0 | — | — Range: —Length: 2 | Examples: 01, 01, 01, 01, 01 Values: 01 |
| Enabled | integer | No | 0 | — | — Range: 1 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| keep_gaz_string | string | Yes | 4,996 | — | — Range: —Length: 6 | Examples: 578099, 578099, 577042, 577042 Values: 577042, 578099 |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
