35991 V0_FISH_REA Entity Published / External 35774 Rebreather Fish Surveys in American Samoa from 2016-04-15 to 2016-05-05 Data Set Completed Object Comments:. Fish REA foundational view Data View Yes GISDAT Object Comments:. Fish REA foundational view 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 One of the five Pacific Island regions CRED surveys 5 ISLAND NVARCHAR2 150 No No Active Island or Atoll surveyed 6 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 7 LATITUDE NUMBER 22 No No 38 Active Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees 8 LONGITUDE NUMBER 22 No No Active Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees 9 REEF_ZONE NVARCHAR2 150 No No Active The reef zone for the given site (Forereef, Backreef or 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 for SITE_VISIT record 12 DATE_ DATE 7 Yes No Active Date the survey was conducted 13 OBS_YEAR NUMBER 22 No No 38 Active Year the survey was conducted 14 DIVER NVARCHAR2 150 Yes No Active Initials of diver conducting 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: belt transect (BLT), stationary point count (SPC), or new 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 21 SURVEY_RADIUS_M NUMBER 22 No No Active Radius of survey area in meters 22 HARD_CORAL NUMBER 22 No No Active Hard Coral % 23 SOFT_CORAL NUMBER 22 No No 38 Active Soft Coral % 24 MA NUMBER 22 No No Active Macroalgae % 25 CCA NUMBER 22 No No 38 Active Crustose Coralline Algae % 26 TA NUMBER 22 No No 38 Active Turf Algae % 27 SAND NUMBER 22 No No 38 Active Sand % 28 TUNICATE NUMBER 22 No No 38 Active Tunicate % 29 ZOANTHID NUMBER 22 No No 38 Active Zoanthid % 30 CORALLIMORPH NUMBER 22 No No 38 Active Corallimorph % 31 CLAM NUMBER 22 No No 38 Active Clam % 32 CYANO NUMBER 22 No No 38 Active Cyanobacteria % 33 SPONGE NUMBER 22 No No 38 Active Sponge % 34 OTHER NUMBER 22 No No Active Other benthic composition value % 35 OTHER_TYPE VARCHAR2 20 No No Active Other benthic composition type 36 HABITAT_CODE VARCHAR2 50 No No Active Habitat Type (see HABITAT_TYPE) for description of code. 37 HABITAT_TYPE VARCHAR2 50 No No Active Habitat description 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 slope depth in meters 41 MAX_DEPTH NUMBER 22 No No 38 Active Maximum slope depth in meters 42 SUBSTRATE_HEIGHT_0 NUMBER 22 No No 38 8 Active Substrate complexity between 0cm and 20cm elevation 43 SUBSTRATE_HEIGHT_20 NUMBER 22 No No 38 8 Active Substrate complexity between 20cm and 50cm elevation 44 SUBSTRATE_HEIGHT_50 NUMBER 22 No No 38 8 Active Substrate complexity between 50cm and 100cm elevation 45 SUBSTRATE_HEIGHT_100 NUMBER 22 No No 38 8 Active Substrate complexity between 100cm and 150cm elevation 46 SUBSTRATE_HEIGHT_150 NUMBER 22 No No 38 8 Active Substrate complexity over 150cm elevation 47 MAX_HEIGHT NUMBER 22 No No Active Highest elevation point in SPC cylinder measured in centimeters 48 URCHIN_DACOR VARCHAR2 1 No No Active Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare) 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) 50 SPECIES NVARCHAR2 150 Yes No Active 4-letter species code 51 TAXONNAME NVARCHAR2 765 Yes No Active Scientific name 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 family classification 55 SCIENTIFIC_NAME VARCHAR2 255 No No Active Holds the true scientific name 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), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), 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 by to get it to right form (SL or FL or 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 A single letter representation of the observation type (I: Instantaneous, N: Non-Instantaneous, F: After 5 minutes, T: After 10 minutes, P: Presence, U: Unknown) 66 OBS_DESC VARCHAR2 20 Yes No Active The definition of the observation type gov.noaa.nmfs.inport:35991 Troy Kanemura 2016-12-14T17:51:48 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-11-22 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-11-22 1 Year 2018-11-22