lbj95spi.dbf
Entity (ENT) | Office for Coastal Management (OCM)GUID: gov.noaa.nmfs.inport:49347 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Data Attributes
Catalog Details
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
|
Navqaqc | VARCHAR | Quality control codes for station coordinates (decimal degrees) | 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
|
Spisb | Unknown | Description of live shellfish as indicated in the Shellhash field | Description Source: Unknown | |
|
100
|
Pvshellbed | VARCHAR | Types of live shellbed identified in plan-view images | Description Source: Unknown | |
|
100
|
Pvsiphons | Unknown | Numbers of clam siphons seen in plan-view images (ND = no plan-view images taken) | Description Source: Unknown | |
|
100
|
Carpet | VARCHAR | Presence of 'carpet-like' layer of shell hash in Plan-view images | 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 = no grab 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
|
Pvbedforms | VARCHAR | Presence of bedforms at sediment surface in plan-view images | Description Source: Unknown | |
|
100
|
Pvslides | NUMBER | Number of plan-view images used to characterize station | 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: 660209
| 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.0 - 954.0 |
Station
CC ID: 660210
| 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.0 - 954.0 |
Navqaqc
CC ID: 660211
| 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 | 3: run/shift A | 5: station did not pass QA/QC check, but simple fix brought station in line | 6: station did not pass QA/QC check, and no simple fix could be made | |
Dupe
CC ID: 660212
| Seq. Order: | 4 |
|---|---|
| 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: 660213
| Seq. Order: | 5 |
|---|---|
| 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 | 101: SPI and sediment grab | 11: SPI and benthic grab | 111: SPI, sediment and benthic grabs | |
Latitude
CC ID: 660214
| 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.45000 - 40.60167 |
Longitude
CC ID: 660215
| 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.25050 - -73.96283 |
Latutm
CC ID: 660216
| 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: | 4478093 - 4494990 |
Longutm
CC ID: 660217
| 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: | 563538 - 587805 |
Slides
CC ID: 660218
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of slides analyzed for station | Description Source: Unknown |
| Allowed Values: | 1 - 4 |
Sediment
CC ID: 660219
| 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: 660220
| 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: 660221
| 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: | cb: clam bed | mb: mussel bed | sb: unidentifiable shell bed | sh: shell hash present | z: none | |
Spisb
CC ID: 660222
| 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: 660223
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Types of live shellbed identified in plan-view images | Description Source: Unknown |
| Allowed Values: | clams: Hard clams, soft clams or surf clams present | clams?: Possible presence of hard clams, soft clams or surf clams | mussel: Mytilus edulis present | mussel?: Possible presence of Mytilus edulis | ND: No plan-view images taken at station | z: Shellfish absent from plan-view image | |
Pvsiphons
CC ID: 660224
| 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 plan-view images taken) | Description Source: Unknown |
| Allowed Values: | Character Field |
Carpet
CC ID: 660225
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Presence of 'carpet-like' layer of shell hash in Plan-view images | Description Source: Unknown |
| Allowed Values: | maybe: Possible presence of shell hash carpet | ND: No plan-view image taken at station | no: little or no shell hash | yes: dense layer of shell hash at surface | |
Merno
CC ID: 660226
| Seq. Order: | 18 |
|---|---|
| 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: 660227
| Seq. Order: | 19 |
|---|---|
| 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: 660228
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | Unknown |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Abundance of Spisula solidissima in benthic grabs (ND = no grab data) | Description Source: Unknown |
| Allowed Values: | Character Field |
Mytno
CC ID: 660229
| Seq. Order: | 21 |
|---|---|
| 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: 660230
| Seq. Order: | 22 |
|---|---|
| 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: 660231
| Seq. Order: | 23 |
|---|---|
| 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;d;m: bedforms; debris; mounds | b;gr: bedforms; gravel | b;p: bedforms; pits | bed;rk: shell bed; rocks | d: debris | d;e: debris; even surface | d;p: debris; pits | e: even surface | e;m: even surface; mounds | e;p: even surface; pits | gr: gravel | m: mounds | m;p: mounds; pits | p: pits | sh: shell hash | sh;b: shell hash; bedforms | sh;b;e: shell hash; bedforms; even surface | sh;b;gr: shell hash; bedforms; gravel | sh;b;m: shell hash; bedforms; mounds | sh;b;p: shell hash; bedforms; pits | sh;b;p;u: shell hash; bedforms; pits; uneven surface | sh;b;pb: shell hash; bedforms; pebbles | sh;b;rk: shell hash; bedforms; rocks | sh;bed: shell hash; shell bed | sh;bed,d: shell hash; shell bed; debris | sh;bed;b: shell hash; shell bed; bedforms | sh;bed;d: shell hash; shell bed; debris | sh;bed;e: shell hash; shell bed; even surface | sh;bed;gr: shell hash; shell bed; gravel | sh;bed;m: shell hash; shell bed; mounds | sh;d: shell hash; debris | sh;d;m: shell hash; debris; mounds | sh;e: shell hash; even surface | sh;gr: shell hash; gravel | sh;gr;p: shell hash; gravel; pits | sh;m: shell hash; mounds | sh;m;p: shell hash; mounds; pits | sh;p: shell hash; pits | sh;p;m: shell hash; pits; mounds | sh;u: shell hash; uneven surface | z: none | |
Bedforms
CC ID: 660232
| 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: 660233
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Presence of bedforms at sediment surface in plan-view images | Description Source: Unknown |
| Allowed Values: | ND: No plan-view image taken at station | no: Bedforms absent from plan-view image | yes: Bedforms present in plan-view image | |
Pvslides
CC ID: 660234
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of plan-view images used to characterize station | Description Source: Unknown |
| Allowed Values: | 1 - 2 |
Ampelisca
CC ID: 660235
| 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: 660236
| 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: 660237
| 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: 660238
| 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: 660239
| 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: 660240
| 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: | alsn: algae; snail | alsnd: algae; snail; detritus | c: crab | cc: crab | cchcsn: crab; hermit crab; snail | cr: Crepidula | d: detritus | epi: both algae and hydroids | hc: hermit crab | hccr: hermit crab; Crepidula | hchycr: hermit crab; hydroids; Crepidula | hchyd: hermit crab; hydroids; detritus | hcsc: hermit crab; crab | hcsn: hermit crab; snail | hcsncr: hermit crab; snail; Crepidula | hy: hydroids | hyal: hydroids; algae | hycr: hydroids; Crepidula | hycs: hydroids; Crangon shrimp | hyhc: hydroids; hermit crab | hyhcsp: hydroids; hermit crab; sponge | hysn: hydroids; snail | hysp: hydroids; sponge | sn: snail | sncc: snail; crab | sncr: snail; Crepidula | snhchy: snail; hermit crab; hydroids | snhy: snail; hydroids | sp: sponge | spxc: sponge; crab | spxccr: sponge; crab; Crepidula | xc: crab | xccr: crab; Crepidula | z: none | |
Total_inf
CC ID: 660241
| 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: 660242
| Seq. Order: | 34 |
|---|---|
| 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: 660243
| 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 - 7 |
Critters
CC ID: 660244
| 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 - 38 |
Voids
CC ID: 660245
| 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 - 16 |
Vtype
CC ID: 660246
| 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 | ga: gas | mx: mixed (multiple types) | ox: oxic | u: unknown | z: none | |
Stage
CC ID: 660247
| Seq. Order: | 39 |
|---|---|
| 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) | 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 | |
Stage_agre
CC ID: 660248
| Seq. Order: | 40 |
|---|---|
| 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 | 9: not measurable | |
Rpd
CC ID: 660249
| 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: 660250
| 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: 660251
| 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: | 1 - 99 |
Pen_code
CC ID: 660252
| Seq. Order: | 44 |
|---|---|
| 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 | 3: average of two slides | |
Mixpa
CC ID: 660253
| 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 | 3: Spisula solidissima present | ND: No data | |
Delta
CC ID: 660254
| 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 (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 | 6: Changed due to plan-view image | ND: No grab data | |
Mixhab
CC ID: 660255
| 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(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(mussels): Live mussel beds (Mytilus edulis) | 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: 660256
| 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(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(mussels): Live mussel beds (Mytilus edulis) | 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 | |