Item Identification

Title: View: VS_FISH_TDS_SIGHTINGS
Short Name: VS_FISH_TDS_SIGHTINGS
Status: Completed
Abstract:

Spatial view of sightings data from fish towed-diver surveys.

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Spatial view of sightings data from fish towed-diver surveys.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OBJECTID NUMBER Primary key for the data table.
100
MISSIONID VARCHAR2 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
100
REGION_NAME VARCHAR2 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.
100
ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE_).
100
DATE_ DATE Date of the tow survey. dd-MMM-yy
100
TOW_TYPE NVARCHAR2 Normal = standard towed diver survey (not a calibration survey).
100
REEF_ZONE NVARCHAR2 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).
100
TOWKEY NUMBER Unique key for the given tow (DIVEID).
100
DIVEID NUMBER Unique ID representing 4-digit year, 2-digit month, 2-digit day, and tow number of day (1-6).
100
SEGMENTID NUMBER Unique ID representing 4-digit year, 2-digit month, 2-digit day, tow number of day (1-6), and SEGMENT number (01-10).
100
SEGMENT NUMBER Segment number for a given tow. Segments represent 5-minute increments and there are typically, but not always, 10 segments per tow.
100
DEPTH NUMBER 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.
100
TEMPERATURE NUMBER 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.
100
STARTLOCALTIME DATETIME Local starting date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided.
100
ENDLOCALTIME DATETIME Local ending date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided.
100
CENTROIDLAT NUMBER Latitude in decimal degrees, WGS84, for the midpoint of the given 5-min SEGMENT.
100
CENTROIDLON NUMBER Longitude in decimal degrees, WGS84 for the midpoint of the given 5-min SEGMENT.
100
PROJECTEDLENGTH NUMBER Calculated length of SEGMENT in meters using GIS.
100
TAXONCODE TEXT 4-letter code for TAXONNAME.
100
TAXONNAME TEXT Scientific name of observed organism to the finest taxonomic resolution that divers can identify.
100
COUNT NUMBER Number of organisms observed for the given SEGMENT.
100
SIZE_CM NUMBER 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.
100
PHYLUM NVARCHAR2 Taxonomic classification: Phylum of observed organism (TAXONNAME).
100
CLASS NVARCHAR2 Taxonomic classification: Class of observed organism (TAXONNAME).
100
ORDER NVARCHAR2 Taxonomic classification: Order of observed organism (TAXONNAME).
100
FAMILY NVARCHAR2 Taxonomic classification: Family of observed organism (TAXONNAME).
100
COMMONFAMILYALL NVARCHAR2 Common name given for the FAMILY (used for grouping purposes during data analysis). For example, Dolphin, Monk Seal, and Turtle, among others.
100
SCIENTIFIC_NAME VARCHAR2 Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level.
100
COMMONNAME NVARCHAR2 Common name of the organism (TAXONNAME). If NULL, organism not identified to species taxonomic level.

Attribute Details

OBJECTID

CC ID: 565062
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Scale: 0
Status: Active
Description:

Primary key for the data table.

General Data Type: NUMBER

MISSIONID

CC ID: 565064
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

REGION_NAME

CC ID: 565066
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

ISLAND

CC ID: 565067
Seq. Order: 6
Data Storage Type: NVARCHAR2
Max Length: 90
Required: Yes
Primary Key: No
Status: Active
Description:

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

General Data Type: NVARCHAR2

OBS_YEAR

CC ID: 565070
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

4-digit year the survey was conducted (DATE_).

General Data Type: NUMBER

DATE_

CC ID: 565073
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date of the tow survey. dd-MMM-yy

General Data Type: DATE

TOW_TYPE

CC ID: 565077
Seq. Order: 12
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Normal = standard towed diver survey (not a calibration survey).

General Data Type: NVARCHAR2

REEF_ZONE

CC ID: 565074
Seq. Order: 13
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

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).

General Data Type: NVARCHAR2

TOWKEY

CC ID: 565078
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique key for the given tow (DIVEID).

General Data Type: NUMBER

DIVEID

CC ID: 565071
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID representing 4-digit year, 2-digit month, 2-digit day, and tow number of day (1-6).

General Data Type: NUMBER

SEGMENTID

CC ID: 565072
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID representing 4-digit year, 2-digit month, 2-digit day, tow number of day (1-6), and SEGMENT number (01-10).

General Data Type: NUMBER

SEGMENT

CC ID: 565079
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Segment number for a given tow. Segments represent 5-minute increments and there are typically, but not always, 10 segments per tow.

General Data Type: NUMBER

DEPTH

CC ID: 565063
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

TEMPERATURE

CC ID: 565075
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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.

STARTLOCALTIME

CC ID: 565076
Seq. Order: 21
Data Storage Type: DATETIME
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Local starting date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided.

General Data Type: DATETIME

ENDLOCALTIME

CC ID: 837921
Seq. Order: 22
Data Storage Type: DATETIME
Required: No
Primary Key: No
Status: Active
Description:

Local ending date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided.

CENTROIDLAT

CC ID: 565068
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the midpoint of the given 5-min SEGMENT.

General Data Type: NUMBER

CENTROIDLON

CC ID: 565069
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the midpoint of the given 5-min SEGMENT.

General Data Type: NUMBER

PROJECTEDLENGTH

CC ID: 565084
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Calculated length of SEGMENT in meters using GIS.

TAXONCODE

CC ID: 565089
Seq. Order: 25
Data Storage Type: TEXT
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for TAXONNAME.

TAXONNAME

CC ID: 565086
Seq. Order: 26
Data Storage Type: TEXT
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of observed organism to the finest taxonomic resolution that divers can identify.

COUNT

CC ID: 565090
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Number of organisms observed for the given SEGMENT.

General Data Type: NUMBER

SIZE_CM

CC ID: 565091
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

PHYLUM

CC ID: 565080
Seq. Order: 31
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Phylum of observed organism (TAXONNAME).

General Data Type: NVARCHAR2

CLASS

CC ID: 565081
Seq. Order: 32
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Class of observed organism (TAXONNAME).

General Data Type: NVARCHAR2

ORDER

CC ID: 565082
Seq. Order: 33
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Order of observed organism (TAXONNAME).

General Data Type: NVARCHAR2

FAMILY

CC ID: 565083
Seq. Order: 34
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Family of observed organism (TAXONNAME).

General Data Type: NVARCHAR2

COMMONFAMILYALL

CC ID: 565085
Seq. Order: 35
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Common name given for the FAMILY (used for grouping purposes during data analysis). For example, Dolphin, Monk Seal, and Turtle, among others.

General Data Type: NVARCHAR2

SCIENTIFIC_NAME

CC ID: 565087
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level.

General Data Type: VARCHAR2

COMMONNAME

CC ID: 565088
Seq. Order: 37
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Common name of the organism (TAXONNAME). If NULL, organism not identified to species taxonomic level.

General Data Type: NVARCHAR2

Catalog Details

Catalog Item ID: 45813
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-04-20 17:54+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-03