Item Identification

Title: jbj95spi.dbf
Short Name: jbj95spi.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
Station NUMBER Unique number assigned to sample sites | Description Source: Unknown
100
Dupe VARCHAR Indicates visits to stations | Description Source: Unknown
100
Navqaqc VARCHAR Quality control codes for station coordinates (decimal degrees) | Description Source: Unknown
100
Datatype VARCHAR Describes the type of data collected at a station | Description Source: Unknown
100
Location VARCHAR Area 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
Shell_hash 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
Pvsiphons Unknown Numbers of clam siphons seen 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 from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Myano Unknown Abundance of Mya arenaria from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Spisno Unknown Abundance of Spisula solidissima from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Mytno Unknown Abundance of Mytilus edulis from benthic grab data (ND = no grab data) | Description Source: Unknown
100
Sed_agree VARCHAR Ranked agreement between slides for both Sediment and Shell Hash 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 ( greater than 1 = composite information represented) | 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 fields | 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: Unknown
100
Stage_agre VARCHAR Agreement rank between 2 slides for community successional stage | 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 | 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

Station

CC ID: 659939
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 - 169

Dupe

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

Indicates visits to stations | Description Source: Unknown

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

Navqaqc

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

Quality control codes for station coordinates (decimal degrees) | Description Source: Unknown

Allowed Values: 1: correct coordinates | 5: coordinates did not pass QA/QC, but simple fix brought station in line | 6: station did not pass QA/QC, but no obvious simple fix able to be made |

Datatype

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

Describes the type of data collected at a station | Description Source: Unknown

Allowed Values: 1: SPI only | 2: SPI and benthic grab | 7: SPI, benthic sediment grab, but benthic grab lost |

Location

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

Area or region where station is located | Description Source: Unknown

Allowed Values: Atlantic Basin: Atlantic Basin, Upper Bay, NY | Bay Ridge Flat: Bay Ridge Flats, 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: 659944
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees | Description Source: Unknown

Allowed Values: 40.58250 - 40.78583

Longitude

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

Longitude in decimal degrees | Description Source: Unknown

Allowed Values: -74.13950 - -73.75150

Latutm

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

Latitude in UTM Zone 18 coordinates | Description Source: Unknown

Allowed Values: 4492997 - 4515603

Longutm

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

Longitude in UTM Zone 18 coordinates | Description Source: Unknown

Allowed Values: 572721 - 605585

Slides

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

Number of slides used in analysis | Description Source: Unknown

Allowed Values: 1 - 2

Sediment

CC ID: 659949
Seq. Order: 11
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: 659950
Seq. Order: 12
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: 659951
Seq. Order: 13
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: mb: mussel bed | ob: oyster bed | sb: unidentifiable shell bed | sh: shell hash present | z: none present |

Spisb

CC ID: 659952
Seq. Order: 14
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: 659953
Seq. Order: 15
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

Pvsiphons

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

Numbers of clam siphons seen in plan-view images (ND=No data) | Description Source: Unknown

Allowed Values: Character Field

Carpet

CC ID: 659955
Seq. Order: 17
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: 659956
Seq. Order: 18
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Character Field

Myano

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

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

Allowed Values: Character Field

Spisno

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

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

Allowed Values: Character Field

Mytno

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

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

Allowed Values: Character Field

Sed_agree

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

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

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

Interface

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

Features at sediment surface | Description Source: Unknown

Allowed Values: al: algae | al;b: algae; bedforms | b: bedforms | b;e: bedforms; even surface | bed: shell bed | d: debris | d;e: debris; even surface | d;p: debris; pits | e: even surface | e;m: even surface; mounds | e;p: even surface; pits | m: mounds | m;p: mounds; pits | p: pits | sh: shell hash | sh;b: shell hash; bedforms | sh;b;al: shell hash; bedforms; algae | sh;b;d: shell hash; bedforms; debris | sh;b;e: shell hash; bedforms; even surface | sh;b;m: shell hash; bedforms; mounds | sh;bed;b: shell hash; shell bed; bedforms | sh;bed;m: shell hash; shell bed; mounds | sh;bed;p: shell hash; shell bed; pits | sh;c;e: shell hash; clasts; even surface | sh;d;e;p: shell hash; debris; even surface; pits | sh;e;p: shell hash; even surface; pits | z: none |

Bedforms

CC ID: 659962
Seq. Order: 24
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: 659963
Seq. Order: 25
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: 659964
Seq. Order: 26
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: 0 - 4

Ampelisca

CC ID: 659965
Seq. Order: 27
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: 659966
Seq. Order: 28
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: 659967
Seq. Order: 29
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: 659968
Seq. Order: 30
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: 659969
Seq. Order: 31
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: 659970
Seq. Order: 32
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: ccsnal: crab; snail; algae | eg: gelatinous egg case | ep: unidentifiable epifauna | fw: flatworm | hc: hermit crab | hcsn: hermit crab; snail | hcsnalhy: hermit crab; snail; algae; hydroids | hy: hydroids | sn: snail | snal: snail; algae | z: none |

Total_inf

CC ID: 659971
Seq. Order: 33
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: 659972
Seq. Order: 34
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

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

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

Burrows

CC ID: 659973
Seq. Order: 35
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 - 3

Critters

CC ID: 659974
Seq. Order: 36
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 - 22

Voids

CC ID: 659975
Seq. Order: 37
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 - 30

Vtype

CC ID: 659976
Seq. Order: 38
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 | an;ga: anoxic; gas | an;ox: anoxic; oxic | ga: gas | ga;ox: gas; oxic | ox: oxic | z: none |

Stage

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

Community successional stage | Description Source: Unknown

Allowed Values: ND: No Data |

Stage_agre

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

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

Allowed Values: ND: No Data |

Rpd

CC ID: 659979
Seq. Order: 41
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 - 99

Rpd_code

CC ID: 659980
Seq. Order: 42
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 | 3: average of two slides |

Pen

CC ID: 659981
Seq. Order: 43
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: 2.6 - 99

Pen_code

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

Code describing Pen value | Description Source: Unknown

Allowed Values: 1: calculated from one slide | 2: not measurable | 3: average of two slides |

Mixpa

CC ID: 659983
Seq. Order: 45
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 | ND: No data |

Delta

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

Explanation for changes to habitat classes from spiHAB to mixHAB | Description Source: Unknown

Allowed Values: 0: No change | 1: Changed due to number of Mercenaria mercenaria (3+) in benthic grab | 4: Changed due to number of Ampelisca abdita ( greater than 200) in benthic grab | 5: Changed due to number of Total Infauna ( greater than 30) in benthic grab | ND: No grab data available for station |

Mixhab

CC ID: 659985
Seq. Order: 47
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 | Azoic: Silty bottom habitat with no evidence of biological activity | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(hash): High energy sandy habitat with shell hash | SandBed(no modifie: High energy sandy habitat with no evidence of biological activity | SandNoBed)critters: Low energy sandy habitat with infauna | 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 ( greater than 18 cm) |

Spihab

CC ID: 659986
Seq. Order: 48
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(sifs, sims): Ampelisca mat on silty sand sediments | Azoic: Silty bottom habitat with no evidence of biological activity | SandBed(epifauna): High energy sandy habitat with epifauna | SandBed(hash): High energy sandy habitat with shell hash | SandBed(no modifie: High energy sandy habitat with no evidence of biological activity | SandNoBed)critters: Low energy sandy habitat with infauna | 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 ( greater than 18 cm) |

Catalog Details

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