Item Identification

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

CREP Fish Towed-Diver Survey spatial view

Notes:

Loaded by batch 9491, 11-14-2016 14:54

Entity Information

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

CRED Fish Towed Diver Survey spatial view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OBJECTID NUMBER Primary key for the fish tow data table
100
ROUNDID NUMBER Unique Identifier for ROUND record
100
MISSIONID VARCHAR2 Mission Identifier
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
ISLAND NVARCHAR2 Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record
100
LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the given island
100
LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the given island
100
OBS_YEAR NUMBER Year the survey was conducted
100
DIVEID NUMBER Unique ID representing year, month, day, tow # of day
100
SEGMENTID NUMBER Unique ID representing year, month, day, tow # of day, segment #
100
DATE_ DATE Date of the Tow 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. 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.
100
DIVER1 NVARCHAR2 Initials of fish diver
100
DIVER2 NVARCHAR2 Initials of benthic diver
100
TOWKEY NUMBER Towkey for the given towed diver survey fish observation
100
SEGMENT NUMBER Segments represent 5-minute increments; there are 10 segments per tow.
100
DEPTH NUMBER Mean Depth (in meters) of the towed-diver segment
100
DEPTH_SD NUMBER Standard deviation of depth of the towed-diver segment
100
TEMPERATURE NUMBER Temperature of the Towed Diver Survey
100
TEMPERATURE_SD NUMBER Standard deviation of temperature of the Towed Diver Survey
100
STARTLOCALTIME VARCHAR2 Local start time of the Towed Diver Survey
100
ENDLOCALTIME VARCHAR2 Local end time of the Towed Diver Survey
100
CENTROIDLAT NUMBER Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment
100
CENTROIDLON NUMBER Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment
100
PROJECTEDLENGTH NUMBER Length of tow segment (meters). Calculated from tow tracks using GIS
100
FAMILY NVARCHAR2 Taxonomic family classification
100
COMMONFAMILYALL NVARCHAR2 Common name of all families
100
TAXONNAME NVARCHAR2 Scientific name
100
COMMONNAME NVARCHAR2 Common name (from FishBase)
100
SPECIES NVARCHAR2 Species observed during the fish towed diver survey
100
COUNT NUMBER Number of fish observed for that segment
100
SIZE_ NUMBER 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.
100
LW_A NUMBER Parameter "a" used in length-weight calculations
100
LW_B NUMBER Parameter "b" used in length-weight calculations
100
LENGTH_CONVERSION_FACTOR NUMBER 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) <sup>LW B</sup>)
100
TROPHIC NVARCHAR2 Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)
100
CONSUMER_GROUP NVARCHAR2 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
100
COMMENT_ NVARCHAR2 Comment for the fish tow data

Attribute Details

OBJECTID

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

Primary key for the fish tow data table

ROUNDID

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

Unique Identifier for ROUND record

MISSIONID

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

Mission Identifier

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

ISLAND

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

Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record

LATITUDE

CC ID: 383068
Seq. Order: 6
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 given island

LONGITUDE

CC ID: 383070
Seq. Order: 7
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 given island

OBS_YEAR

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

Year the survey was conducted

DIVEID

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

Unique ID representing year, month, day, tow # of day

SEGMENTID

CC ID: 383081
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Unique ID representing year, month, day, tow # of day, segment #

DATE_

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

Date of the Tow survey

REEF_ZONE

CC ID: 383077
Seq. Order: 12
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. 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.

DIVER1

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

Initials of fish diver

DIVER2

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

Initials of benthic diver

TOWKEY

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

Towkey for the given towed diver survey fish observation

SEGMENT

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

Segments represent 5-minute increments; there are 10 segments per tow.

DEPTH

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

Mean Depth (in meters) of the towed-diver segment

DEPTH_SD

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

Standard deviation of depth of the towed-diver segment

TEMPERATURE

CC ID: 383086
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Temperature of the Towed Diver Survey

TEMPERATURE_SD

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

Standard deviation of temperature of the Towed Diver Survey

STARTLOCALTIME

CC ID: 383084
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 27
Required: No
Primary Key: No
Status: Active
Description:

Local start time of the Towed Diver Survey

ENDLOCALTIME

CC ID: 383065
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 27
Required: No
Primary Key: No
Status: Active
Description:

Local end time of the Towed Diver Survey

CENTROIDLAT

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

Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment

CENTROIDLON

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

Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment

PROJECTEDLENGTH

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

Length of tow segment (meters). Calculated from tow tracks using GIS

FAMILY

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

Taxonomic family classification

COMMONFAMILYALL

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

Common name of all families

TAXONNAME

CC ID: 383085
Seq. Order: 28
Data Storage Type: NVARCHAR2
Max Length: 765
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name

COMMONNAME

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

Common name (from FishBase)

SPECIES

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

Species observed during the fish towed diver survey

COUNT

CC ID: 383058
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number of fish observed for that segment

SIZE_

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

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.

LW_A

CC ID: 383071
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Parameter "a" used in length-weight calculations

LW_B

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

Parameter "b" used in length-weight calculations

LENGTH_CONVERSION_FACTOR

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

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) <sup>LW B</sup>)

TROPHIC

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

Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)

CONSUMER_GROUP

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

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

COMMENT_

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

Comment for the fish tow data

Catalog Details

Catalog Item ID: 36872
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-02-22 17:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-06-27
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-06-28