30772 V0_CORAL_OBS_E Entity Published / External 30771 Benthic Surveys in Vatia, American Samoa: comprehensive assessment of coral demography (adult and juvenile corals) from belt transect surveys in 2015 and 2020 Data Set Completed Coral belt observations (adult) Starting in 2018, presence/absence data collection for zoanthids and other non-scleractinian corals was discontinued Data View Yes GISDAT Coral belt observations (adult) 1 REGION VARCHAR2 No No Active Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table No domain defined. 2 ROUNDID NUMBER No No Active Unique identifier for ROUND record. 3 MISSIONID VARCHAR2 No No Active Mission identifier. 4 REGION_NAME VARCHAR2 No No Active One of the five Pacific Island regions CRED surveys No domain defined. 5 ISLAND NVARCHAR2 No No Active Island or Atoll surveyed No domain defined. 6 SUB_ISLAND VARCHAR2 No No Active The name of the island sub-region surveyed 7 ISLANDCODE NVARCHAR2 No No Active 3-letter island code No domain defined. 8 SECTOR Unknown No No Active This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012) No domain defined. 9 SITE NVARCHAR2 No No Active The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number No domain defined. 10 LATITUDE NUMBER No No Active Latitude in decimal degrees, WGS84, for the given site No domain defined. 11 LONGITUDE NUMBER No No Active Longitude in decimal degrees, WGS84 for the given site No domain defined. 12 REEF_ZONE_CODE VARCHAR2 No No Active 3-letter reef zone code No domain defined. 13 REEF_ZONE NVARCHAR2 No No Active The reef zone for the given site (Forereef, Backreef or Lagoon) No domain defined. 14 DEPTH_BIN NVARCHAR2 No No Active Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site No domain defined. 15 DEPTH_CODE VARCHAR2 No No Active Depth zone code No domain defined. 16 EXCLUDE_FLAG Unknown No No Active Flag to indicate whether site should be excluded from analysis No domain defined. 17 SITE_MIN_DEPTH NUMBER No No Active Minimum SITE depth (ft). 18 SITE_MAX_DEPTH NUMBER No No Active Maximum SITE depth (ft). 19 SITEVISITID NUMBER No No Active Unique Identifier for SITE_VISIT record No domain defined. 20 DATE_ DATE No No Active Date the survey was conducted No domain defined. 21 OBS_DAY NUMBER No No Active Observation Day No domain defined. 22 OBS_MONTH NUMBER No No Active Observation Month No domain defined. 23 OBS_YEAR NUMBER No No Active Observation Year No domain defined. 24 HABITAT_CODE VARCHAR2 No No Active Habitat code No domain defined. 25 HABITAT_TYPE VARCHAR2 No No Active Habitat type No domain defined. 26 COMMENTS Unknown No No Active General observation comments No domain defined. 27 DIVER NVARCHAR2 No No Active Initials of diver conducting survey No domain defined. 28 PHOTOS_TAKEN NUMBER No No Active Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). 29 BELTTRANSECTRUN NUMBER No No Active Primary key for CORAL_BELT_TRANSECTRUN No domain defined. 30 METHODNAME NVARCHAR2 No No Active References the coral belt survey method No domain defined. 31 TRANSECT NUMBER No No Active Transect Number. Replaced in 2018 for TRANSECTID No domain defined. 32 TRANSECTID NUMBER No No Active Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). 33 TRANSECTNUM NUMBER No No Active Unique identifier for each transect surveyed within a SITE. 34 TRANWIDTH NUMBER No No Active Transect Length (m) No domain defined. 35 TRANLENGTH NUMBER No No Active Transect Width (m) No domain defined. 36 SEGMENT NVARCHAR2 No No Active Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018). No domain defined. 37 SEGMENTID NUMBER No No Active Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018). 38 SEGLENGTH NUMBER No No Active Segment length (m). 39 SEGWIDTH NUMBER No No Active Segment width (m). 40 MINDEPTH NUMBER No No Active Minimum Depth of the transect (in meters) No domain defined. 41 MAXDEPTH NUMBER No No Active Maximum Depth of the transect (in meters) No domain defined. 42 CLADIELLA_YN NUMBER No No Active Flag to indicate presence of cladiella on transect (Added Sept. 2014) No domain defined. 43 DENDRONEPHTHYA_YN NUMBER No No Active Flag to indicate presence of dendronephthya on transect (Added Sept. 2014) No domain defined. 44 LOBOPHYTUM_YN NUMBER No No Active Flag to indicate presence of lobophytum on transect (Added Sept. 2014) No domain defined. 45 PACHYCLAVULARIA_YN NUMBER No No Active Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014) No domain defined. 46 SARCOPHYTON_YN NUMBER No No Active Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) No domain defined. 47 SINULARIA_YN NUMBER No No Active Flag to indicate presence of sinularia on transect (Added Sept. 2014) No domain defined. 48 STEREONEPHTHYA_YN NUMBER No No Active Flag to indicate presence of stereonephthya on transect (Added Sept. 2014) No domain defined. 49 WIRECORAL_YN NUMBER No No Active Flag to indicate presence of wire coral on transect (Added Sept. 2014) No domain defined. 50 PALYTHOA_YN NUMBER No No Active Flag to indicate presence of palythoa on transect (Added Sept. 2014) No domain defined. 51 PROTOPALYTHOA_YN NUMBER No No Active Flag to indicate presence of protopalythoa on transect (Added Sept. 2014) No domain defined. 52 ZOANTHUS_YN NUMBER No No Active Flag to indicate presence of zoanthus on transect (Added Sept. 2014) No domain defined. 53 NO_SURVEY_YN NUMBER No No Active Flag to indicate transect was not surveyed (Added Sept. 2014) No domain defined. 54 NO_COLONY_OBSERVED NUMBER No No Active Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). 55 COLONYID NUMBER No No Active Colony Identifier No domain defined. 56 FRAGMENT_YN NUMBER No No Active Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018). 57 SPECIES Unknown No No Active Species observed No domain defined. 58 MORPH_CODE VARCHAR2 No No Active 4-letter morphology code No domain defined. 59 MORPHOLOGY VARCHAR2 No No Active Definition of morphology code No domain defined. 60 COLONYLENGTH NUMBER No No Active Colony Length (cm) No domain defined. 61 OLDDEAD NUMBER No No Active Percentage of old dead coral No domain defined. 62 RECENTDEAD NUMBER No No Active Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1. No domain defined. 63 RECENT_GENERAL_CAUSE_CODE VARCHAR2 No No Active General cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_GENERAL_CAUSE_CODE_1. No domain defined. 64 RECENT_SPECIFIC_CAUSE_CODE VARCHAR2 No No Active Specific cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_SPECIFIC_CAUSE_CODE_1. 65 RECENTDEAD_1 NUMBER No No Active Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD. 66 RECENT_GENERAL_CAUSE_CODE_1 VARCHAR2 No No Active Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE. 67 RECENT_GENERAL_CAUSE_DESC_1 TEXT No No Active General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. 68 RECENT_SPECIFIC_CAUSE_CODE_1 VARCHAR2 No No Active Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE. 69 RECENT_SPECIFIC_CAUSE_DESC_1 TEXT No No Active Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. 70 RECENTDEAD_2 NUMBER No No Active Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0). 71 RECENT_GENERAL_CAUSE_CODE_2 VARCHAR2 No No Active General cause code of recently dead coral captured in RECENTDEAD_2 field 72 RECENT_GENERAL_CAUSE_DESC_2 TEXT No No Active General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0. 73 RECENT_SPECIFIC_CAUSE_CODE_2 VARCHAR2 No No Active Specific cause code of recently dead coral captured in RECENTDEAD_2 field 74 RECENT_SPECIFIC_CAUSE_DESC_2 TEXT No No Active Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0. 75 RECENTDEAD_3 NUMBER No No Active Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0). 76 RECENT_GENERAL_CAUSE_CODE_3 VARCHAR2 No No Active Code for RECENT_GENERAL_CAUSE_DESC_3. 77 RECENT_GENERAL_CAUSE_DESC_3 TEXT No No Active General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. 78 RECENT_SPECIFIC_CAUSE_CODE_3 VARCHAR2 No No Active Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. 79 RECENT_SPECIFIC_CAUSE_DESC_3 TEXT No No Active Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. 80 COND NVARCHAR2 No No Active Coral disease code of the observed coral colony. Replaced by CONDITION_1 81 COND_DESCRIPTION NVARCHAR2 No No Active Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Replaced by CONDITION_1_DESC. 82 EXTENT NUMBER No No Active Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. Replaced by EXTENT_1 83 SEVERITY NUMBER No No Active Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Replaced by SEVERITY_1 84 CONDITION_1 NVARCHAR2 No No Active Code for CONDITION_1_DESC. Replaces COND 85 CONDITION_1_DESC NVARCHAR2 No No Active Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Replaces COND_DESCRIPTION. 86 EXTENT_1 NUMBER No No Active Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. Replaces EXTENT 87 SEVERITY_1 NUMBER No No Active Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. Replaces SEVERITY. 88 CONDITION_2 NVARCHAR2 No No Active Code for CONDITION_2_DESC. 89 CONDITION_2_DESC NVARCHAR2 No No Active Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. 90 EXTENT_2 NUMBER No No Active Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. 91 SEVERITY_2 NUMBER No No Active Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. 92 CONDITION_3 NVARCHAR2 No No Active Code for CONDITION_1_DESC. 93 CONDITION_3_DESC NVARCHAR2 No No Active Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. 94 EXTENT_3 NUMBER No No Active Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. 95 SEVERITY_3 NUMBER No No Active Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. 96 TAXONCODE NVARCHAR2 No No Active 4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). 97 TAXONNAME NVARCHAR2 No No Active Taxonomic Name 98 RANK VARCHAR2 No No Active Rank from WoRMS 99 PHYLUM VARCHAR2 No No Active Phylum Taxonomic Rank 100 CLASS NVARCHAR2 No No Active Class Taxonomic Rank 101 S_ORDER VARCHAR2 No No Active Order Taxonomic Rank 102 FAMILY VARCHAR2 No No Active Family Taxonomic Rank 103 GENUS_CODE NVARCHAR2 No No Active 4-letter genus code 104 GENUS NVARCHAR2 No No Active Genus Taxonomic Rank 105 SCIENTIFIC_NAME VARCHAR2 No No Active Scientific Name Taxonomic Rank 106 APHIAID VARCHAR2 No No Active Aphia ID from WoRMS gov.noaa.nmfs.inport:30772 Annette DesRochers 2016-02-16T19:10:18 SysAdmin InPortAdmin 2022-08-09T17:11:00 2021-09-01 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-09-01 1 Year 2022-09-01