Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Guam Long-term Coral Reef Monitoring Program > Guam Long-term Coral Reef Monitoring Program Ma... >

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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Guam Long-term Monitoring Program macro-invertebrate observation data

Description

Guam Long-term Monitoring Program macro-invertebrate observation data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
SITE_ID
NUMBER 		Unique site identifier
SITE
NVARCHAR2 		The 3-character code for the site surveyed
SITE_NAME
VARCHAR2 		Site name
STATION
NUMBER 		Sampling station number
STATIONID
VARCHAR2 		A unique identifier combining the SITE with the STATION
DATE_TIME
DATE 		Date the survey was conducted
LATITUDE
NUMBER 		Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
LONGITUDE
NUMBER 		Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
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
STRATUM
NVARCHAR2 		The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West)
STATION_TYPE
VARCHAR2 		The sampling station type (Fixed or Unfixed)
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
DEPTH
NUMBER 		Depth of survey area in meters
OBSERVER
NVARCHAR2 		anonymized unique identifier for observer
TRANSECT_LENGTH
NUMBER 		Length of the transect in meters
TRANSECT_WIDTH
NUMBER 		Width of the transect in meters
SCIENTIFIC_NAME
VARCHAR2 		Scientific name
TAXAGROUP
VARCHAR2 		Taxonomic grouping
INVERT_COUNT
NUMBER 		Number of inverts observed during survey
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)
YEAR
NUMBER 		Year in which survey was conducted

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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