Schema
NHD / Area - Small Scale (HI, PR, VI, Pacific Territories) / v1.0.0
Schema from area-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 530Length: — | Examples: 409, 438, 486, 299, 509 Values: — |
| Permanent_ | string | No | 0 | — | — Range: —Length: 38 | Examples: 120004373, 32649213, {153D56E9-CED3-4A90-B139-BB7F87A59816}, 26480712, {8DC7E448-6404-4793-8673-2B699E9CAAB0} Values: — |
| FDate | string | No | 0 | — | — Range: —Length: 10 | Examples: 2004-03-16, 2002-01-30, 2014-12-23, 1994-01-01, 2014-09-09 Values: — |
| Resolution | string | No | 0 | — | — Range: —Length: 4 | Examples: High, High, High, High, High Values: High |
| GNIS_ID | string | Yes | 476 | — | — Range: —Length: 7 | Examples: 1389466, 1389738, 1389688, 1389680, 247074 Values: — |
| GNIS_Name | string | Yes | 476 | — | — Range: —Length: 17 | Examples: Ajayan Bay, Inarajan Bay, Gayloup Cove, Fouha Bay, Pacific Ocean Values: — |
| AreaSqKm | float | No | 0 | — | — Range: 0 to 4951.46345008Length: — | Examples: 0.039, 0.037, 1.81599015, 0.092, 932.60854666 Values: — |
| Elevation | integer | No | 0 | — | — Range: 0 to 0Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| FTYPE | string | No | 0 | — | — Range: —Length: 19 | Examples: Foreshore, Foreshore, BayInlet, Foreshore, SeaOcean Values: BayInlet, CanalDitch, DamWeir, Foreshore, SeaOcean, Spillway, StreamRiver, Water IntakeOutflow |
| FCode | integer | No | 0 | — | — Range: 31200 to 48500Length: — | Examples: 36400, 36400, 31200, 36400, 44500 Values: — |
| ComID | integer | No | 0 | — | — Range: 800020364 to 810014255Length: — | Examples: 800020462, 800020491, 810007752, 800042943, 810007775 Values: — |
| OnOffNet | float | Yes | 349 | — | — Range: 0 to 1Length: — | Examples: 1.0, 1.0, 1.0, 1.0, 1.0 Values: — |
| PurpCode | string | Yes | 530 | — | — Range: —Length: — | Examples: — Values: — |
| PurpDesc | string | Yes | 530 | — | — Range: —Length: — | Examples: — Values: — |
| GNIS_ID_fi | string | Yes | 511 | — | — Range: —Length: 7 | Examples: 247074, 247074, 247074, 1389502, 247074 Values: 1389502, 2071665, 247074 |
| Shape_Leng | float | No | 0 | — | — Range: 12.88054352318443 to 1962375.364152988Length: — | Examples: 2187.008368149472, 1942.7086762591694, 6570.811481578504, 1614.3503261614328, 419455.5536803163 Values: — |
| Shape_Area | float | No | 0 | — | — Range: 0.096949331527783 to 5516665406.165613Length: — | Examples: 44729.5063858692, 42414.457447501576, 1931720.6971230109, 101973.2163360445, 991830747.1717013 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 530Length: — | Examples: 409, 438, 486, 299, 509 Values: — |
