47786 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 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2021-04-14 1 Year 2022-04-14