An official website of the United States government
Here's how you know
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
waterbody (spatial table)- Waterbody is a polygon spatial table that contains polygonal representations of water features that uses the waterbodyfeaturetype domain.
Name (Alias)
Definition
Type
Allow Nulls
Length
Domain
Default Values
Comments
id3dhp
Unique identifier for 3DHP features.
Text
Yes
7
-
-
This is a base-36 7-digit alphanumeric unique identifier that is not persistent.
Applied to waterbody features in this case.
featuredate
Date the feature was loaded into the 3DHP core database.
Date
Yes
-
-
-
-
mainstemid
A cross-dataset identifier for all flowlines that represent
the headwater to outlet path of a river.
Text
Yes
200
-
A mainstem is equivalent to a feature with the same levelpathid in NHDPlus HR.
The text field will be a <geoconnex.us>*.
gnisid
A permanent, unique number assigned by the Geographic
Names Information System (GNIS)** to a geographic feature
name for the sole purpose of uniquely identifying that name.
Long Integer
Yes
-
-
-
gnisid = "null" if no name is associated with the feature. The gnisid is conflated
from points and assigned to features. The most recent name, and any historic
names, can be retrieved from the GNIS data base using the gnisid.
featuretype
Feature type description.
Short Integer
Yes
-
waterbodyfeaturetype
-
-
featuretypelabel
The name of the feature type.
Text
Yes
50
-
-
The featuretype label is based on the coded value description in the featuretype field.
Allows label display in non-ESRI datasets.
areasqkm
Area of feature in square kilometers based on regional spatial
reference systems.
Double
Yes
-
-
-
Computed in projections based on specific locations, please see the Spatial Reference
System Section of this specification for more information.