36103 V0_TOPOGRAPHIC_COMPLEXITY Entity Published / External 25251 National Coral Reef Monitoring Program: Benthic Complexity and Urchin Abundance at Climate Stations of the Mariana Archipelago since 2014 Data Set Completed Foundational view for benthic complexity and urchin abundance at climate stations Loaded by batch 9613, 12-21-2016 21:29 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 2 MISSIONID VARCHAR2 30 Yes No Active Mission Identifier 3 REGION_NAME VARCHAR2 30 No No Active One of the five Pacific Island regions CRED surveys 4 ISLAND NVARCHAR2 150 No No Active Island or Atoll surveyed 5 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 6 LATITUDE NUMBER 22 No No 38 Active Site latitude 7 LONGITUDE NUMBER 22 No No Active Site longitude 8 REEF_ZONE NVARCHAR2 150 No No Active The reef zone for the given site (Forereef, Backreef or Lagoon) 9 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 10 SITEVISITID NUMBER 22 Yes No 38 Active Unique identifier for SITE_VISIT record 11 DATE_ DATE 7 Yes No Active Date the survey was conducted 12 OBS_YEAR NUMBER 22 No No 38 Active Year the survey was conducted 13 TRANSECT VARCHAR2 28 No No Active Type of transect (box or line) 14 PARALLEL_ NUMBER 22 No No 38 0 Active Parallel bearing of transect 15 DOWNSLOPE NUMBER 22 No No 26 0 Active Downslope bearing of transect 16 SUBSTRATE_HEIGHT_0 NUMBER 22 No No 26 0 Active Substrate complexity between 0cm and 20cm elevation 17 SUBSTRATE_HEIGHT_20 NUMBER 22 No No 26 0 Active Substrate complexity between 20cm and 50cm elevation 18 SUBSTRATE_HEIGHT_50 NUMBER 22 No No 26 0 Active Substrate complexity between 50cm and 100cm elevation 19 SUBSTRATE_HEIGHT_100 NUMBER 22 No No 26 0 Active Substrate complexity between 100cm and 150cm elevation 20 SUBSTRATE_HEIGHT_150 NUMBER 22 No No 26 0 Active Substrate complexity over 150cm elevation 21 MIN_DEPTH NUMBER 22 No No 26 0 Active Minimum slope depth in meters 22 MAX_DEPTH NUMBER 22 No No 26 0 Active Maximum slope depth in meters 23 MAX_VERTICAL_RELIEF NUMBER 22 No No 26 0 Active Highest elevation point measured in centimeters 24 FREE_URCHIN_DACOR VARCHAR2 26 No No Active Free Urchin DACOR 25 BORING_URCHIN_DACOR VARCHAR2 26 No No Active Boring Urchin DACOR gov.noaa.nmfs.inport:36103 Troy Kanemura 2016-12-21T21:52:43 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-10-18 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-10-18 1 Year 2018-10-18