Geospatial Table
Entity (ENT) | National Centers for Coastal Ocean Science (NCCOS)GUID: gov.noaa.nmfs.inport:40913 | Updated: August 9, 2022 | Published / External
Data Attributes
Attribute Summary
|
|
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)
| 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
| 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
| 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
| 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
| 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
| 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 |