68418 CarbBudget SPC DataDictionary Entity Published / External 67804 Benthic, urchin, and fish observation data collected utilizing multiple methodologies for coral reef carbonate budget assessments in 2021 in O'ahu, in the Mariana Archipelago in 2022, and in American Samoa in 2023 Data Set Completed Data dictionary for fish SPC dataset Data Table Yes Column definitions for fish SPC dataset. Depending on the team that conducted the survey, benthic data may or may not be included in this dataset; null values may occur for columns: HARD_CORAL MA CCA SAND OTHER MIN_DEPTH MAX_DEPTH SUBSTRATE MAX_HEIGHT URCHIN_DACOR BORING_URCHIN_DACOR Updated Date format in 2023 to follow convention YYYY-MM-DD 1 REGION VARCHAR2 30 No No Active The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. 2 REGION_CODE VARCHAR2 30 No No Active Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI). 3 YEAR NUMBER 22 No No 38 Active 4-digit year the survey was conducted. 4 CRUISE_ID VARCHAR2 30 Yes No Active Mission Identifier. 5 LOCATION NVARCHAR2 150 No No Active Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). 6 LOCATIONCODE VARCHAR2 30 No No Active 3-Letter unique code for LOCATION. 7 REA_SITEID 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. 8 OCC_SITEID VARCHAR2 No No Active An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. 9 OCC_SITENAME VARCHAR2 No No Active Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed. 10 LATITUDE NUMBER 22 No No 38 Active Latitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets. 11 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets. 12 LOCALDATE DATE 7 Yes No Active Local date the survey was conducted as YYYY-MM-DD 13 CB_METHOD NVARCHAR2 150 Yes No Active Methodology used for collection of fish data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 5 x 30m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Stationary Point Count (nSPC): In-water data collected along two 15m diameter cylinders within a 30m transect. 14 OBJECTID NUMBER 22 Yes No 38 0 Active Unique identifier for fish REA observations. 15 ROUNDID NUMBER 22 Yes No 28 0 Active Unique Identifier for ROUND record. 16 REEF_ZONE NVARCHAR2 150 No No Active The zone for the given REA_SITEID (Forereef, Backreef, Protected Slope, Lagoon). 17 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. 18 SITEVISITID NUMBER 22 Yes No 38 Active Unique identifier created each time a REA_SITEID is surveyed on a LOCALDATE. 19 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey. 20 REPLICATEID NUMBER 22 Yes No 38 0 Active Unique identifier for the replicate sample within a Fish REA survey. 21 REP NVARCHAR2 150 No No Active Letter associated to replicate (A, B, C, or D). 22 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. 23 TRAINING_YN NUMBER 22 No No Active Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training. 24 DEPTH NUMBER 22 No No 38 Active Depth of survey area in meters. Depths usually within 0-30 m. 25 SURVEY_RADIUS_M NUMBER 22 No No Active Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder'). 26 HARD_CORAL NUMBER 22 No No Active Hard coral cover (0-100%). Sum of benthic composition categories equals 100. 27 MA NUMBER 22 No No Active Macroalgae cover (0-100%). Sum of benthic composition categories equals 100. 28 CCA NUMBER 22 No No 38 Active Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100. 29 SAND NUMBER 22 No No 38 Active Sand cover (0-100%). Sum of benthic composition categories equals 100. 30 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. 31 HABITAT_CODE VARCHAR2 50 No No Active Code for HABITAT_TYPE. 32 HABITAT_TYPE VARCHAR2 50 No No Active Description of the habitat type (e.g., Aggregate Patch Reef, Pavement, Spur and Groove, Rock/Boulder). 33 CURRENT_STRENGTH VARCHAR2 20 No No Active Current Strength (None, Slight, Moderate, High). 34 VISIBILITY NUMBER 22 No No 38 8 Active Visibility measured in meters. 35 MIN_DEPTH NUMBER 22 No No Active Minimum depth of the diver's survey cylinder in meters. 36 MAX_DEPTH NUMBER 22 No No Active Maximum depth of the diver's survey cylinder in meters. 37 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. 38 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. 39 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. 40 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. 41 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. 42 MAX_HEIGHT NUMBER 22 No No Active Highest elevation point in SPC cylinder measured in meters. 43 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). 44 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). 45 TAXON_CODE NVARCHAR2 150 Yes No Active 4-letter code for TAXON_NAME. Required. 46 TAXON_NAME 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. 47 COMMONNAME NVARCHAR2 150 No No Active Common name (from FishBase). 48 COMMONFAMILYALL NVARCHAR2 150 No No Active Common name of all families. 49 FAMILY NVARCHAR2 150 No No Active Taxonomic classification: Family of observed organism (TAXON_NAME). 50 SCIENTIFIC_NAME VARCHAR2 255 No No Active Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXON_NAME). If NULL, organism not identified to species taxonomic level (see RANK). 51 RANK VARCHAR2 20 No No Active Lowest defined rank in taxonomic hierarchy. 52 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). 53 TROPHIC_MONREP NVARCHAR2 150 No No Active Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore). 54 LW_A NUMBER 22 No No 38 8 Active Parameter "a" used in length-weight calculations. 55 LW_B NUMBER 22 No No 28 8 Active Parameter "b" used in length-weight calculations. 56 LMAX NUMBER 22 No No 28 8 Active Maximum length of the fish published in literature. 57 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 58 COUNT NUMBER 22 No No 5 0 Active Number of fish observed during survey. 59 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. 60 OBS_TYPE VARCHAR2 1 No No Active Code for OBS_DESC. 61 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:68418 Lori Luers 2022-11-15T03:20:17 Lori Luers 2025-03-24T22:37:45 2025-03-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 1 Year