Guam Long-term Monitoring Program: Macro-Invertebrate Observations
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:47802 | Updated: December 5, 2023 | 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
|
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
|
DATE_TIME | DATE | Date the survey was conducted | |
|
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
|
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
|
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
|
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
|
DEPTH | NUMBER | Depth of survey area in meters | |
|
100
|
OBSERVER | NVARCHAR2 | anonymized unique identifier for observer | |
|
100
|
TRANSECT_LENGTH | NUMBER | Length of the transect in meters | |
|
100
|
TRANSECT_WIDTH | NUMBER | Width of the transect in meters | |
|
100
|
SCIENTIFIC_NAME | VARCHAR2 | Scientific name | |
|
100
|
TAXAGROUP | VARCHAR2 | Taxonomic grouping | |
|
100
|
INVERT_COUNT | NUMBER | Number of inverts observed during survey | |
|
100
|
INVERT_DENSITY_M2 | NUMBER | Density (ind/m^2) for a invertebrate taxon at a given sampling station (= one transect), calculated as the count value divided by the transect area (TRANSECT_LENGTH times TRANSECT_WIDTH) | |
|
100
|
YEAR | NUMBER | Year in which survey was conducted |
Attribute Details
SITE_ID
CC ID: 598178
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique site identifier |
SITE
CC ID: 598177
| Seq. Order: | 2 |
|---|---|
| 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
CC ID: 598179
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Site name |
STATION
CC ID: 598181
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sampling station number |
STATIONID
CC ID: 598182
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A unique identifier combining the SITE with the STATION |
DATE_TIME
CC ID: 598160
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the survey was conducted |
LATITUDE
CC ID: 598167
| 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
CC ID: 598168
| 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 |
WAVEEXPOSURE
CC ID: 598187
| Seq. Order: | 9 |
|---|---|
| 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 |
STRATUM
CC ID: 598184
| Seq. Order: | 10 |
|---|---|
| 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
CC ID: 598183
| Seq. Order: | 11 |
|---|---|
| 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 |
TRANSECT_NUMBER
CC ID: 598186
| Seq. Order: | 12 |
|---|---|
| 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 |
DEPTH
CC ID: 598161
| 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 |
OBSERVER
CC ID: 598173
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
anonymized unique identifier for observer |
TRANSECT_LENGTH
CC ID: 598185
| Seq. Order: | 15 |
|---|---|
| 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
CC ID: 598211
| Seq. Order: | 16 |
|---|---|
| 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 |
SCIENTIFIC_NAME
CC ID: 598176
| Seq. Order: | 17 |
|---|---|
| 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
CC ID: 598209
| Seq. Order: | 18 |
|---|---|
| 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
CC ID: 598210
| Seq. Order: | 19 |
|---|---|
| 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 |
INVERT_DENSITY_M2
CC ID: 1284349
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Density (ind/m^2) for a invertebrate taxon at a given sampling station (= one transect), calculated as the count value divided by the transect area (TRANSECT_LENGTH times TRANSECT_WIDTH) |
YEAR
CC ID: 897156
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year in which survey was conducted |
| 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: | David R Burdick |
| Metadata Record Last Modified: | 2023-12-05 23:22+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 |