Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
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
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

CC ID: 598172
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

CC ID: 598178
Seq. Order: 2
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unique site identifier

SITE

CC ID: 598177
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

CC ID: 598179
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Site name

STATION

CC ID: 598181
Seq. Order: 5
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling station number

STATIONID

CC ID: 598182
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

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

DATE_TIME

CC ID: 598160
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

OBSERVERID

CC ID: 598173
Seq. Order: 11
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

WAVEEXPOSURE

CC ID: 598187
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

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

STRATUM

CC ID: 598184
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

CC ID: 598183
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

CC ID: 598203
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

CC ID: 598186
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

CC ID: 598185
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

CC ID: 598211
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

CC ID: 598207
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

CC ID: 598176
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

CC ID: 598209
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

CC ID: 598210
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

CC ID: 897156
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