Item Identification

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

DBF 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
Skey NUMBER Unique identifier for station | Description Source: Unknown
100
Station NUMBER Unique number assigned to sample sites | Description Source: Unknown
100
Dupe VARCHAR Indicates visits to individual stations | Description Source: Unknown
100
Datatype VARCHAR Indicates type of data collected at station | 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 analyzed for station | 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
Shell_hash VARCHAR Presence of shell hash and abbreviated descriptions of live shellfish | Description Source: Unknown
100
Merno Unknown Abundance of Mercenaria mercenaria in benthic grabs (ND = no grab data) | Description Source: Unknown
100
Myano Unknown Abundance of Mya arenaria in benthic grabs (ND = no grab data) | Description Source: Unknown
100
Spisno Unknown Abundance of Spisula solidissima in benthic grabs (ND = nograb data) | Description Source: Unknown
100
Mytno Unknown Abundance of Mytilus edulis in benthic grabs (ND = no grab data) | Description Source: Unknown
100
Sed_agree VARCHAR Ranked agreement between slides for both Sediment and ShellHash categories | Description Source: Unknown
100
Interface VARCHAR Description (abbr) for features seen at sediment surface | Description Source: Unknown
100
Bedforms VARCHAR Presence of bedforms (sediment ripples) based on Interface field | Description Source: Unknown
100
Ampelisca Unknown Description of relative numbers of Ampelisca abdita | Description Source: Unknown
100
Ampno Unknown Abundance of Ampelisca abdita from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Other Unknown Description of infauna present in SPI images | Description Source: Unknown
100
Algaehydro Unknown Presence of algae or hydroids in epifaunal community at sediment surface | Description Source: Unknown
100
Other_epi Unknown List of epifauna (excluding algae and hydroids) indicated in Epifauna column | Description Source: Unknown
100
Epifauna VARCHAR Description (abbr) of epifauna present in SPI images | Description Source: Unknown
100
Total_inf Unknown Total abundance from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Hab_agree VARCHAR Agreement rank from Ampelisca, Epifauna and Other columns | Description Source: Unknown
100
Burrows NUMBER Number of burrows seen in SPI image | Description Source: Unknown
100
Critters NUMBER Number of critters seen in SPI image | Description Source: Unknown
100
Voids NUMBER Number of voids seen in SPI image | Description Source: Unknown
100
Vtype VARCHAR Types of voids seen in SPI 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
Stage_agre VARCHAR Agreement rank for community successional stage between 2 slides analyzed per station | Description Source: Unknown
100
Rpd NUMBER Depth (cm) of apparent color Redox Potential Discontinuity based on computer analysis (99 = not measurable) | Description Source: Unknown
100
Rpd_code VARCHAR Code describing RPD value | Description Source: Unknown
100
Pen NUMBER Depth (cm) of camera penetration based on computer analysis (99 = not measurable) | Description Source: Unknown
100
Pen_code VARCHAR Code describing Pen value | Description Source: Unknown
100
Mixpa VARCHAR Ranked scale identifying stations having shellfish, but shellfish are too few in number (less than 3) to warrant a classification change | Description Source: Unknown
100
Delta VARCHAR Explanation for changes to habitat classes from spiHAB to mixHAB (based on integration of data types) | Description Source: Unknown
100
Mixhab VARCHAR Revised habitat classes based on SPI data, benthic grab data and plan-view data | Description Source: Unknown
100
Spihab VARCHAR Habitat classes based on SPI imagery data only | Description Source: Unknown

Attribute Details

Skey

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

Unique identifier for station | Description Source: Unknown

Allowed Values: 17 - 919

Station

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

Unique number assigned to sample sites | Description Source: Unknown

Allowed Values: 17.2 - 919.0

Dupe

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

Indicates visits to individual stations | Description Source: Unknown

Allowed Values: 1: single sampling visit to station | 2: multiple sampling visits to station |

Datatype

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

Indicates type of data collected at station | Description Source: Unknown

Allowed Values: 1: SPI only | 2: SPI and benthic grab | 3: SPI, sediment and benthic grabs | 5: SPI and sediment grab | 6: SPI, sediment and benthic grabs collected on different visits to station |

Latitude

CC ID: 660128
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.41950 - 40.59833

Longitude

CC ID: 660129
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.25133 - -73.96817

Latutm

CC ID: 660130
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: 4474786 - 4494620

Longutm

CC ID: 660131
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: 563462 - 587360

Slides

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

Number of slides analyzed for station | Description Source: Unknown

Allowed Values: 1 - 5

Sediment

CC ID: 660133
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: 660134
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

Shell_hash

CC ID: 660135
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 | ob: oyster bed | sb: unidentifiable shell bed | sh: shell hash present | z: none |

Merno

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

Abundance of Mercenaria mercenaria in benthic grabs (ND = no grab data) | Description Source: Unknown

Allowed Values: Character Field

Myano

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

Abundance of Mya arenaria in benthic grabs (ND = no grab data) | Description Source: Unknown

Allowed Values: Character Field

Spisno

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

Abundance of Spisula solidissima in benthic grabs (ND = nograb data) | Description Source: Unknown

Allowed Values: Character Field

Mytno

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

Abundance of Mytilus edulis in benthic grabs (ND = no grab data) | Description Source: Unknown

Allowed Values: Character Field

Sed_agree

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

Ranked agreement between slides for both Sediment and ShellHash categories | Description Source: Unknown

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

Interface

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

Description (abbr) for features seen at sediment surface | Description Source: Unknown

Allowed Values: b: bedforms | b;gr: bedforms; gravel | b;p: bedforms; pits | b;m: bedforms; mounds | d: detritus | d;e: detritus; even surface | d;e;u: detritus; even surface; uniform surface | d;m: detritus; mounds | d;p: detritus; pits | d;p;u: detritus; pits; uniform surface | e: even surface | e;m: even surface; mounds | e;m;p: even surface; mounds; pits | e;p: even surface; pits | e;u: even surface; uniform surface | m: mounds | m;p: mounds; pits | m;u: mounds; uniform surface | p: pits | p;e: pits; even surface | p;m: pits; mounds | p;u: pits; uniform surface | sh: shell hash | sh;b: shell hash; bedforms | sh;b;d;p: shell hash; bedforms; detritus; pits | sh;b;e: shell hash; bedforms; even surface | sh;b;e;m: shell hash; bedforms; even surface; mounds | sh;b;gr: shell hash; bedforms; gravel | sh;b;pb: shell hash; bedforms; pebbles | sh;b;u: shell hash; bedforms; uniform surface | sh;d: shell hash; detritus | sh;d;e: shell hash; detritus; even surface | sh;d;m: shell hash; detritus; mounds | sh;d;p: shell hash; detritus; pits | sh;e: shell hash; even surface | sh;e;m: shell hash; even surface; mounds | sh;e;p: shell hash; even surface; pits | sh;gr: shell hash; gravel | sh;m: shell hash; mounds | sh;m;p: shell hash; mounds; pits | sh;p: shell hash; pits | sh;pb: shell hash; pebbles | sh;pb;gr: shell hash; pebbles; gravel | sh;u: shell hash; uniform surface | z: none |

Bedforms

CC ID: 660142
Seq. Order: 19
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 |

Ampelisca

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

Description of relative numbers of Ampelisca abdita | Description Source: Unknown

Allowed Values: Character Field

Ampno

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

Abundance of Ampelisca abdita from benthic grab data (ND = no grab data) | Description Source: Unknown

Allowed Values: Character Field

Other

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

Description of infauna present in SPI images | Description Source: Unknown

Allowed Values: Character Field

Algaehydro

CC ID: 660146
Seq. Order: 23
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

Other_epi

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

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

Allowed Values: Character Field

Epifauna

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

Description (abbr) of epifauna present in SPI images | Description Source: Unknown

Allowed Values: al: algae | alhy: algae; hydroids | alss: algae; sea star | cc: crab | cr: Crepidula | epi: both algae and hydroids | fp: fecal pellet | hc: hermit crab | hccr: hermit crab; Crepidula | hy: hydroids | hyal: hydroids; algae | hyhc: hydroids; hermit crab | hysd: hydroids; sand dollar | hysn: hydroids; snail | hysp: hydroids; sponge | lp: Limulus | sd: sand dollar | sn: snail | sp: sponge | tv: tunicate | xchy: crab; hydroids | z: none |

Total_inf

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

Total abundance from benthic grab data (ND = no grab data) | Description Source: Unknown

Allowed Values: Character Field

Hab_agree

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

Agreement rank from Ampelisca, Epifauna and Other columns | Description Source: Unknown

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

Burrows

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

Number of burrows seen in SPI image | Description Source: Unknown

Allowed Values: 0 - 12

Critters

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

Number of critters seen in SPI image | Description Source: Unknown

Allowed Values: 0 - 19

Voids

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

Number of voids seen in SPI image | Description Source: Unknown

Allowed Values: 0 - 35

Vtype

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

Types of voids seen in SPI images | Description Source: Unknown

Allowed Values: an: anoxic | ga: gas | mx: mixed (multiple types) | ox: oxic | z: none |

Stage

CC ID: 660155
Seq. Order: 32
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: 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) | 3: OSI Stage 3 (infaunal deposit-feeders, especially 'head-down' feeders) | 9: not measurable |

Stage_agre

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

Agreement rank for community successional stage between 2 slides analyzed per station | Description Source: Unknown

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

Rpd

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

Depth (cm) of apparent color Redox Potential Discontinuity based on computer analysis (99 = not measurable) | Description Source: Unknown

Allowed Values: 0.0 - 99.0

Rpd_code

CC ID: 660158
Seq. Order: 35
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 slide | 2: not measurable due to poor penetration | 3: average of two slides | 9: not measurable due to no penetration |

Pen

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

Depth (cm) of camera penetration based on computer analysis (99 = not measurable) | Description Source: Unknown

Allowed Values: 1.0 - 99.0

Pen_code

CC ID: 660160
Seq. Order: 37
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 one slide | 2: not measurable due to over- penetration | 3: average of two slides | 9: not measurable due to poor penetration |

Mixpa

CC ID: 660161
Seq. Order: 38
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 (less than 3) to warrant a classification change | Description Source: Unknown

Allowed Values: 0: no shellfish | 1: Mercenaria mercenaria present | 2: Mya arenaria present | 3: Spisula solidissima present | ND: No data |

Delta

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

Explanation for changes to habitat classes from spiHAB to mixHAB (based on integration of data types) | Description Source: Unknown

Allowed Values: 0: No change | 1: Changed due to number of Mercenaria mercenaria (3+) in benthic grab | 2: Changed due to number of Mya arenaria (3+) in benthic grab | 3: Changed due to number of Spisula solidissima (3+) in benthic grab | 4: Changed due to number of Ampelisca abdita (greater than 200) in benthic grab | 5: Changed due to abundance of infauna (greater than 30) in benthic grab | ND: No grab data |

Mixhab

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

Revised habitat classes based on SPI data, benthic grab data and plan-view 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 | SandBed(critters): High energy sandy habitat with infauna | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(gravel): High energy sandy habitat with gravel | SandBed(hash): High energy sandy habitat with shell hash | SandBed(no modifier: High energy sandy habitat with no evidence of biological activity | SandNoBed(epifauna): Low energy sandy habitat with epifauna | SandNoBed(gravel): Low energy sandy habitat with gravel | SandNoBed(hash): Low energy sandy habitat with shell hash | SB(clams): 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 (methane pockets) | Silt(pendeep): Silty bottom habitat with very soft sediments |

Spihab

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

Habitat classes based on SPI imagery 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 | SandBed(critters): High energy sandy habitat with infauna | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(gravel): High energy sandy habitat with gravel | SandBed(hash): High energy sandy habitat with shell hash | SandBed(no modifier: High energy sandy habitat with no evidence of biological activity | SandNoBed(epifauna): Low energy sandy habitat with epifauna | SandNoBed(gravel): Low energy sandy habitat with gravel | SandNoBed(hash): Low energy sandy habitat with shell hash | SB(clams): 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 (methane pockets) | Silt(pendeep): Silty bottom habitat with very soft sediments |

Catalog Details

Catalog Item ID: 49344
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