Guam Long-term Monitoring Program: Macro-Invertebrate Observations
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:47802 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Guam Long-term Monitoring Program: Macro-Invertebrate Observations |
---|---|
Short Name: | GLTMP Invert |
Status: | Completed |
Abstract: |
Guam Long-term Monitoring Program macro-invertebrate observation data |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Description: |
Guam Long-term Monitoring Program macro-invertebrate observation data |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
OBJECTID | NUMBER | Unique identifier for macro-invertebrate observations | |
100
|
SITE_ID | NUMBER | Unique site identifier | |
100
|
SITE | NVARCHAR2 | The 3-character code for the site surveyed | |
100
|
SITE_NAME | VARCHAR2 | Site name | |
100
|
STATION | NUMBER | Sampling station number | |
100
|
STATIONID | VARCHAR2 | A unique identifier combining the SITE with the STATION | |
100
|
LATITUDE | NUMBER | Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees | |
100
|
LONGITUDE | NUMBER | Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees | |
100
|
DATE_TIME | DATE | Date the survey was conducted | |
100
|
OBSERVERID | NVARCHAR2 | Initials of diver conducting survey | |
100
|
WAVEEXPOSURE | NVARCHAR2 | A general classification of the relative degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site | |
100
|
DEPTH | NUMBER | Depth of survey area in meters | |
100
|
STRATUM | NVARCHAR2 | The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West) | |
100
|
STATION_TYPE | VARCHAR2 | The sampling station type (Fixed or Unfixed) | |
100
|
INVERTTRANSECTID | NUMBER | Unique identifier for the transect along which a invertebrate belt is conducted during a given sampling period | |
100
|
TRANSECT_NUMBER | NUMBER | Transect number for a given site visit; value is "1" unless more than one transect was surveyed at a sampling station during a single site visit | |
100
|
TRANSECT_LENGTH | NUMBER | Length of the transect in meters | |
100
|
TRANSECT_WIDTH | NUMBER | Width of the transect in meters | |
100
|
INVERT_CODE | NUMBER | Unique taxon identifier | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Scientific name | |
100
|
TAXAGROUP | VARCHAR2 | Taxonomic grouping | |
100
|
INVERT_COUNT | NUMBER | Number of inverts observed during survey | |
100
|
DENSITY_M2 | NUMBER | Density (individuals per square meter) |
Attribute Details
OBJECTID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for macro-invertebrate observations |
SITE_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique site identifier |
SITE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The 3-character code for the site surveyed |
SITE_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Site name |
STATION
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Sampling station number |
STATIONID
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A unique identifier combining the SITE with the STATION |
LATITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees |
LONGITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees |
DATE_TIME
Seq. Order: | 9 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
OBSERVERID
Seq. Order: | 11 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting survey |
WAVEEXPOSURE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A general classification of the relative degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site |
Null Value: | NULL |
Null Value Meaning: |
Wave exposure class if not provided |
Allowed Values: | Low, Moderate, High |
DEPTH
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Depth of survey area in meters |
General Data Type: | Integer |
Unit of Measure: | m |
Null Value: | Null |
Null Value Meaning: |
Depth not provided for sampling station |
STRATUM
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West) |
Null Value: | NULL |
Null Value Meaning: |
Stratum not provided for sampling station |
Allowed Values: | Embayment-Terrace, ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-East, ReefFlatMargin-West |
STATION_TYPE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The sampling station type (Fixed or Unfixed) |
Null Value: | NULL |
Null Value Meaning: |
Sampling station type not provided |
Allowed Values: | Fixed, Unfixed |
INVERTTRANSECTID
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for the transect along which a invertebrate belt is conducted during a given sampling period |
TRANSECT_NUMBER
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Transect number for a given site visit; value is "1" unless more than one transect was surveyed at a sampling station during a single site visit |
General Data Type: | Integer |
TRANSECT_LENGTH
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Length of the transect in meters |
General Data Type: | Integer |
Unit of Measure: | m |
TRANSECT_WIDTH
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Width of the transect in meters |
General Data Type: | Integer |
Unit of Measure: | m |
INVERT_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique taxon identifier |
Allowed Values: | AECH = Actinopyga echinites, AFEN = Amplexidiscus fenestrafer, AMAU = Actinopyga mauritiana, APAL = Actinopyga palauensis, APLA = Acanthaster planci, ASTE = Asteroidea, BARG = Bohadschia argus, BVIT = Bohadschia vitiensis, CGRA = Choriaster granulatus, CNOV = Culcuta novaeguineae, CRUS = Crustacea, CSTR = Ciliopagurus strigatus, CTRI = Charonia tritonis, CYPS = Cypraea spp., DASP = Dardanus spp., DSAV = Diadema savignyi, EACI = Echinostrephus aciculatus, ECAL = Echinothrix calamaris, ECHI = Echinoidea, EDIA = Echinothrix diadema, ELUZ = Echinaster luzonicus, EMAT = Echinometra mathaei, EMET = Eucidaris metularia, EQUA = Entacmaea quadricolor, ESPA = Echinometra sp. A, FMIL = Fromia milleporella, GEGY = Gomophia egyptiaca, HATR = Holothuria atra, HCRI = Heteractis crispa, HEDU = Holothuria edulis, HLEU = Holothuria leucospilota, HMAG = Heteractis magnifica, HMAL = Heteractis malu, HOLO = Holothuroidea, HOSP = Holothuria sp., HWHI = Holothuria whitmaei, LASP = Lambis spp., LISP = Linckia spp., LLAE = Linckia laevigata, LLEI = Leiaster leachi, LMUL = Linckia leachi, LMUL = Linckia multiflora, NONE = None, OCYA = Octopus cyanea, PASP = Paguridae, PGRA = Parasalenia gratiosa, PGRE = Pearsonothuria graeffei, SCHL = Stichopus chloronotus, SHIS = Stenopus hispidus, SHOR = Stichopus horrens, SMAC = Synapta maculata, TANA = Thelenota ananas, TECT = Tectus spp., TGRA = Tripneuestes gratilla, TNIL = Tectus niloticus, TPYR = Tectus pyramis, TRID = Tridacna spp., TURB = Turbo spp. |
SCIENTIFIC_NAME
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name |
Allowed Values: | Actinopyga echinites, Amplexidiscus fenestrafer, Actinopyga mauritiana, Actinopyga palauensis, Acanthaster planci, Asteroidea, Bohadschia argus, Bohadschia vitiensis, Choriaster granulatus, Culcuta novaeguineae, Crustacea, Ciliopagurus strigatus, Charonia tritonis, Cypraea spp., Dardanus spp., Diadema savignyi, Echinostrephus aciculatus, Echinothrix calamaris, Echinoidea, Echinothrix diadema, Echinaster luzonicus, Echinometra mathaei, Eucidaris metularia, Entacmaea quadricolor, Echinometra sp. A, Fromia milleporella, Gomophia egyptiaca, Holothuria atra, Heteractis crispa, Holothuria edulis, Holothuria leucospilota, Heteractis magnifica, Heteractis malu, Holothuroidea, Holothuria sp., Holothuria whitmaei, Lambis spp., Linckia spp., Linckia laevigata, Leiaster leachi, Linckia leachi, Linckia multiflora, None, Octopus cyanea, Paguridae, Parasalenia gratiosa, Pearsonothuria graeffei, Stichopus chloronotus, Stenopus hispidus, Stichopus horrens, Synapta maculata, Thelenota ananas, Tectus spp., Tripneuestes gratilla, Tectus niloticus, Tectus pyramis, Tridacna spp., Turbo spp. |
TAXAGROUP
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic grouping |
Allowed Values: | Anemone, Crustacean, Edible Shell, None, Octopus, Other Mollusk, Sea Cucumber, Sea Star, Sea Urchin, Shrimp |
INVERT_COUNT
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Number of inverts observed during survey |
Null Value: | 0 |
Null Value Meaning: |
No macroinvertebrates recorded |
DENSITY_M2
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Density (individuals per square meter) |
General Data Type: | NUMBER |
Unit of Measure: | ind/m^2 |
Derivation: |
INVERT_COUNT/(TRANSECT_LENGTH*TRANSECT_WIDTH) |
Catalog Details
Catalog Item ID: | 47802 |
---|---|
GUID: | gov.noaa.nmfs.inport:47802 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-11-07 18:34+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-04-14 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-04-14 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-04-14 |