46826 V0_CORAL_OBS_E Entity Published / External 30775 Coral reef ecosystem marine protected area monitoring in Fagamalo, American Samoa: comprehensive assessment of coral demography (adult and juvenile corals) from belt transect surveys in 2015 Data Set Completed Coral belt observations (adult) Data View Yes GISDAT Coral belt observations (adult) CLADIELLA_YN NUMBER No No Active Flag to indicate presence of cladiella on transect (Added Sept. 2014) DENDRONEPHTHYA_YN NUMBER No No Active Flag to indicate presence of dendronephthya on transect (Added Sept. 2014) LOBOPHYTUM_YN NUMBER No No Active Flag to indicate presence of lobophytum on transect (Added Sept. 2014) PACHYCLAVULARIA_YN NUMBER No No Active Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014) PALYTHOA_YN NUMBER No No Active Flag to indicate presence of palythoa on transect (Added Sept. 2014) PROTOPALYTHOA_YN NUMBER No No Active Flag to indicate presence of protopalythoa on transect (Added Sept. 2014) ZOANTHUS_YN NUMBER No No Active Flag to indicate presence of zoanthus on transect (Added Sept. 2014) MINDEPTH NUMBER No No Active Minimum Depth of the transect (in meters) SARCOPHYTON_YN NUMBER No No Active Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) SINULARIA_YN NUMBER No No Active Flag to indicate presence of sinularia on transect (Added Sept. 2014) STEREONEPHTHYA_YN NUMBER No No Active Flag to indicate presence of stereonephthya on transect (Added Sept. 2014) WIRECORAL_YN NUMBER No No Active Flag to indicate presence of wire coral on transect (Added Sept. 2014) MAXDEPTH NUMBER No No Active Maximum Depth of the transect (in meters) 3 REGION VARCHAR2 20 Yes No Active Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table 4 REGION_NAME VARCHAR2 30 No No Active One of the five Pacific Island regions CRED surveys 5 ISLAND NVARCHAR2 150 No No Active Island or Atoll surveyed 6 ISLANDCODE NVARCHAR2 15 No No Active 3-letter island code 7 SITE NVARCHAR2 150 Yes No Active The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a 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 10 REEF_ZONE_CODE VARCHAR2 3 Yes No Active 3-letter reef zone code 11 REEF_ZONE NVARCHAR2 150 No No Active The reef zone for the given site (Forereef, Backreef or Lagoon) 12 DEPTH_BIN NVARCHAR2 60 No No Active Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site 13 DEPTH_CODE VARCHAR2 1 No No Active Depth zone code 14 SITEVISITID NUMBER 22 Yes No Active Unique Identifier for SITE_VISIT record 15 DATE_ DATE 7 Yes No Active Date the survey was conducted 16 OBS_DAY NUMBER 22 No No Active Observation Day 17 OBS_MONTH NUMBER 22 No No 38 Active Observation Month 18 OBS_YEAR NUMBER 22 No No Active Observation Year 19 SITE_MIN_DEPTH NUMBER 22 No No 5 0 Active Minimum site depth (ft) 20 SITE_MAX_DEPTH NUMBER 22 No No 5 0 Active Maximum site depth (ft) 21 HABITAT_CODE VARCHAR2 50 No No Active Habitat code 22 HABITAT_TYPE VARCHAR2 30 No No Active Habitat type 23 DIVER NVARCHAR2 150 Yes No Active Initials of diver conducting survey 24 BELTTRANSECTRUN NUMBER 22 Yes No 38 0 Active Primary key for CORAL_BELT_TRANSECTRUN 25 METHODNAME NVARCHAR2 150 Yes No Active References the coral belt survey method 26 TRANSECT NUMBER 22 Yes No 38 0 Active Transect Number 27 SEGMENT NVARCHAR2 150 No No Active Segment Number 28 SEGWIDTH NUMBER 22 No No 38 8 Active Segment Length (m) 29 SEGLENGTH NUMBER 22 No No 28 8 Active Segment Width (m) 30 NO_SURVEY_YN NUMBER 22 No No Active Flag to indicate transect was not surveyed (Added Sept. 2014) 31 COLONYID NUMBER 22 No No 38 0 Active Colony Identifier 32 TAXONCODE NVARCHAR2 150 No No Active Species observed 33 MORPH_CODE VARCHAR2 5 No No Active 4-letter morphology code 34 MORPHOLOGY VARCHAR2 50 No No Active Definition of morphology code 35 COLONYLENGTH NUMBER 22 No No 38 8 Active Colony Length (cm) 36 OLDDEAD NUMBER 22 No No 5 0 Active Percentage of old dead coral 37 RECENTDEAD NUMBER 22 No No 5 0 Active Percentage of recently dead coral 38 RECENT_GENERAL_CAUSE_CODE VARCHAR2 4 No No Active General cause code of recently dead coral captured in RECENTDEAD field 39 RECENT_SPECIFIC_CAUSE_CODE VARCHAR2 4 No No Active Specific cause code of recently dead coral captured in RECENTDEAD field 40 RECENTDEAD_2 NUMBER 22 No No 5 0 Active Percentage of recently dead coral 41 RECENT_GENERAL_CAUSE_CODE_2 VARCHAR2 4 No No Active General cause code of recently dead coral captured in RECENTDEAD_2 field 42 RECENT_SPECIFIC_CAUSE_CODE_2 VARCHAR2 4 No No Active Specific cause code of recently dead coral captured in RECENTDEAD_2 field 43 COND NVARCHAR2 15 No No Active Coral disease code of the observed coral colony 44 COND_DESCRIPTION NVARCHAR2 150 No No Active Coral Disease 45 EXTENT NUMBER 22 No No 38 0 Active Disease Extent (1-100) 46 SEVERITY NUMBER 22 No No 5 0 Active Disease Severity (1-5) 47 TAXONNAME NVARCHAR2 765 No No Active Taxonomic Name 48 PHYLUM VARCHAR2 255 No No Active Phylum Taxonomic Rank 49 CLASS NVARCHAR2 60 No No Active Class Taxonomic Rank 50 S_ORDER VARCHAR2 255 No No Active Order Taxonomic Rank 51 FAMILY VARCHAR2 255 No No Active Family Taxonomic Rank 52 GENUS_CODE NVARCHAR2 12 No No Active 4-letter genus code 53 GENUS NVARCHAR2 300 No No Active Genus Taxonomic Rank 54 SCIENTIFIC_NAME VARCHAR2 255 No No Active Scientific Name Taxonomic Rank 55 RANK VARCHAR2 20 No No Active Rank from WoRMS 56 APHIAID VARCHAR2 20 No No Active Aphia ID from WoRMS gov.noaa.nmfs.inport:46826 Annette DesRochers 2017-08-07T17:19:30 SysAdmin InPortAdmin 2022-08-09T17:11:31 2020-01-13 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 2020-01-13 1 Year 2021-01-13