36179 V0_CORAL_OBS_E_PRESENCE Entity Published / External 36164 National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Coral Demography (Adult and Juvenile Corals) across the Hawaiian Archipelago since 2013 Data Set Completed Coral belt observations (presence) Updated Feb 2019 to reflect addition of monument-led surveys 2014 and 2015. Presence surveys do not apply to PMNM-led missions in 2014 or 2015. Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3). Data View Yes GISDAT Coral belt observations (presence) 1 ROUNDID NUMBER 22 Yes No 28 0 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 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 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_CODE VARCHAR2 50 No No Active 3-letter code for HABITAT_TYPE. 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). 13 SITE_MAX_DEPTH NUMBER 22 No No 5 0 Active Maximum SITE depth (ft). 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) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m 14 SITEVISITID NUMBER 22 Yes No Active Unique identifier created each time a SITE is surveyed on a DATE_. 14 DEPTH_CODE VARCHAR2 1 No No Active Single-letter code for DEPTH_BIN (S, M, D). 15 DATE_ DATE 7 Yes No Active Local date the survey was conducted. 16 OBS_DAY NUMBER 22 No No Active Numeric day the survey was conducted (DATE_). 17 OBS_MONTH NUMBER 22 No No 38 Active Numeric month the survey was conducted (DATE_). 18 OBS_YEAR NUMBER 22 No No Active 4-digit year the survey was conducted (DATE_). 23 NO_SURVEY_YN NUMBER 22 No No Active Flag (-1) to indicate transect was not surveyed (Added Sept. 2014). 23 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). 24 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. 25 METHODNAME NVARCHAR2 150 Yes No Active References the coral belt survey method. 26 TRANSECT NUMBER 22 Yes No 38 0 Active Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset 26 TRANSECTID NUMBER No No Active Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). 26 BELTTRANSECTRUN NUMBER 22 Yes No 38 0 Active Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT. 26 TRANSECTNUM NUMBER No No Active Unique identifier for each transect surveyed within a SITE. 26 SEGMENTID NUMBER No No Active Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018). 27 SEGMENT NVARCHAR2 150 No No Active Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart. 28 SEGLENGTH NUMBER 22 No No 28 8 Active Segment length (m). 29 CORL_YN NUMBER No No Active Flag (-1) to indicate presence of corallimorph on transect. 29 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). 29 SEGWIDTH NUMBER 22 No No 38 8 Active Segment width (m). 30 CORALLIMORPH_YN NUMERIC No No Active Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015). 31 CLADIELLA_YN NUMBER 22 No No Active Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014) 32 DENDRONEPHTHYA_YN NUMBER 22 No No Active Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014). 33 DISTICHOPORA_YN NUMERIC No No Active Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015). 34 LOBOPHYTUM_YN NUMBER 22 No No 38 Active Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014). 35 OCTO_YN NUMERIC No No Active Flag (-1) to indicate presence of octocoral on transect (added 2015). 36 PACHYCLAVULARIA_YN NUMBER 22 No No Active Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014). 37 PALYTHOA_YN NUMBER 22 No No 38 Active Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014). 38 PROTOPALYTHOA_YN NUMBER 22 No No Active Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014). 39 SARCOPHYTON_YN NUMBER 22 No No 38 Active Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) 40 SARCOTHELIA_YN NUMERIC No No Active Flag (-1) to indicate presence of sarcothelia on transect (added 2017). 41 SINULARIA_YN NUMBER 22 No No Active Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014). 42 SOFT_YN NUMERIC No No Active Flag (-1) to indicate presence of soft coral on transect (added 2015). 43 STEREONEPHTHYA_YN NUMBER 22 No No 38 Active Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014). 44 STYLASTER_YN NUMERIC No No Active Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015). 45 WIRECORAL_YN NUMBER 22 No No Active Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014). 46 ZOANTHUS_YN NUMBER 22 No No 38 Active Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014). gov.noaa.nmfs.inport:36179 Troy Kanemura 2016-12-31T00:51:29 Lori Luers 2022-10-20T01:21:11 2022-10-20 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-11-24 1 Year 2021-11-24