36101 V0_TOPOGRAPHIC_COMPLEXITY Entity Published / External 36099 National Coral Reef Monitoring Program: Benthic Complexity and Urchin Abundance at Climate Stations in American Samoa from 2015 to 2018 Data Set Completed Foundational view for benthic complexity and urchin abundance at climate stations Data View Yes GISDAT Foundational view for benthic complexity and urchin abundance at climate stations 1 ROUNDID NUMBER 22 Yes No 28 0 Active Unique identifier for ROUND record. NUMBER 2 MISSIONID VARCHAR2 30 Yes No Active Mission identifier. VARCHAR2 3 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. VARCHAR2 4 ISLAND NVARCHAR2 150 No No Active Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). NVARCHAR2 5 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. NVARCHAR2 6 LATITUDE NUMBER 22 No No 38 Active Latitude in decimal degrees, WGS84, for the given SITE. NUMBER 7 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84 for the given SITE. NUMBER 8 REEF_ZONE NVARCHAR2 150 No No Active The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). NVARCHAR2 9 DEPTH_BIN NVARCHAR2 60 No No Active Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m NVARCHAR2 10 SITEVISITID NUMBER 22 Yes No 38 Active Unique identifier created each time a SITE is surveyed on a DATE_. NUMBER 11 DATE_ DATE 7 Yes No Active Local date the survey was conducted. DATE 12 OBS_YEAR NUMBER 22 No No 38 Active 4-digit year the survey was conducted (DATE_). NUMBER 13 TRANSECT VARCHAR2 28 No No Active Type of transect (box or line). Deprecated as of 2017 surveys. VARCHAR2 14 PARALLEL_ NUMBER 22 No No 38 0 Active Parallel bearing of transect. NUMBER 15 DOWNSLOPE NUMBER 22 No No 26 0 Active Downslope bearing of transect. Climate sites set up in 'alongshore' lines (usually a result of suitable benthic substrate availability) will not have a down slope heading. NUMBER 16 SUBSTRATE_HEIGHT_0 NUMBER 22 No No 26 0 Active Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 0-20 cm elevation. Total frequency for all 5 substrate height bins should equal 30. NUMBER 17 SUBSTRATE_HEIGHT_20 NUMBER 22 No No 26 0 Active Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 20-50 cm elevation. Total frequency for all 5 substrate height bins should equal 30. NUMBER 18 SUBSTRATE_HEIGHT_50 NUMBER 22 No No 26 0 Active Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 50-100 cm elevation. Total frequency for all 5 substrate height bins should equal 30. NUMBER 19 SUBSTRATE_HEIGHT_100 NUMBER 22 No No 26 0 Active Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 100-150 cm elevation. Total frequency for all 5 substrate height bins should equal 30. NUMBER 20 SUBSTRATE_HEIGHT_150 NUMBER 22 No No 26 0 Active Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is >150 cm elevation. Total frequency for all 5 substrate height bins should equal 30. NUMBER 21 MIN_DEPTH NUMBER 22 No No 26 0 Active Shallowest point in the NCRMP climate station (SITE) in feet. NUMBER 22 MAX_DEPTH NUMBER 22 No No 26 0 Active Deepest point in the NCRMP climate station (SITE) in feet. NUMBER 23 MAX_VERTICAL_RELIEF NUMBER 22 No No 26 0 Active Height of tallest reef structure present within the NCRMP climate station (SITE) in centimeters. NUMBER 24 FREE_URCHIN_DACOR VARCHAR2 26 No No Active Free urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 101-999; A: 51-100; C: 21-50; O: 6-20; R: 0-5. VARCHAR2 25 BORING_URCHIN_DACOR VARCHAR2 26 No No Active Boring urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 501-999; A: 251-500; C: 101-250; O: 26-100; R: 0-25. VARCHAR2 gov.noaa.nmfs.inport:36101 Annette DesRochers 2016-12-21T21:29:57 SysAdmin InPortAdmin 2022-08-09T17:11:16 2017-01-24 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-01-24 1 Year 2018-01-24