36177 V0_CORAL_OBS_F Entity Published / External 36166 National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Coral Demography (Adult and Juvenile Corals) across the Pacific Remote Island Areas from 2014 to 2018 Data Set Completed Coral belt observations (juvenile) Updated Jan 2019 to reflect changes made during 2018 surveys Data View Yes GISDAT Coral belt observations (juvenile) 1 ROUNDID NUMERIC No No Active Unique Identifier for ROUND record. 2 MISSIONID VARCHAR2 30 Yes No Active Mission identifier. 3 REGION VARCHAR2 20 Yes No Active Code for REGION_NAME. 4 REGION_NAME VARCHAR2 30 No No Active The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. 5 ISLANDCODE NVARCHAR2 15 No No Active 3-letter code for ISLAND. 6 ISLAND NVARCHAR2 150 No No Active Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). 7 SITE NVARCHAR2 150 Yes No Active The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. 8 LATITUDE NUMBER 22 No No Active Latitude in decimal degrees, WGS84, for the given SITE. 9 LONGITUDE NUMBER 22 No No 38 Active Longitude in decimal degrees, WGS84 for the given SITE. 10 REEF_ZONE_CODE VARCHAR2 3 Yes No Active 3-letter code for REEF_ZONE. 11 REEF_ZONE NVARCHAR2 150 No No Active The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). 12 HABITAT_TYPE VARCHAR2 30 No No Active Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. 12 SITE_MIN_DEPTH NUMBER 22 No No 5 0 Active Minimum SITE depth (ft). 12 HABITAT_CODE VARCHAR2 50 No No Active 3-letter code for HABITAT_TYPE. 13 SITE_MAX_DEPTH NUMBER 22 No No 5 0 Active Maximum SITE depth (ft). 14 DEPTH_CODE VARCHAR2 1 No No Active Single-letter code for DEPTH_BIN (S, M, D). 14 DEPTH_BIN NVARCHAR2 60 No No Active Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m 14 SITEVISITID NUMBER 22 Yes No 38 Active Unique identifier created each time a SITE is surveyed on a DATE_. 15 DATE_ DATE 7 Yes No Active Local date the survey was conducted. 16 OBS_DAY NUMBER 22 No No 38 Active Numeric day the survey was conducted (DATE_). 17 OBS_MONTH NUMBER 22 No No Active Numeric month the survey was conducted (DATE_). 18 OBS_YEAR NUMBER 22 No No 38 Active 4-digit year the survey was conducted (DATE_). 22 PHOTOS_TAKEN NUMERIC No No Active Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018. 22 NO_SURVEY_YN NUMERIC No No Active Flag to indicate transect was not surveyed (-1). Added Sept. 2014. 23 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. 23 METHODNAME NVARCHAR2 150 Yes No Active References the coral belt survey method. NULL if NO_SURVEY_YN = -1. 24 BELTTRANSECTRUN NUMBER 22 Yes No 28 0 Active Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. 24 TRANSECTID NUMERIC No No Active Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. 26 TRANSECT NUMBER 22 Yes No 38 0 Active Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. 26 TRANSECTNUM NUMERIC No No Active Transect number (1-2). Added in 2018, replaces TRANSECT. 27 SEGMENTID NUMERIC No No Active Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1. 28 SEGMENT NVARCHAR2 150 No No Active Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart. 29 SEGLENGTH NUMBER 22 No No 28 8 Active Segment length (m). 29 SEGWIDTH NUMBER 22 No No 38 8 Active Segment width (m). 30 NO_COLONY_OBSERVED NUMERIC No No Active Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. 31 COLONYWIDTH NUMBER 22 No No 28 8 Active Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018. 31 COLONYLENGTH NUMBER 22 No No 38 8 Active Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value. 31 COLONYID NUMBER 22 No No 28 0 Active Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. 32 MORPH_CODE VARCHAR2 5 No No Active Code for MORPHOLOGY. 33 MORPHOLOGY VARCHAR2 50 No No Active Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. 34 SPECIES TEXT No No Active 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). 34 TAXONCODE NVARCHAR2 150 No No Active 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). 35 TAXONNAME NVARCHAR2 765 No No Active Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -1. 36 RANK VARCHAR2 20 No No Active Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'. 37 PHYLUM VARCHAR2 255 No No Active Taxonomic classification: Phylum of observed organism (TAXONNAME). 38 CLASS NVARCHAR2 60 No No Active Taxonomic classification: Class of observed organism (TAXONNAME). 39 S_ORDER VARCHAR2 255 No No Active Taxonomic classification: Order of observed organism (TAXONNAME). 40 FAMILY VARCHAR2 255 No No Active Taxonomic classification: Family of observed organism (TAXONNAME). 41 GENUS_CODE NVARCHAR2 12 No No Active 4-letter code for GENUS. 42 GENUS NVARCHAR2 300 No No Active Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae. 43 SCIENTIFIC_NAME VARCHAR2 255 No No Active Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). 45 APHIAID VARCHAR2 20 No No Active Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS. gov.noaa.nmfs.inport:36177 Troy Kanemura 2016-12-31T00:34:39 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-06-21 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-06-21 1 Year 2018-06-21