Item Identification

Title: jbo95spi.dbf
Short Name: jbo95spi.dbf
Status: Completed
Abstract:

Shapefile Attribute Table | Description Source: None

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Station NUMBER Unique number assigned to sample sites | Description Source: Unknown
100
Navqaqc VARCHAR Quality control codes for navigation records (decimal degrees) | Description Source: Unknown
100
Datatype VARCHAR Code describing sample types collected at each station | Description Source: Unknown
100
Location VARCHAR Name of bay or region where station is located | Description Source: Unknown
100
Latitude NUMBER Latitude in decimal degrees | Description Source: Unknown
100
Longitude NUMBER Longitude in decimal degrees | Description Source: Unknown
100
Latutm NUMBER Latitude in UTM Zone 18 coordinates | Description Source: Unknown
100
Longutm NUMBER Longitude in UTM Zone 18 coordinates | Description Source: Unknown
100
Slides NUMBER Number of slides used in analysis | Description Source: Unknown
100
Sediment Unknown Abbreviated description of sediment texture | Description Source: Unknown
100
Texture Unknown Folk scale description of Sediment abbreviations | Description Source: Unknown
100
Shellhash VARCHAR Presence of shell hash and abbreviated descriptions of live shellfish | Description Source: Unknown
100
Spisb Unknown Description of live shellfish as indicated in the Shellhash field | Description Source: Unknown
100
Pvshellbed Unknown Types of live shellbed identified in plan-view images (ND=No data) | Description Source: Unknown
100
Carpet Unknown Presence of "carpet-like" layer of shell hash in Plan-view images (ND=No data) | Description Source: Unknown
100
Merno Unknown Abundance of Mercenaria mercenaria based on benthic grab data | Description Source: Unknown
100
Myano Unknown Abundance of Mya arenaria based on benthic grab data | Description Source: Unknown
100
Spisno Unknown Abundance of Spisula solidissima based on benthic grab data | Description Source: Unknown
100
Mytno Unknown Abundance of Mytilus edulis based on benthic grab data | Description Source: Unknown
100
Sedagree VARCHAR Ranked agreement between slides for both Sediment and Shellhash fields | Description Source: Unknown
100
Interface VARCHAR Features at sediment surface | Description Source: Unknown
100
Bedforms VARCHAR Presence of bedforms (sediment ripples) based on Interface field | Description Source: Unknown
100
Pvbedforms Unknown Presence of bedforms at sediment surface in plan-view images (ND=No data) | Description Source: Unknown
100
Pvslides NUMBER Number of plan-view images used to characterize station (2 = composite information represented) | Description Source: Unknown
100
Ampelisca Unknown Descriptions of relative numbers of Ampelisca abdita present in SPI images | Description Source: Unknown
100
Ampno Unknown Abundance of Ampelisca abdita at each station based on benthic grab data | Description Source: Unknown
100
Other Unknown Description of infauna present in images | Description Source: Unknown
100
Algaehyd Unknown Presence of algae or hydroids in epifaunal community at sediment surface | Description Source: Unknown
100
Otherepi Unknown List of epifauna (excluding algae and hydroids) indicated in Epifauna field | Description Source: Unknown
100
Epifauna VARCHAR Abbreviated description of epifauna present in SPI images | Description Source: Unknown
100
Totalinf Unknown Total species abundance from benthic grab data | Description Source: Unknown
100
Habagree VARCHAR Agreement rank between multiple images from individual stations based on Ampelisca, Epifauna and Other fields | Description Source: Unknown
100
Burrows NUMBER Number of infaunal burrows observed in image | Description Source: Unknown
100
Critters NUMBER Number of infaunal organisms observed | Description Source: Unknown
100
Voids NUMBER Number of voids seen in image | Description Source: Unknown
100
Vtype VARCHAR Types of voids present in images | Description Source: Unknown
100
Stage VARCHAR Community successional stage | Description Source: Rhoads, D. and J. Germano (1982) "Characterization of organism-sediment relations using sediment profile imaging: an efficient method of remote ecological monitoring of the seafloor (Remots TM System)". Marine Ecology Progress Series 8:115-128.
100
Stageagree VARCHAR Agreement between slides for community successional stage | Description Source: Unknown
100
Rpd NUMBER Depth of the apparent color Redox Potential Discontinuity (RPD) in centimeters based on computer analysis | Description Source: Unknown
100
Rpdcode VARCHAR Code describing RPD value | Description Source: Unknown
100
Pen NUMBER Depth in centimeters of camera penetration based on computer analysis | Description Source: Unknown
100
Pencode VARCHAR Code describing Pen value | Description Source: Unknown
100
Mixpa VARCHAR Ranked scale identifying stations having shellfish, but shellfish are too few in number to warrant a classification change | Description Source: Unknown
100
Delta VARCHAR Explanation of changes to habitat classes as a result of merging the SPI data with the benthic grab data (from spiHAB to mixHAB fields) | Description Source: Unknown
100
Mixhab VARCHAR Revised habitat classes based on SPI data and benthic grab data | Description Source: Unknown
100
Spihab VARCHAR Habitat classes based on SPI data only | Description Source: Unknown

Attribute Details

Station

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

Unique number assigned to sample sites | Description Source: Unknown

Allowed Values: 1 - 253

Navqaqc

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

Quality control codes for navigation records (decimal degrees) | Description Source: Unknown

Allowed Values: 1: directly measured at station | 9: target station coordinates used as actual station coordinates |

Datatype

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

Code describing sample types collected at each station | Description Source: Unknown

Allowed Values: 1: SPI only | 2: SPI and benthic grab | 3: SPI, benthic grab and sediment grab | 5: SPI and sediment grab |

Location

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

Name of bay or region where station is located | Description Source: Unknown

Allowed Values: Atlantic Basin: Atlantic Basin, Upper Bay, NY | Bowery Bay: Bowery Bay, NY | Bush Terminals: Bush Terminals, Upper Bay, NY | Dead Horse Bay: Dead Horse Bay, NY | Flushing Bay: Flushing Bay, NY | Jamaica Bay: Jamaica Bay, NY | Newark Bay: Newark Bay, NY | Upper Bay: Upper Bay, NY |

Latitude

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

Latitude in decimal degrees | Description Source: Unknown

Allowed Values: 40.58250 - 40.78600

Longitude

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

Longitude in decimal degrees | Description Source: Unknown

Allowed Values: -74.14633 - -73.74700

Latutm

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

Latitude in UTM Zone 18 coordinates | Description Source: Unknown

Allowed Values: 4492997.02752 - 4515622.40354

Longutm

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

Longitude in UTM Zone 18 coordinates | Description Source: Unknown

Allowed Values: 572163.20829 - 605953.64213

Slides

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

Number of slides used in analysis | Description Source: Unknown

Allowed Values: 1 - 3

Sediment

CC ID: 660042
Seq. Order: 10
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abbreviated description of sediment texture | Description Source: Unknown

Allowed Values: Character Field

Texture

CC ID: 660043
Seq. Order: 11
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Folk scale description of Sediment abbreviations | Description Source: Unknown

Allowed Values: Character Field

Shellhash

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

Presence of shell hash and abbreviated descriptions of live shellfish | Description Source: Unknown

Allowed Values: cb: clam bed | mb: mussel bed | mbob: mussel bed and oyster bed | ob: oyster bed | sh: shell hash | z: none |

Spisb

CC ID: 660045
Seq. Order: 13
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Description of live shellfish as indicated in the Shellhash field | Description Source: Unknown

Allowed Values: Character Field

Pvshellbed

CC ID: 660046
Seq. Order: 14
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Types of live shellbed identified in plan-view images (ND=No data) | Description Source: Unknown

Allowed Values: Character Field

Carpet

CC ID: 660047
Seq. Order: 15
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Presence of "carpet-like" layer of shell hash in Plan-view images (ND=No data) | Description Source: Unknown

Allowed Values: Character Field

Merno

CC ID: 660048
Seq. Order: 16
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abundance of Mercenaria mercenaria based on benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Myano

CC ID: 660049
Seq. Order: 17
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abundance of Mya arenaria based on benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Spisno

CC ID: 660050
Seq. Order: 18
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abundance of Spisula solidissima based on benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Mytno

CC ID: 660051
Seq. Order: 19
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abundance of Mytilus edulis based on benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Sedagree

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

Ranked agreement between slides for both Sediment and Shellhash fields | Description Source: Unknown

Allowed Values: -2: no agreement | 0: only one slide analyzed | 1: some agreement | 2: strong agreement |

Interface

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

Features at sediment surface | Description Source: Unknown

Allowed Values: b: bedforms | b;fp: bedforms; fecal pellets | b;m: bedforms; mounds | bm: bacteria mat | bm;d: bacteria mat; debris | bm;dt;m;p: bacteria mat; detritus; mounds; pits | bm;e: bacteria mat; even surface | bm;m: bacteria mat; mounds | bm;m;p: bacteria mat; mounds; pits | c;m: clasts; mounds | d: debris | d;m;p: debris; mounds; pits | d;p: debris; pits | e: even surface | e;m: even surface; mounds | e;m;p: even surface; mounds; pits | e;p: even surface; pits | m: mounds | m;p: mounds; pits | p: pits | sh: shell hash | sh;b: shell hash; bedforms | sh;b;dt: shell hash; bedforms; detritus | sh;e: shell hash; even surface | sh;m: shell hash; mounds | sh;m;p: shell hash; mounds; pits | sh;p: shell hash; pits | z: none |

Bedforms

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

Presence of bedforms (sediment ripples) based on Interface field | Description Source: Unknown

Allowed Values: no: Bedforms absent | No Data: Interface not visible in image | yes: Bedforms present |

Pvbedforms

CC ID: 660055
Seq. Order: 23
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Presence of bedforms at sediment surface in plan-view images (ND=No data) | Description Source: Unknown

Allowed Values: Character Field

Pvslides

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

Number of plan-view images used to characterize station (2 = composite information represented) | Description Source: Unknown

Allowed Values: 0 - 2

Ampelisca

CC ID: 660057
Seq. Order: 25
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Descriptions of relative numbers of Ampelisca abdita present in SPI images | Description Source: Unknown

Allowed Values: Character Field

Ampno

CC ID: 660058
Seq. Order: 26
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Abundance of Ampelisca abdita at each station based on benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Other

CC ID: 660059
Seq. Order: 27
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Description of infauna present in images | Description Source: Unknown

Allowed Values: Character Field

Algaehyd

CC ID: 660060
Seq. Order: 28
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Presence of algae or hydroids in epifaunal community at sediment surface | Description Source: Unknown

Allowed Values: Character Field

Otherepi

CC ID: 660061
Seq. Order: 29
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

List of epifauna (excluding algae and hydroids) indicated in Epifauna field | Description Source: Unknown

Allowed Values: Character Field

Epifauna

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

Abbreviated description of epifauna present in SPI images | Description Source: Unknown

Allowed Values: al: algae | alhc: algae, hermit crab | bc: blue crab | cr: Crepidula spp. | cs: Crangon shrimp | d: detritus | hy: hydroids | hysn: hydroids; snail | sn: snail | snms: snail, mysid shrimp | snmscs: snail, mysid shrimp, Crangon shrimp | snps: snail, Paleomonetes shrimp | z: none |

Totalinf

CC ID: 660063
Seq. Order: 31
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Total species abundance from benthic grab data | Description Source: Unknown

Allowed Values: Character Field

Habagree

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

Agreement rank between multiple images from individual stations based on Ampelisca, Epifauna and Other fields | Description Source: Unknown

Allowed Values: -2: no agreement | 0: only one image analyzed | 1: some agreement | 2: strong agreement |

Burrows

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

Number of infaunal burrows observed in image | Description Source: Unknown

Allowed Values: 0 - 99 (indicates No Data due to poor camera penetration or placement)

Critters

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

Number of infaunal organisms observed | Description Source: Unknown

Allowed Values: 0 - 99 (indicates No Data due to poor camera penetration or placement)

Voids

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

Number of voids seen in image | Description Source: Unknown

Allowed Values: 0 - 99 (indicates No Data due to poor camera penetration or placement)

Vtype

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

Types of voids present in images | Description Source: Unknown

Allowed Values: an: anoxic | an;ga: anoxic; gas | ga: gas | ox: oxic | z: none |

Stage

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

Community successional stage | Description Source: Rhoads, D. and J. Germano (1982) "Characterization of organism-sediment relations using sediment profile imaging: an efficient method of remote ecological monitoring of the seafloor (Remots TM System)". Marine Ecology Progress Series 8:115-128.

Allowed Values: 0: lifeless | 1: OSI Stage 1 (surface-feeding pioneering species) | 12: Components of OSI Stages 1 and 2 (pioneering to intermediate species) | 2: OSI Stage 2 (shallow-dwelling bivalves and tubicolous amphipods) | 23: Components of OSI Stages 2 and 3 (intermediate to equilibrium species) | 3: OSI Stage 3 (infaunal deposit-feeders, especially 'head-down' feeders) | 9: not measurable |

Stageagree

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

Agreement between slides for community successional stage | Description Source: Unknown

Allowed Values: -2: no agreement | 0: only one slide analyzed | 1: some agreement | 2: strong agreement |

Rpd

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

Depth of the apparent color Redox Potential Discontinuity (RPD) in centimeters based on computer analysis | Description Source: Unknown

Allowed Values: 0 - 99

Rpdcode

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

Code describing RPD value | Description Source: Unknown

Allowed Values: 0: no computer analysis | 1: calculated from one image | 2: not measurable due to poor or over-penetration | 3: average of two images |

Pen

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

Depth in centimeters of camera penetration based on computer analysis | Description Source: Unknown

Allowed Values: 0 - 99

Pencode

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

Code describing Pen value | Description Source: Unknown

Allowed Values: 0: no computer analysis | 1: calculated from 1 image | 2: not measurable | 3: average of 2 images |

Mixpa

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

Ranked scale identifying stations having shellfish, but shellfish are too few in number to warrant a classification change | Description Source: Unknown

Allowed Values: 0: No shellfish | 1: Mercenaria mercenaria present | ND: No grab data available to evaluate |

Delta

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

Explanation of changes to habitat classes as a result of merging the SPI data with the benthic grab data (from spiHAB to mixHAB fields) | Description Source: Unknown

Allowed Values: 0: No change to habitat class | 1: Habitat class changed due to significant presence (greater than 3) of Mercenaria mercenaria | ND: No grab data available to evaluate |

Mixhab

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

Revised habitat classes based on SPI data and benthic grab data | Description Source: Unknown

Allowed Values: Amp(fine): Ampelisca mat on fine sediments | Amp(sand): Ampelisca mat on sandy sediments | Amp(sifs, sims): Ampelisca mat on silty sand sediments | Azoic: Silty bottom habitat with no evidence of biological activity | Bacteria: Silty bottom habitat with surface bacteria mat | SandBed(critters): High energy sandy habitat with infauna | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(hash): High energy sandy habitat with shell hash | SandNoBed(critters): Low energy sandy habitat with infauna | SandNoBed(epifauna): Low energy sandy habitat with epifauna | SandNoBed(hash): Low energy sandy habitat with shell hash | SB(clam): Live clam beds (Hard clams, Softshell clams or Surf clams) | SB(mussel): Live mussel beds (Mytilus edulis) | SB(oyster): Live oyster beds (Crassostrea virginica) | Silt(critters): Silty bottom habitat with infauna | Silt(gas): Silty bottom habitat with gas voids | Silt(pendeep): Silty bottom habitat with very soft sediments (greater than 18 cm) |

Spihab

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

Habitat classes based on SPI data only | Description Source: Unknown

Allowed Values: Amp(fine): Ampelisca mat on fine sediments | Amp(sand): Ampelisca mat on sandy sediments | Amp(sifs, sims): Ampelisca mat on silty sand sediments | Azoic: Silty bottom habitat with no evidence of biological activity | Bacteria: Silty bottom habitat with surface bacteria mat | SandBed(critters): High energy sandy habitat with obvious infauna | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(hash): High energy sandy habitat with shell hash | SandNoBed(critters): Low energy sandy habitat with infauna | SandNoBed(epifauna): Low energy sandy habitat with epifauna | SandNoBed(hash): Low energy sandy habitat with shell hash | SB(clam): Live clam beds (Hard clams, Softshell clams or Surf clams) | SB(mussel): Live mussel beds (Mytilus edulis) | SB(oyster): Live oyster beds (Crassostrea virginica) | Silt(critters): Silty bottom habitat with infauna | Silt(gas): Silty bottom habitat with gas voids | Silt(pendeep): Silty bottom habitats with very soft sediments (greater than 18 cm) |

Catalog Details

Catalog Item ID: 49341
Metadata Record Created By: Anne Ball
Metadata Record Created: 2017-11-15 08:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-11-16
Owner Org: OCM
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-11-17