36872 VS_FISH_TDS Entity Published / External 34521 Pacific Reef Assessment and Monitoring Program: Towed-diver Surveys of Large-bodied Fishes of the U.S. Pacific Reefs from 2000 to 2012 Data Set Completed CREP Fish Towed-Diver Survey spatial view Loaded by batch 9491, 11-14-2016 14:54 Data View Yes GISDAT CRED Fish Towed Diver Survey spatial view 1 OBJECTID NUMBER 22 Yes No 38 0 Active Primary key for the fish tow data table 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 90 Yes No Active Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record 6 LATITUDE NUMBER 22 No No 28 8 Active Latitude in decimal degrees, WGS84, for the given island 7 LONGITUDE NUMBER 22 No No 28 8 Active Longitude in decimal degrees, WGS84 for the given island 8 OBS_YEAR NUMBER 22 Yes No 28 0 Active Year the survey was conducted 9 DIVEID NUMBER 22 No No Active Unique ID representing year, month, day, tow # of day 10 SEGMENTID NUMBER 22 No No 38 Active Unique ID representing year, month, day, tow # of day, segment # 11 DATE_ DATE 7 Yes No Active Date of the Tow survey 12 REEF_ZONE NVARCHAR2 150 Yes No Active The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include: Bank: A submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope. These areas are no longer actively targeted, with Pathfinder Reef (MARAMP 2007, CNMI) and Tutuila (ASRAMP 2010; exploratory) represents the last banks actively surveyed. Channel: A submerged transition between forereef and backreef zones created by a gap in the reef crest. Divers should avoid using channels to transition from forereef to backreef habitats (i.e. stick with one or the other). In addition, divers should make a note in the ¿Comments¿ section whenever crossing a channel along a forereef/backreef survey. 13 DIVER1 NVARCHAR2 150 Yes No Active Initials of fish diver 14 DIVER2 NVARCHAR2 150 No No Active Initials of benthic diver 15 TOWKEY NUMBER 22 Yes No 38 0 Active Towkey for the given towed diver survey fish observation 16 SEGMENT NUMBER 22 Yes No 28 0 Active Segments represent 5-minute increments; there are 10 segments per tow. 17 DEPTH NUMBER 22 No No Active Mean Depth (in meters) of the towed-diver segment 18 DEPTH_SD NUMBER 22 No No Active Standard deviation of depth of the towed-diver segment 19 TEMPERATURE NUMBER 22 No No 38 Active Temperature of the Towed Diver Survey 20 TEMPERATURE_SD NUMBER 22 No No 38 Active Standard deviation of temperature of the Towed Diver Survey 21 STARTLOCALTIME VARCHAR2 27 No No Active Local start time of the Towed Diver Survey 22 ENDLOCALTIME VARCHAR2 27 No No Active Local end time of the Towed Diver Survey 23 CENTROIDLAT NUMBER 22 No No 38 8 Active Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment 24 CENTROIDLON NUMBER 22 No No 38 8 Active Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment 25 PROJECTEDLENGTH NUMBER 22 No No Active Length of tow segment (meters). Calculated from tow tracks using GIS 26 FAMILY NVARCHAR2 150 No No Active Taxonomic family classification 27 COMMONFAMILYALL NVARCHAR2 150 No No Active Common name of all families 28 TAXONNAME NVARCHAR2 765 Yes No Active Scientific name 29 COMMONNAME NVARCHAR2 150 No No Active Common name (from FishBase) 30 SPECIES NVARCHAR2 150 Yes No Active Species observed during the fish towed diver survey 31 COUNT NUMBER 22 No No 38 0 Active Number of fish observed for that segment 32 SIZE_ NUMBER 22 No No 28 0 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. 33 LW_A NUMBER 22 No No 38 8 Active Parameter "a" used in length-weight calculations 34 LW_B NUMBER 22 No No 28 8 Active Parameter "b" used in length-weight calculations 35 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. Weight per fish is calculated as W(g)=LW A * ((TL(cm)*Length Conversion Factor) ^{LW B}) 36 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) 37 CONSUMER_GROUP NVARCHAR2 150 No No Active Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).*Note: Primary Consumers are all Herbivores and Deteritivores. Piscivores are species that primarily eat other fishes. Secondary Consumers are Omnivores and Invertivores 38 COMMENT_ NVARCHAR2 150 No No Active Comment for the fish tow data gov.noaa.nmfs.inport:36872 Troy Kanemura 2017-02-22T17:10:22 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-06-27 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-06-27 1 Year 2018-06-27