Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
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