45813 VS_FISH_TDS_SIGHTINGS Entity Published / External 25301 Pacific Reef Assessment and Monitoring Program: Sightings of Marine Species of Interest during Towed-diver Surveys of the U.S. Pacific Reefs from 2000 to 2017 Data Set Completed Spatial view of sightings data from fish towed-diver surveys. Data View Yes GISDAT Spatial view of sightings data from fish towed-diver surveys. 1 OBJECTID NUMBER 22 Yes No 0 Active Primary key for the data table. NUMBER 3 MISSIONID VARCHAR2 30 Yes No Active Mission identifier: NOAA Ship, 2-digit federal fiscal year, 2-digit mission number for the fiscal year. HA/HI = NOAA Ship Hi'ialakai OES = NOAA Ship Oscar Elton Sette TC = NOAA Ship Townsend Cromwell Shore = shore-based survey launch VARCHAR2 5 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. VARCHAR2 6 ISLAND NVARCHAR2 90 Yes No Active Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). NVARCHAR2 9 OBS_YEAR NUMBER 22 Yes No 28 0 Active 4-digit year the survey was conducted (DATE_). NUMBER 12 DATE_ DATE 7 Yes No Active Date of the tow survey. dd-MMM-yy DATE 12 TOW_TYPE NVARCHAR2 60 No No Active Normal = standard towed diver survey (not a calibration survey). NVARCHAR2 13 TOWKEY NUMBER 22 No No 28 0 Active Unique key for the given tow (DIVEID). NUMBER 13 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) and channel (a submerged transition between forereef and backreef zones created by a gap in the reef crest). NVARCHAR2 14 DIVEID NUMBER 22 No No Active Unique ID representing 4-digit year, 2-digit month, 2-digit day, and tow number of day (1-6). NUMBER 15 SEGMENTID NUMBER 22 No No Active Unique ID representing 4-digit year, 2-digit month, 2-digit day, tow number of day (1-6), and SEGMENT number (01-10). NUMBER 18 SEGMENT NUMBER 22 No No 28 0 Active Segment number for a given tow. Segments represent 5-minute increments and there are typically, but not always, 10 segments per tow. NUMBER 19 DEPTH NUMBER 20 No No Active Mean depth in meters of the towed diver during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. NUMBER 20 TEMPERATURE NUMBER 20 No No Active Mean temperature in degrees Celsius during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. 21 STARTLOCALTIME DATETIME 20 No No Active Local starting date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. DATETIME 22 ENDLOCALTIME DATETIME No No Active Local ending date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. 23 CENTROIDLAT NUMBER 22 No No 28 8 Active Latitude in decimal degrees, WGS84, for the midpoint of the given 5-min SEGMENT. NUMBER 24 CENTROIDLON NUMBER 22 No No 28 8 Active Longitude in decimal degrees, WGS84 for the midpoint of the given 5-min SEGMENT. NUMBER 25 TAXONCODE TEXT 10 No No Active 4-letter code for TAXONNAME. 25 PROJECTEDLENGTH NUMBER 30 No No Active Calculated length of SEGMENT in meters using GIS. 26 TAXONNAME TEXT 765 No No Active Scientific name of observed organism to the finest taxonomic resolution that divers can identify. 29 COUNT NUMBER 22 No No 28 0 Active Number of organisms observed for the given SEGMENT. NUMBER 30 SIZE_CM NUMBER 22 No No Active Length of organism, reported in centimeters. In some cases the size of exceptionally large (i.e., whales) or partially hidden (i.e., eels) organisms may not be provided. NUMBER 31 PHYLUM NVARCHAR2 150 No No Active Taxonomic classification: Phylum of observed organism (TAXONNAME). NVARCHAR2 32 CLASS NVARCHAR2 150 No No Active Taxonomic classification: Class of observed organism (TAXONNAME). NVARCHAR2 33 ORDER NVARCHAR2 150 No No Active Taxonomic classification: Order of observed organism (TAXONNAME). NVARCHAR2 34 FAMILY NVARCHAR2 150 No No Active Taxonomic classification: Family of observed organism (TAXONNAME). NVARCHAR2 35 COMMONFAMILYALL NVARCHAR2 150 No No Active Common name given for the FAMILY (used for grouping purposes during data analysis). For example, Dolphin, Monk Seal, and Turtle, among others. NVARCHAR2 36 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. VARCHAR2 37 COMMONNAME NVARCHAR2 150 No No Active Common name of the organism (TAXONNAME). If NULL, organism not identified to species taxonomic level. NVARCHAR2 gov.noaa.nmfs.inport:45813 Troy Kanemura 2017-04-20T17:54:53 SysAdmin InPortAdmin 2022-08-09T17:11:20 2019-05-03 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 2019-05-03 1 Year 2020-05-03