60741 Entity Published / External 36155 National Coral Reef Monitoring Program: Benthic Cover Derived from Analysis of Benthic Images Collected during Stratified Random Surveys (StRS) across the Hawaiian Archipelago from 2013 to 2019 Data Set Completed Data Table Yes Benthic image analysis results for stratified random sites 1 ROUNDID NUMBER 22 Yes No 28 0 Active Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). 2 MISSIONID VARCHAR2 30 Yes No Active Mission Identifier. 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. 4 ISLAND NVARCHAR2 150 No No Active Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). 5 SITE NVARCHAR2 150 No No Active The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 digit site number, separated by a hyphen. 5 SITEVISITID NUMERIC No No Active IC Unique identifier created each time a SITE is surveyed on a DATE_. 6 LATITUDE NUMBER 22 No No 38 8 Active Latitude in decimal degrees, WGS84, for the given SITE. 7 LONGITUDE NUMBER 22 No No 28 8 Active Longitude in decimal degrees, WGS84 for the given SITE. 8 REEF_ZONE NVARCHAR2 150 No No Active The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope). 9 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. 10 PERM_SITE NUMBER 22 No No 5 0 Active Flag for PERMANENT SITE (-1), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none. 11 CLIMATE_STATION_YN NUMBER 22 No No Active Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at CLIMATE STATIONS, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS). 12 MIN_DEPTH NUMBER 22 No No 38 8 Active Minimum depth (measured in feet). Only recorded for coral demographic surveys. 13 MAX_DEPTH NUMBER 22 No No 28 8 Active Maximum depth (measured in feet). Only recorded for coral demographic surveys. 14 DATE_ DATE 7 Yes No Active Date the survey was conducted (d-mmm-yy). 15 IMAGE_NAME VARCHAR2 4000 No No Active Image name (SITE_YEAR_REP_PHOTOID). 16 OBS_YEAR VARCHAR2 16 No No Active 4-digit year the survey was conducted (DATE_). 17 REPLICATE VARCHAR2 4 No No Active Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. 18 PHOTOID VARCHAR2 4000 No No Active Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. 19 ANALYST VARCHAR2 20 No No Active Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot). 20 TIER_1 VARCHAR2 5 No No Active Code for CATEGORY NAME. 21 CATEGORY_NAME VARCHAR2 20 No No Active Category classification for the point on the analyzed image (X POS, Y POS). Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified. 22 TIER_2 VARCHAR2 5 No No Active Code for SUBCATEGORY NAME. 23 SUBCATEGORY_NAME VARCHAR2 50 No No Active Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.) 24 TIER_3 VARCHAR2 5 No No Active Code for GENERA NAME. 25 GENERA_NAME VARCHAR2 50 No No Active Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description. 26 X_POS NUMBER 22 No No 38 Active X position of the analyzed point on the image. 27 Y_POS NUMBER 22 No No Active Y position of the analyzed point on the image. gov.noaa.nmfs.inport:60741 Morgan Winston 2020-07-21T15:21:53 Lori Luers 2022-11-26T00:18:34 2020-08-17 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-08-17 1 Year 2021-08-17