Schema
NHD / Waterbody - Small Scale / v1.0.0
Schema from waterbody-small-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 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| FDATE | string | No | 0 | — | — Range: —Length: 10 | Examples: 2004-03-16, 1999-07-04, 1999-05-27, 1999-07-04, 1999-06-22 Values: — |
| GNIS_ID | string | Yes | 2,751 | — | — Range: —Length: 7 | Examples: 578632, 564187, 574111, 577372, 577215 Values: — |
| GNIS_NAME | string | Yes | 2,751 | — | — Range: —Length: 33 | Examples: Withey Bog, Cold Brook Lake, Redmond Pond, Trueworthy Pond, Tory Hill Pond Values: — |
| AREASQKM | float | No | 0 | — | — Range: 0.002 to 301.715Length: — | Examples: 6.443, 0.285, 0.174, 0.134, 0.742 Values: — |
| ELEVATION | float | No | 0 | — | — Range: 0 to 710Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| REACHCODE | string | Yes | 1,629 | — | — Range: —Length: 14 | Examples: 01030003002520, 01030003002264, 01020005001987, 01030001001181, 01040001000726 Values: — |
| FCODE | integer | No | 0 | — | — Range: 39001 to 46600Length: — | Examples: 39004, 39004, 46600, 39004, 46600 Values: — |
| Shape_Leng | float | No | 0 | — | — Range: 304.42020120649033 to 555520.3353205952Length: — | Examples: 101216.3424351789, 5275.749878959588, 2778.8639494236822, 2236.394904054721, 6023.905064052612 Values: — |
| Shape_Area | float | No | 0 | — | — Range: 4148.967832565006 to 617852630.021582Length: — | Examples: 14002010.33510423, 568253.7105984382, 348958.7894686645, 261666.62661573818, 1585861.029287387 Values: — |
| COMID | integer | No | 0 | — | — Range: 487 to 166421080Length: — | Examples: 120052046, 3319864, 5195400, 5202046, 4288843 Values: — |
| RESOLUTION | string | No | 0 | — | — Range: —Length: 6 | Examples: Medium, Medium, Medium, Medium, Medium Values: Medium |
| FTYPE | string | No | 0 | — | — Range: —Length: 10 | Examples: LakePond, LakePond, SwampMarsh, LakePond, SwampMarsh Values: LakePond, Reservoir, SwampMarsh |
| ONOFFNET | float | Yes | 1,622 | — | — Range: 0 to 1Length: — | Examples: 0.0, 1.0, 0.0, 1.0, 0.0 Values: — |
| PurpCode | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| PurpDesc | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
