45813
View: VS_FISH_TDS_SIGHTINGS
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
TOW_TYPE
NVARCHAR2
60
No
No
Active
Normal = standard towed diver survey (not a calibration survey).
NVARCHAR2
12
DATE_
DATE
7
Yes
No
Active
Date of the tow survey. dd-MMM-yy
DATE
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
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2019-05-03
1 Year
2020-05-03