50867 V0_CORAL_DZ_OBS_A Entity Published / External 25285 Environmental Monitoring of Coral Bleaching and Disease in the Hawaiian Islands; Belt Transect Surveys and Disease Assessments of Coral Populations in Hawaii, Maui, and Oahu from March 8, 2010 to November 8, 2011 Data Set Completed Coral belt disease observations Data View Yes GISDAT Coral belt disease observations TRANSECT NUMBER No No Active Transect Number (1 or 2) 1 ROUNDID NUMBER 22 Yes No 28 0 Active Unique numeric id for mission 2 MISSIONID VARCHAR2 30 Yes No Active Unique text id for mission 3 REGION VARCHAR2 20 Yes No Active Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program 4 REGION_NAME VARCHAR2 30 No No Active One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands) 5 ISLAND NVARCHAR2 150 No No Active Island or atoll surveyed (Oahu, Maui, Hawaii) 6 ISLANDCODE NVARCHAR2 15 No No Active 3-letter island code (OAH, MAI, HAW) 7 SITE NVARCHAR2 150 Yes No Active The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number 8 LATITUDE NUMBER 22 No No 38 Active Latitude in decimal degrees, WGS84, for the given site 9 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84 for the given site 12 SITEVISITID NUMBER 22 Yes No Active Unique Identifier for SITE_VISIT record (unique for site and date) 13 DATE_ DATE 7 Yes No Active Date the survey was conducted 14 OBS_YEAR NUMBER 22 No No Active Year the survey was conducted 15 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey 16 DZTRANSECTRUN NUMBER No No Active Primary key for CORAL_DZ_TRANSECTRUN 18 TRANLENGTH NUMBER No No Active Transect Length (12.5 to 25 m) 19 TRANWIDTH NUMBER No No Active Transect Width (1, 2 or 4 m) 20 MINDEPTH NUMBER No No Active Minimum depth of transect (3 - 48 ft) 21 MAXDEPTH NUMBER No No Active Maximum depth of transect (3 - 48 ft) 22 TAXONCODE NVARCHAR2 150 No No Active Organism observed (code) 23 TAXONNAME NVARCHAR2 765 No No Active Taxonomic name to lowest level identified 24 PHYLUM VARCHAR2 255 No No Active Phylum Taxonomic Rank 25 CLASS NVARCHAR2 60 No No Active Class Taxonomic Rank 26 S_ORDER VARCHAR2 255 No No Active Order Taxonomic Rank 27 FAMILY VARCHAR2 255 No No Active Family Taxonomic Rank 28 GENUS NVARCHAR2 300 No No Active Genus Taxonomic Rank 29 SCIENTIFIC_NAME VARCHAR2 255 No No Active Species Taxonomic Rank. Only populated if organism identified to species (see RANK). 30 RANK VARCHAR2 20 No No Active Rank from WoRMS (World Register of Marine Species). 31 APHIAID VARCHAR2 20 No No Active Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). 32 LENGTH NUMBER No No Active Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. 33 WIDTH NUMBER No No Active Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. 34 DZCODE VARCHAR2 No No Active Disease code for 15 different types of diseases and afflictions affecting corals: ALG=Algal Infection BIN=Barnacle Infestation BLE=Environmental / Thermal Bleaching CIL=Ciliates CYA=Cyanophyte Infection DIS=Discolorations other than Bleaching FUG=Endolithic Fungal Infection OTH=Other PDS=Porites Discolored Swelling PRE=Predation PRS=Pigmentation Response PTR=Porites Trematodiasis SGA=Skeletal Growth Anomalies TLS=Sub-acute Tissue Loss WSY=Acute Tissue Loss - White Syndrome 35 DISEASE VARCHAR2 No No Active Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis. 36 SEVERITY NUMBER No No Active Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%). 37 COMMENTS VARCHAR2 No No Active Comments regarding disease observations gov.noaa.nmfs.inport:50867 Troy Kanemura 2017-12-22T14:52:32 SysAdmin InPortAdmin 2022-08-09T17:11:38 2017-12-22 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 2017-12-22 1 Year 2018-12-22