35994 ESD_FISH_REA_SPC_DataDict Entity Published / External 24447 National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Reef Fish, including Benthic Estimate Data of the Hawaiian Archipelago since 2013 Data Set Completed Data dictionary for the NCRMP Fish REA SPC datasets Data Table Yes Data dictionary for NCRMP Fish REA SPC dataset. Starting in 2024, benthic estimate data such as substrate height, urchins, and benthic taxa are not collected during fish surveys, and instead are extracted from benthic imagery collected at the site. 1 OBJECTID NUMBER 22 Yes No 38 0 Active Unique identifier for fish REA observations. 2 ROUNDID NUMBER 22 Yes No 28 0 Active Unique Identifier for ROUND record. 3 MISSIONID VARCHAR2 30 Yes No Active Mission Identifier. 4 REGION_NAME VARCHAR2 30 No No Active The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. 5 ISLAND NVARCHAR2 150 No No Active Island or Atoll surveyed in the Pacific Island region (REGION_NAME). 6 SITE NVARCHAR2 150 Yes No Active The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-4 digit site number. 7 LATITUDE NUMBER 22 No No 38 Active Latitude in decimal degrees, WGS84, for the given SITE as recorded by divers on the datasheets. 8 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84 for the given SITE as recorded by divers on the datasheets. 9 REEF_ZONE NVARCHAR2 150 No No Active The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). 10 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. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m. 11 SITEVISITID NUMBER 22 Yes No 38 Active Unique identifier created each time a SITE is surveyed on a DATE_. 12 DATE_ DATE 7 Yes No Active Local date the survey was conducted. 13 OBS_YEAR NUMBER 22 No No 38 Active 4-digit year the survey was conducted (DATE_). 14 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey. 15 REPLICATEID NUMBER 22 Yes No 38 0 Active Unique identifier for the replicate sample within a Fish REA survey. 16 REP NVARCHAR2 150 No No Active Letter associated to replicate (A, B, C, or D). 17 METHOD NVARCHAR2 150 Yes No Active Fish method employed: stationary point count (nSPC). 18 PHOTOGRAPHER NUMBER 22 No No 5 0 Active Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value -1 indicates the photographer. 19 TRAINING_YN NUMBER 22 No No Active Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training. 20 DEPTH NUMBER 22 No No 38 Active Depth of survey area in meters. Depths usually within 0-30 m. 21 SURVEY_RADIUS_M NUMBER 22 No No Active Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder'). 22 HARD_CORAL NUMBER 22 No No Active Hard coral cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 23 SOFT_CORAL NUMBER 22 No No 38 Active Soft coral cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 24 MA NUMBER 22 No No Active Macroalgae cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 25 CCA NUMBER 22 No No 38 Active Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 26 TA NUMBER 22 No No 38 Active Turf algae cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 27 SAND NUMBER 22 No No 38 Active Sand cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 28 TUNICATE NUMBER 22 No No 38 Active Tunicate cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 29 ZOANTHID NUMBER 22 No No 38 Active Zoanthid cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 30 CORALLIMORPH NUMBER 22 No No 38 Active Corallimorph cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 31 CLAM NUMBER 22 No No 38 Active Clam cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 32 CYANO NUMBER 22 No No 38 Active Cyanobacteria cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 33 SPONGE NUMBER 22 No No 38 Active Sponge cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. 34 OTHER NUMBER 22 No No Active Other benthic composition value (0-100%). Sum of benthic composition categories equals 100. Turf algae, tunicates, zoanthids, corallimorphs, clams, cyanobacteria, soft coral, and sponges are pooled into this category as of 2016 surveys. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 35 OTHER_TYPE VARCHAR2 20 No No Active Other benthic composition type. No longer collected as of 2016 surveys. 36 HABITAT_CODE VARCHAR2 50 No No Active Code for HABITAT_TYPE. 37 HABITAT_TYPE VARCHAR2 50 No No Active Description of the habitat type (e.g., Aggregate Patch Reef, Pavement, Spur and Groove, Rock/Boulder). 38 CURRENT_STRENGTH VARCHAR2 20 No No Active Current Strength (None, Slight, Moderate, High). 39 VISIBILITY NUMBER 22 No No 38 8 Active Visibility measured in meters. 40 MIN_DEPTH NUMBER 22 No No Active Minimum depth of the diver’s survey cylinder in meters. 41 MAX_DEPTH NUMBER 22 No No 38 Active Maximum depth of the diver’s survey cylinder in meters. 42 SUBSTRATE_HEIGHT_0 NUMBER 22 No No 38 8 Active Proportion of survey area between 0-20 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 43 SUBSTRATE_HEIGHT_20 NUMBER 22 No No 38 8 Active Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 44 SUBSTRATE_HEIGHT_50 NUMBER 22 No No 38 8 Active Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 45 SUBSTRATE_HEIGHT_100 NUMBER 22 No No 38 8 Active Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 46 SUBSTRATE_HEIGHT_150 NUMBER 22 No No 38 8 Active Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 47 MAX_HEIGHT NUMBER 22 No No Active Highest elevation point in SPC cylinder measured in meters. 48 URCHIN_DACOR VARCHAR2 1 No No Active Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 49 BORING_URCHIN_DACOR VARCHAR2 1 No No Active Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. 50 SPECIES NVARCHAR2 150 Yes No Active 4-letter code for TAXONNAME. Required. 51 TAXONNAME NVARCHAR2 765 Yes No Active Scientific name of observed organism to the finest taxonomic resolution that divers can identify a fish to, usually to species (see RANK). Required. 52 COMMONNAME NVARCHAR2 150 No No Active Common name (from FishBase). 53 COMMONFAMILYALL NVARCHAR2 150 No No Active Common name of all families. 54 FAMILY NVARCHAR2 150 No No Active Taxonomic classification: Family of observed organism (TAXONNAME). 55 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). 56 RANK VARCHAR2 20 No No Active Lowest defined rank in taxonomic hierarchy. 57 TROPHIC NVARCHAR2 150 No No Active Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Par (parasite), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), X (if unidentified fish), Z (zooplantivore). 58 TROPHIC_MONREP NVARCHAR2 150 No No Active Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore). 59 LW_A NUMBER 22 No No 38 8 Active Parameter "a" used in length-weight calculations. 60 LW_B NUMBER 22 No No 28 8 Active Parameter "b" used in length-weight calculations. 61 LMAX NUMBER 22 No No 28 8 Active Maximum length of the fish published in literature. 62 LENGTH_CONVERSION_FACTOR NUMBER 22 No No 28 8 Active Factor to convert length as TOTAL LENGTH to get it to right form (standard [SL], fork [FL], or total length [TL]) for available length weight A and B parameters for this species. 63 COUNT NUMBER 22 No No 5 0 Active Number of fish observed during survey. 64 SIZE_ NUMBER 22 No No 38 8 Active Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip. 65 OBS_TYPE VARCHAR2 1 No No Active Code for OBS_DESC. 66 OBS_DESC VARCHAR2 20 Yes No Active The type of observation made during the fish survey (Instantaneous, non-instantaneous, after 5 minutes, after 10 minutes, presence). See the Reef Fish Survey Protocol for an explanation of the observation types. gov.noaa.nmfs.inport:35994 Troy Kanemura 2016-12-14T20:24:15 Lori Luers 2025-01-15T18:31:30 2025-01-15 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-06-18 1 Year 2021-06-18