lbo94spi.dbf
Entity (ENT) | Office for Coastal Management (OCM)GUID: gov.noaa.nmfs.inport:49344 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |
---|---|
GUID: | gov.noaa.nmfs.inport: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: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-11-16 |
Owner Org: | OCM |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-11-16 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-11-16 |