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 Co... >

Guam Long-term Monitoring Program: Coral Observations

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47786  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Guam Long-term Monitoring Program coral observation data

Description

Guam Long-term Monitoring Program fish observation data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
OBJECTID
NUMBER 		Unique record identifier
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 		Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2)
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given site
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given site
DATE_TIME
DATE 		Date the survey was conducted
OBSERVERID
VARCHAR2 		Initials of diver conducting survey
WAVEEXPOSURE
VARCHAR2 		A general classification of the 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
DEPTH
NUMBER 		Depth in meters
STRATUM
NVARCHAR2 		The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West)
STATION_TYPE
VARCHAR2 		Sampling station type (fixed or unfixed)
CORALTRANSECTID
NUMBER 		Unique transect identifier
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
TRANSECT_LENGTH
NUMBER 		Transect length in meters
CORALQUADRATID
NUMBER 		Unique quadrat identifier
TRANSECT_SIDE
VARCHAR2 		Side of the transect tape on which quadrat is placed (R=right side, L=left side); currently, all quadrats are placed on the right side of the transect tape.
TRANSECT_LOCATION
NUMBER 		Location of quadrat along the transect in meters
QUADRAT_LENGTH
NUMBER 		Quadrat length in meters
QUADRAT_WIDTH
NUMBER 		Quadrat width in meters
CORAL_CODE
NVARCHAR2 		Unique 4-letter code
SCIENTIFIC_NAME
VARCHAR2 		Scientific name
GENUS
NVARCHAR2 		Genus
COLONY_LENGTH
NUMBER 		Colony length in centimeters; length is defined as the measurement of the greatest colony diameter
COLONY_WIDTH
NUMBER 		Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length)
OLD_DEAD
NUMBER 		Percentage of old dead coral
RECENT_DEAD
NUMBER 		Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae
DZ_CODE
NVARCHAR2 		Code for coral disease or condition
DISEASE
NVARCHAR2 		Coral disease or condition
SEVERITY
NUMBER 		Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
DZ_CODE2
NVARCHAR2 		Code for second coral disease or condition
DISEASE2
NVARCHAR2 		Second coral disease or condition
SEVERITY2
NUMBER 		Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
PHOTO_YN
NVARCHAR2 		Indicates availability of photo of colony (1 = Yes, 0 = No)
COLLECTED_YN
NVARCHAR2 		Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No)
FRAGMENT_YN
NVARCHAR2 		Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No)
REMNANT_YN
NVARCHAR2 		Indicates if the colony may be a remnant of a larger colony
COMMENT_
NVARCHAR2 		Comments recorded by the observer

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: Coral Observations
Short Name: GLTMP Coral
Status: Completed
Abstract:

Guam Long-term Monitoring Program coral observation data

Entity Information

Entity Type: Data View
Active Version?: Yes
Description:

Guam Long-term Monitoring Program fish observation data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 OBJECTID NUMBER Unique record identifier
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 Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2)
100
 LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the given site
100
 LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the given site
100
 DATE_TIME DATE Date the survey was conducted
100
 OBSERVERID VARCHAR2 Initials of diver conducting survey
100
 WAVEEXPOSURE VARCHAR2 A general classification of the 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 in meters
100
 STRATUM NVARCHAR2 The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West)
100
 STATION_TYPE VARCHAR2 Sampling station type (fixed or unfixed)
100
 CORALTRANSECTID NUMBER Unique transect identifier
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 Transect length in meters
100
 CORALQUADRATID NUMBER Unique quadrat identifier
100
 TRANSECT_SIDE VARCHAR2 Side of the transect tape on which quadrat is placed (R=right side, L=left side); currently, all quadrats are placed on the right side of the transect tape.
100
 TRANSECT_LOCATION NUMBER Location of quadrat along the transect in meters
100
 QUADRAT_LENGTH NUMBER Quadrat length in meters
100
 QUADRAT_WIDTH NUMBER Quadrat width in meters
100
 CORAL_CODE NVARCHAR2 Unique 4-letter code
100
 SCIENTIFIC_NAME VARCHAR2 Scientific name
100
 GENUS NVARCHAR2 Genus
100
 COLONY_LENGTH NUMBER Colony length in centimeters; length is defined as the measurement of the greatest colony diameter
100
 COLONY_WIDTH NUMBER Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length)
100
 OLD_DEAD NUMBER Percentage of old dead coral
100
 RECENT_DEAD NUMBER Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae
100
 DZ_CODE NVARCHAR2 Code for coral disease or condition
100
 DISEASE NVARCHAR2 Coral disease or condition
100
 SEVERITY NUMBER Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
100
 DZ_CODE2 NVARCHAR2 Code for second coral disease or condition
100
 DISEASE2 NVARCHAR2 Second coral disease or condition
100
 SEVERITY2 NUMBER Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
100
 PHOTO_YN NVARCHAR2 Indicates availability of photo of colony (1 = Yes, 0 = No)
100
 COLLECTED_YN NVARCHAR2 Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No)
100
 FRAGMENT_YN NVARCHAR2 Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No)
100
 REMNANT_YN NVARCHAR2 Indicates if the colony may be a remnant of a larger colony
100
 COMMENT_ NVARCHAR2 Comments recorded by the observer

Attribute Details

OBJECTID

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

Unique record identifier

SITE_ID

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

Unique site identifier

SITE

CC ID: 597375
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: 598078
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Site name

STATION

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

Sampling station number

STATIONID

CC ID: 598080
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2)

LATITUDE

CC ID: 597355
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given site

LONGITUDE

CC ID: 597356
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given site

DATE_TIME

CC ID: 597347
Seq. Order: 9
Data Storage Type: DATE
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

OBSERVERID

CC ID: 597349
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

WAVEEXPOSURE

CC ID: 598081
Seq. Order: 11
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A general classification of the 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 classification not provided
Allowed Values: Low, Moderate, High

DEPTH

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

Depth in meters
General Data Type: Integer
Unit of Measure: m
Null Value: NULL
Null Value Meaning:

Depth value not provided

STRATUM

CC ID: 598015
Seq. Order: 13
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West)
Null Value: NULL
Null Value Meaning:

Stratum not provided
Allowed Values: ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-West, ReefFlatMargin-East

STATION_TYPE

CC ID: 598083
Seq. Order: 14
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling station type (fixed or unfixed)
Null Value: NULL
Null Value Meaning:

Sampling station type not provided
Allowed Values: Fixed, Unfixed

CORALTRANSECTID

CC ID: 897057
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique transect identifier

TRANSECT_NUMBER

CC ID: 597380
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
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
Null Value: NULL
Null Value Meaning:

Transect number not provided

TRANSECT_LENGTH

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

Transect length in meters
General Data Type: Integer
Unit of Measure: m
Null Value: NULL
Null Value Meaning:

Transect length not provided

CORALQUADRATID

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

Unique quadrat identifier

TRANSECT_SIDE

CC ID: 598089
Seq. Order: 19
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Side of the transect tape on which quadrat is placed (R=right side, L=left side); currently, all quadrats are placed on the right side of the transect tape.
Null Value: NULL
Null Value Meaning:

Transect side not provided
Allowed Values: R = right side, L = left side

TRANSECT_LOCATION

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

Location of quadrat along the transect in meters
Null Value: NULL
Null Value Meaning:

Transect location not provided
Allowed Values: 0, 5, 10, 15, 20, 25, 30

QUADRAT_LENGTH

CC ID: 597371
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Quadrat length in meters
General Data Type: Integer
Unit of Measure: m
Null Value: NULL
Null Value Meaning:

Quadrat length not provided

QUADRAT_WIDTH

CC ID: 597373
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Quadrat width in meters
Null Value: NULL
Null Value Meaning:

Quadrat width not provided

CORAL_CODE

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

Unique 4-letter code
Null Value: NULL
Null Value Meaning:

No coral colonies recorded within quadrat

SCIENTIFIC_NAME

CC ID: 597370
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name

GENUS

CC ID: 597352
Seq. Order: 25
Data Storage Type: NVARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Genus

COLONY_LENGTH

CC ID: 597343
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Colony length in centimeters; length is defined as the measurement of the greatest colony diameter
General Data Type: Integer
Unit of Measure: cm
Null Value: NULL
Null Value Meaning:

No colonies observed within quadrat
Allowed Values: NULL, = or > 1

COLONY_WIDTH

CC ID: 597344
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length)
General Data Type: Integer
Unit of Measure: cm
Null Value: NULL
Null Value Meaning:

No colonies were observed within the quadrat
Allowed Values: NULL, = or > 1

OLD_DEAD

CC ID: 597362
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of old dead coral
Unit of Measure: Percent
Null Value: NULL
Null Value Meaning:

No old mortality recorded for colony (= 0% old mortality)
Allowed Values: NULL, 0–100

RECENT_DEAD

CC ID: 597365
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae
General Data Type: Integer
Unit of Measure: Percent
Null Value: NULL
Null Value Meaning:

No recent mortality observed (= 0% recent mortality)
Allowed Values: NULL, 0–100

DZ_CODE

CC ID: 597345
Seq. Order: 30
Data Storage Type: NVARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Code for coral disease or condition
Null Value: NULL
Null Value Meaning:

No coral disease or condition recorded
Allowed Values: NULL, AI = Algal infestation, ALPH = Alpheus burrow, AO = Algal overgrowth, ASC = Ascidian, BLEA = Bleaching, BLKB = Black band disease, BRNB = Brown band disease, COR = Coralliophila, COTS = Crown of thorns seastar, CYAN = Cyanobacteria, DISC = Discoloration, DRUP = Drupella, FB = Fish bites, GGA = Growth anomaly, MSC = Mucous sloughing from coral, NA = Not applicable, PALE = Paling, PB = Patchy bleaching, PR = Pigmentation response, PRED = Predation-unknown, SATL = Sub-acute tissue loss, SEB = Skeletal eroding band disease, SED = Sediment on coral, TERP = Terpios overgrowth, UN = Unknown, URCH = Urchin infestation, UWS = Ulcerative white spots disease, VERM = Vermetid worm infestation, WS = White syndrome

DISEASE

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

Coral disease or condition
Null Value: NULL
Null Value Meaning:

No disease or condition recorded
Allowed Values: NULL, Algal infestation, Alpheus burrow, Algal overgrowth, Ascidian, Bleaching, Black band disease, Brown band disease, Coralliophila, Crown of thorns seastar, Cyanobacteria, Discoloration, Drupella, Fish bites, Growth anomaly, Mucous sloughing from coral, Not applicable, Paling, Patchy bleaching, Pigmentation response, Predation-unknown, Sub-acute tissue loss, Skeletal eroding band disease, Sediment on coral, Terpios overgrowth, Unknown, Urchin infestation, Ulcerative white spots disease, Vermetid worm infestation, White syndrome

SEVERITY

CC ID: 597374
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
Allowed Values: 1–5

DZ_CODE2

CC ID: 897058
Seq. Order: 33
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for second coral disease or condition
Null Value: NULL
Null Value Meaning:

Second coral disease or condition not recorded
Allowed Values: NULL, AI = Algal infestation, ALPH = Alpheus burrow, AO = Algal overgrowth, ASC = Ascidian, BLEA = Bleaching, BLKB = Black band disease, BRNB = Brown band disease, COR = Coralliophila, COTS = Crown of thorns seastar, CYAN = Cyanobacteria, DISC = Discoloration, DRUP = Drupella, FB = Fish bites, GGA = Growth anomaly, MSC = Mucous sloughing from coral, NA = Not applicable, PALE = Paling, PB = Patchy bleaching, PR = Pigmentation response, PRED = Predation-unknown, SATL = Sub-acute tissue loss, SEB = Skeletal eroding band disease, SED = Sediment on coral, TERP = Terpios overgrowth, UN = Unknown, URCH = Urchin infestation, UWS = Ulcerative white spots disease, VERM = Vermetid worm infestation, WS = White syndrome

DISEASE2

CC ID: 897059
Seq. Order: 34
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Second coral disease or condition
Null Value: NULL
Null Value Meaning:

No second disease or condition recorded
Allowed Values: NULL, Algal infestation, Alpheus burrow, Algal overgrowth, Ascidian, Bleaching, Black band disease, Brown band disease, Coralliophila, Crown of thorns seastar, Cyanobacteria, Discoloration, Drupella, Fish bites, Growth anomaly, Mucous sloughing from coral, Not applicable, Paling, Patchy bleaching, Pigmentation response, Predation-unknown, Sub-acute tissue loss, Skeletal eroding band disease, Sediment on coral, Terpios overgrowth, Unknown, Urchin infestation, Ulcerative white spots disease, Vermetid worm infestation, White syndrome

SEVERITY2

CC ID: 897060
Seq. Order: 35
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
Allowed Values: 1–5

PHOTO_YN

CC ID: 897061
Seq. Order: 36
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Indicates availability of photo of colony (1 = Yes, 0 = No)
Allowed Values: 1 = Yes, 0 = No

COLLECTED_YN

CC ID: 897098
Seq. Order: 37
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No)
Allowed Values: 1 = Yes, 0 = No

FRAGMENT_YN

CC ID: 897099
Seq. Order: 38
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No)
Allowed Values: 1 = Yes, 0 = No

REMNANT_YN

CC ID: 897100
Seq. Order: 39
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Indicates if the colony may be a remnant of a larger colony
Allowed Values: 1 = Yes, 0 = No

COMMENT_

CC ID: 897101
Seq. Order: 40
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Comments recorded by the observer

Catalog Details

Catalog Item ID: 47786
GUID: gov.noaa.nmfs.inport:47786
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-11-05 17:43+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