Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Geospatial Table
Short Name: Geospatial Table
Status: Completed
Abstract:

The Geospatial table provides location references for information recorded in the Bibliography and Assessment tables. It is joned to both the Bibliographic and Assessment Tables by the Waterbody Number (UniqueID) field. | Description Source: Fields within this entity (Geospatial Table)are described as a series of attributes in the detailed description.

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
State(s) VARCHAR State(s) - locations which fully or partially contain the waterbody or watershed identified by a record in the Geospatial Table, using standard abbreviation codes. | Description Source: Standard state abbreviation codes (e.g. ME, NH, MA, etc.)
100
Zone VARCHAR Refers to where in the land-to-sea continuum the polygon is, in one of five zones, from terrestrial watersheds to U.S. Federal waters of the Exclusive Economic Zone (EEZ) on the Continental Shelf. | Description Source: The five zones were delineated by the Project Manager for the purposes of this project, and are defined in Tech. Memo. 103 as: Estuarine Estuarine Drainage Area (EDA) Coastal Drainage Area (CDA) Marine-State Marine-Federal
100
Region VARCHAR Refers to where on the Atlantic Coast continuum the polygon is, in one of four regions. | Description Source: The four regions were adopted by the Project Manager and ACFHP Steering Committee, and are defined in Tech. Memo. 103 as: North Atlantic, Mid-Atlantic, South Atlantic, and South Florida.
100
Waterbody Number VARCHAR Recorded as a unique number (UniqueID), for each waterbody or watershed identified within the Geospatial Table. | Description Source: Each waterbody or watershed is represented by a unique number (UniqueID). This field enables a join between the Geospatial and Bibliographic Tables via a many-to-many relationship, and a one-to-many relationship with the Assessment Table.
100
Lon NUMBER Longitude of centroid of polygon, in decimal degrees, geographic projection. | Description Source: Enables each polygon (waterbody or watershed) to be represented as a single point for display purposes.
100
Lat NUMBER Latitude of centroid of polygon, in decimal degrees, geographic projection. | Description Source: Enables each polygon (waterbody or watershed) to be represented as a single point for display purposes.

Attribute Details

State(s)

CC ID: 527997
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

State(s) - locations which fully or partially contain the waterbody or watershed identified by a record in the Geospatial Table, using standard abbreviation codes. | Description Source: Standard state abbreviation codes (e.g. ME, NH, MA, etc.)

Allowed Values: Postal code state name abbreviations: Values are recorded as standard state postal abbreviation codes, with some exceptions. Federal marine waters are represented as US, and New Brunswick (Canada) is represented as NB.

Zone

CC ID: 527998
Seq. Order: 2
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Refers to where in the land-to-sea continuum the polygon is, in one of five zones, from terrestrial watersheds to U.S. Federal waters of the Exclusive Economic Zone (EEZ) on the Continental Shelf. | Description Source: The five zones were delineated by the Project Manager for the purposes of this project, and are defined in Tech. Memo. 103 as: Estuarine Estuarine Drainage Area (EDA) Coastal Drainage Area (CDA) Marine-State Marine-Federal

Allowed Values: Estuarine: A coastal waterbody which is semi-enclosed, and in which salinity can vary between fresh and marine, typically extending from head-of-tide on the landward side, to the outer mouth of the waterbody on the seaward side. For the purposes of this project, the set 78 estuarine waterbodies is taken from NOAA's Coastal Assessment Framework. | Estuarine Drainage Area (EDA): An Estuarine Drainage Area (EDA) is that component of an estuary?s entire watershed that empties directly into the estuary. EDAs may be composed of all or part of a single or several USGS hydrologic units and include all or part of the USGS cataloging unit (HUC-8) containing the most upstream extent of tidal influence (head-of-tide). For the purposes of this project, the set 74 EDAs is taken from NOAA's Coastal Assessment Framework. | Coastal Drainage Area (CDA): A Coastal Drainage Area (CDA) is defined as that component of an entire watershed that meets the following three criteria: 1) it is not part of any EDA; 2) it drains directly into an ocean, an estuary, or the Great Lakes; and 3) it is composed only of the downstream-most HUC in which the head-of-tide is found. In other words, CDAs are land areas that do not drain to a particular estuary, and in some cases are represented as multiple polygons within a state. For the purposes of this project, the set 19 CDAs is taken from NOAA's Coastal Assessment Framework. | Marine-State: Nearshore marine waters, within individual states' defined territorial sea limit of 3 nautical miles. For the purposes of this project, the set of 15 Marine-State waters polygons are derived from boundary layers in NOAA's Marine Cadastre. | Marine-Federal: Offshore marine waters, extending from state waters at 3 nautical miles (nmi), seaward to the 200 nmi limit of the U.S. Exclusive Economic Zone (EEZ). Regional breaks were created at Cape Cod, Cape Hatteras, and Cape Canaveral, creating four regions: North Atlantic, Mid-Atlantic, South Atlantic, and South Florida, consistent with generally accepted biogeographic classifications For the purposes of this project, the set of 4 Marine-Federal waters polygons are derived from boundary layers in NOAA's Marine Cadastre, and subdivided based on biogeographic regional breaks. |

Region

CC ID: 527999
Seq. Order: 3
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Refers to where on the Atlantic Coast continuum the polygon is, in one of four regions. | Description Source: The four regions were adopted by the Project Manager and ACFHP Steering Committee, and are defined in Tech. Memo. 103 as: North Atlantic, Mid-Atlantic, South Atlantic, and South Florida.

Allowed Values: North Atlantic: The North Atlantic region extends from Passamaquoddy Bay, on the border of Maine and New Brunswick, southwestward to Cape Cod, Massachusetts. For the purposes of this project, it includes 19 estuarine waterbodies, three marine-state waterbodies, and one marine-federal waterbody. | Mid-Atlantic: The Mid-Atlantic region extends from Cape Cod, Massachusetts, southwestward to Cape Hatteras, North Carolina. For the purposes of this project, it includes 34 estuarine waterbodies, 8 marine-state waterbodies, and one marine-federal waterbody. | South Atlantic: The South Atlantic region extends from Cape Hatteras, North Carolina, southwestward to Cape Canaveral, Florida. For the purposes of this project, it includes 22 estuarine waterbodies, 4 marine-state waterbodies, and one marine-federal waterbody. | South Florida: The South Florida region extends from Cape Canaveral, Florida, southward and around the Florida Keys to the Dry Tortugas. For the purposes of this project, it includes two estuarine waterbodies, one marine-state waterbody, and one marine-federal waterbody. |

Waterbody Number

CC ID: 528000
Seq. Order: 4
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Recorded as a unique number (UniqueID), for each waterbody or watershed identified within the Geospatial Table. | Description Source: Each waterbody or watershed is represented by a unique number (UniqueID). This field enables a join between the Geospatial and Bibliographic Tables via a many-to-many relationship, and a one-to-many relationship with the Assessment Table.

Allowed Values: Waterbody Number (UniqueID): Values are recorded as a singular Waterbody Number(UniqueID), joined to the same field within the Bibligraphic and Assessment Tables. Each row of information in the Geospatial Table refers to only one waterbody.

Lon

CC ID: 528001
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude of centroid of polygon, in decimal degrees, geographic projection. | Description Source: Enables each polygon (waterbody or watershed) to be represented as a single point for display purposes.

Unit of Measure: Decimal degrees, geographic projection
Allowed Values: -83 - -67

Lat

CC ID: 528002
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude of centroid of polygon, in decimal degrees, geographic projection. | Description Source: Enables each polygon (waterbody or watershed) to be represented as a single point for display purposes.

Unit of Measure: Decimal degrees, geographic projection
Allowed Values: 46 - 24

Catalog Details

Catalog Item ID: 40913
GUID: gov.noaa.nmfs.inport:40913
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 10:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-04-17
Owner Org: NCCOS
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-04-17
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-04-17