47786
Guam Long-term Monitoring Program: Coral Observations
GLTMP Coral
Entity
Published / External
47781
Guam Long-term Coral Reef Monitoring Program Coral Colony Size and Condition Surveys since 2010
Data Set
Completed
Guam Long-term Monitoring Program coral observation data
Data View
Yes
Guam Long-term Monitoring Program fish observation data
1
OBJECTID
NUMBER
Yes
No
Active
Unique record identifier
2
SITE_ID
NUMBER
Yes
No
Active
Unique site identifier
3
SITE
NVARCHAR2
150
Yes
No
Active
The 3-character code for the site surveyed
4
SITE_NAME
VARCHAR2
20
Yes
No
Active
Site name
5
STATION
NUMBER
Yes
No
Active
Sampling station number
6
STATIONID
VARCHAR2
10
Yes
No
Active
Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2)
7
LATITUDE
NUMBER
22
No
No
38
Active
Latitude in decimal degrees, WGS84, for the given site
8
LONGITUDE
NUMBER
22
No
No
Active
Longitude in decimal degrees, WGS84 for the given site
9
DATE_TIME
DATE
Yes
No
Active
Date the survey was conducted
10
OBSERVERID
VARCHAR2
150
Yes
No
Active
Initials of diver conducting survey
11
WAVEEXPOSURE
VARCHAR2
No
No
Active
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
Wave exposure classification not provided
Low, Moderate, High
12
DEPTH
NUMBER
Yes
No
Active
Depth in meters
Integer
m
NULL
Depth value not provided
13
STRATUM
NVARCHAR2
No
No
Active
The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West)
NULL
Stratum not provided
ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-West, ReefFlatMargin-East
14
STATION_TYPE
VARCHAR2
Yes
No
Active
Sampling station type (fixed or unfixed)
NULL
Sampling station type not provided
Fixed, Unfixed
15
CORALTRANSECTID
NUMBER
No
No
Active
Unique transect identifier
16
TRANSECT_NUMBER
NUMBER
22
Yes
No
38
0
Active
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
Transect number not provided
17
TRANSECT_LENGTH
NUMBER
Yes
No
Active
Transect length in meters
Integer
m
NULL
Transect length not provided
18
CORALQUADRATID
NUMBER
Yes
No
Active
Unique quadrat identifier
19
TRANSECT_SIDE
VARCHAR2
Yes
No
Active
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
Transect side not provided
R = right side, L = left side
20
TRANSECT_LOCATION
NUMBER
Yes
No
Active
Location of quadrat along the transect in meters
NULL
Transect location not provided
0, 5, 10, 15, 20, 25, 30
21
QUADRAT_LENGTH
NUMBER
22
Yes
No
28
8
Active
Quadrat length in meters
Integer
m
NULL
Quadrat length not provided
22
QUADRAT_WIDTH
NUMBER
22
Yes
No
38
8
Active
Quadrat width in meters
NULL
Quadrat width not provided
23
CORAL_CODE
NVARCHAR2
150
No
No
Active
Unique 4-letter code
NULL
No coral colonies recorded within quadrat
24
SCIENTIFIC_NAME
VARCHAR2
255
Yes
No
Active
Scientific name
25
GENUS
NVARCHAR2
300
No
No
Active
Genus
26
COLONY_LENGTH
NUMBER
22
Yes
No
38
8
Active
Colony length in centimeters; length is defined as the measurement of the greatest colony diameter
Integer
cm
NULL
No colonies observed within quadrat
NULL, = or > 1
27
COLONY_WIDTH
NUMBER
22
Yes
No
28
8
Active
Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length)
Integer
cm
NULL
No colonies were observed within the quadrat
NULL, = or > 1
28
OLD_DEAD
NUMBER
22
No
No
5
0
Active
Percentage of old dead coral
Percent
NULL
No old mortality recorded for colony (= 0% old mortality)
NULL, 0–100
29
RECENT_DEAD
NUMBER
22
No
No
5
0
Active
Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae
Integer
Percent
NULL
No recent mortality observed (= 0% recent mortality)
NULL, 0–100
30
DZ_CODE
NVARCHAR2
15
No
No
Active
Code for coral disease or condition
NULL
No coral disease or condition recorded
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
31
DISEASE
NVARCHAR2
150
No
No
Active
Coral disease or condition
NULL
No disease or condition recorded
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
32
SEVERITY
NUMBER
22
No
No
5
0
Active
Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
1–5
33
DZ_CODE2
NVARCHAR2
No
No
Active
Code for second coral disease or condition
NULL
Second coral disease or condition not recorded
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
34
DISEASE2
NVARCHAR2
No
No
Active
Second coral disease or condition
NULL
No second disease or condition recorded
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
35
SEVERITY2
NUMBER
No
No
Active
Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%)
1–5
36
PHOTO_YN
NVARCHAR2
No
No
Active
Indicates availability of photo of colony (1 = Yes, 0 = No)
1 = Yes, 0 = No
37
COLLECTED_YN
NVARCHAR2
No
No
Active
Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No)
1 = Yes, 0 = No
38
FRAGMENT_YN
NVARCHAR2
No
No
Active
Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No)
1 = Yes, 0 = No
39
REMNANT_YN
NVARCHAR2
No
No
Active
Indicates if the colony may be a remnant of a larger colony
1 = Yes, 0 = No
40
COMMENT_
NVARCHAR2
No
No
Active
Comments recorded by the observer
gov.noaa.nmfs.inport:47786
Troy Kanemura
2017-11-05T17:43:21
SysAdmin InPortAdmin
2022-08-09T17:11:32
2021-04-14
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-04-14
1 Year
2022-04-14