Schema
NHD / Waterbody - Small Scale (HI, PR, VI, Pacific Territories) / v1.0.0
Schema from waterbody-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: 26439642, 26481640, 30758884, 27813714, 26382009 Values: — |
| FDate | string | No | 0 | — | — Range: —Length: 10 | Examples: 1994-01-01, 1994-01-01, 2001-12-04, 2001-10-05, 1994-01-01 Values: — |
| Resolution | string | No | 0 | — | — Range: —Length: 4 | Examples: High, High, High, High, High Values: High |
| GNIS_ID | string | Yes | 4,928 | — | — Range: —Length: 7 | Examples: 360629, 359028, 359439, 361044, 363214 Values: — |
| GNIS_Name | string | Yes | 4,928 | — | — Range: —Length: 30 | Examples: Kauaʻula Reservoir, Hanakaʻōʻō Reservoir, Horner Reservoir, Keawanui Fishpond, Paʻuwela Reservoir Values: — |
| AreaSqKm | float | No | 0 | — | — Range: 0 to 19.58681757Length: — | Examples: 0.003, 0.001, 0.0, 0.007, 0.001 Values: — |
| Elevation | float | No | 0 | — | — Range: 0 to 4990Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| ReachCode | string | Yes | 1,067 | — | — Range: —Length: 14 | Examples: 21010004004856, 21010003003197, 21010006000295, 21010006000307, 20020000002160 Values: — |
| FTYPE | string | No | 0 | — | — Range: —Length: 10 | Examples: LakePond, LakePond, LakePond, LakePond, LakePond Values: LakePond, Playa, Reservoir, SwampMarsh |
| FCode | integer | No | 0 | — | — Range: 36100 to 46600Length: — | Examples: 39004, 39004, 39004, 39004, 39004 Values: — |
| ComID | integer | No | 0 | — | — Range: 800020529 to 800047052Length: — | Examples: 800043353, 800046788, 800021267, 800021003, 800043591 Values: — |
| OnOffNet | float | Yes | 682 | — | — Range: 0 to 1Length: — | Examples: 1.0, 0.0, 1.0, 0.0, 0.0 Values: — |
| PurpCode | string | Yes | 4,945 | — | — Range: —Length: 1 | Examples: 5, 5, 5, 5, 5 Values: 5 |
| PurpDesc | string | Yes | 4,945 | — | — Range: —Length: 25 | Examples: NHD Waterbody closed lake, NHD Waterbody closed lake, NHD Waterbody closed lake, NHD Waterbody closed lake, NHD Waterbody closed lake Values: NHD Waterbody closed lake |
| MeanDepth | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| LakeVolume | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| MaxDepth | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| MeanDUsed | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| MeanDCode | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| LakeArea | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| Shape_Leng | float | No | 0 | — | — Range: 10.811069733590298 to 70347.91852338734Length: — | Examples: 250.86990618905472, 108.80494960911314, 60.059279546347774, 366.75881118457613, 112.78786741089957 Values: — |
| Shape_Area | float | No | 0 | — | — Range: 1.428739515690774 to 21879840.136454474Length: — | Examples: 2893.5726021141436, 805.2543621058483, 253.4238476130285, 8582.53614585341, 876.2060422485968 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
