Schema
NHD / Line - Large Scale / v1.0.0
Schema from line-large-scale--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 5993Length: — | Examples: 488, 4630, 5803, 5479, 737 Values: — |
| PERMANENT_ | string | No | 0 | — | — Range: —Length: 9 | Examples: 41378279, 88571329, 51502839, 68371367, 44698521 Values: — |
| FDATE | string | No | 0 | — | — Range: —Length: 10 | Examples: 2002-05-17, 2003-06-25, 2016-12-19, 2003-01-29, 2002-07-09 Values: — |
| RESOLUTION | integer | No | 0 | — | — Range: 2 to 2Length: — | Examples: 2, 2, 2, 2, 2 Values: — |
| GNIS_ID | string | Yes | 4,608 | — | — Range: —Length: 8 | Examples: 01771479, 00490915, 01307202, 00130864, 00198782 Values: — |
| GNIS_NAME | string | Yes | 4,608 | — | — Range: —Length: 49 | Examples: Upper Bolton Lake Dam, Dix Dam, Browns Lake Dam, Auburn Farm Pond Storage Dam, Evergreen Dam Values: — |
| LENGTHKM | float | No | 0 | — | — Range: 0 to 10.263Length: — | Examples: 0.027, 0.027, 0.04990643, 0.011, 0.014 Values: — |
| FTYPE | integer | No | 0 | — | — Range: 318 to 478Length: — | Examples: 343, 343, 362, 343, 343 Values: — |
| FCODE | integer | No | 0 | — | — Range: 31800 to 47800Length: — | Examples: 34306, 34306, 36200, 34306, 34306 Values: — |
| VISIBILITY | integer | No | 0 | — | — Range: 0 to 5000000Length: — | Examples: 5000000, 100000, 0, 5000000, 100000 Values: — |
| SHAPE_Leng | float | No | 0 | — | — Range: 0.268034547567368 to 12039.857274203669Length: — | Examples: 34.68161636330794, 33.27349395638998, 67.96777734457454, 13.04693745504468, 17.63734966603482 Values: — |
| GLOBALID | string | No | 0 | — | — Range: —Length: 38 | Examples: {F87806EE-4CA7-11E1-BCF4-0021280458E6}, {FEEA52B9-4CA7-11E1-BCF4-0021280458E6}, {04346208-4CA8-11E1-BCF4-0021280458E6}, {04105112-4CA8-11E1-BCF4-0021280458E6}, {F892B61F-4CA7-11E1-BCF4-0021280458E6} Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5993Length: — | Examples: 488, 4630, 5803, 5479, 737 Values: — |
