Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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