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: 357623
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

General Data Type: NUMBER

ROUNDID

CC ID: 357624
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

General Data Type: NUMBER

MISSIONID

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

Mission Identifier

General Data Type: VARCHAR2

REGION_NAME

CC ID: 357626
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

General Data Type: VARCHAR2

ISLAND

CC ID: 357627
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

General Data Type: NVARCHAR2

LATITUDE

CC ID: 357628
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

General Data Type: NUMBER

LONGITUDE

CC ID: 357629
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

General Data Type: NUMBER

OBS_YEAR

CC ID: 357630
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

General Data Type: NUMBER

DIVEID

CC ID: 357631
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

General Data Type: NUMBER

SEGMENTID

CC ID: 357632
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 #

General Data Type: NUMBER

DATE_

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

Date of the Tow survey

General Data Type: DATE

REEF_ZONE

CC ID: 357634
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.

General Data Type: NVARCHAR2

DIVER1

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

Initials of fish diver

General Data Type: NVARCHAR2

DIVER2

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

Initials of benthic diver

General Data Type: NVARCHAR2

TOWKEY

CC ID: 357637
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

General Data Type: NUMBER

SEGMENT

CC ID: 357638
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.

General Data Type: NUMBER

DEPTH

CC ID: 357639
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

General Data Type: NUMBER

DEPTH_SD

CC ID: 357640
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

General Data Type: NUMBER

TEMPERATURE

CC ID: 357641
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

General Data Type: NUMBER

TEMPERATURE_SD

CC ID: 357642
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

General Data Type: NUMBER

STARTLOCALTIME

CC ID: 357643
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

General Data Type: VARCHAR2

ENDLOCALTIME

CC ID: 357644
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

General Data Type: VARCHAR2

CENTROIDLAT

CC ID: 357645
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

General Data Type: NUMBER

CENTROIDLON

CC ID: 357646
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

General Data Type: NUMBER

PROJECTEDLENGTH

CC ID: 357647
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

General Data Type: NUMBER

FAMILY

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

Taxonomic family classification

General Data Type: NVARCHAR2

COMMONFAMILYALL

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

Common name of all families

General Data Type: NVARCHAR2

TAXONNAME

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

Scientific name

General Data Type: NVARCHAR2

COMMONNAME

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

Common name (from FishBase)

General Data Type: NVARCHAR2

SPECIES

CC ID: 357652
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

General Data Type: NVARCHAR2

COUNT

CC ID: 357653
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

General Data Type: NUMBER

SIZE_

CC ID: 357654
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.

General Data Type: NUMBER

LW_A

CC ID: 357655
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

General Data Type: NUMBER

LW_B

CC ID: 357656
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

General Data Type: NUMBER

LENGTH_CONVERSION_FACTOR

CC ID: 357657
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>)

General Data Type: NUMBER

TROPHIC

CC ID: 357658
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)

General Data Type: NVARCHAR2

CONSUMER_GROUP

CC ID: 357659
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

General Data Type: NVARCHAR2

COMMENT_

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

Comment for the fish tow data

General Data Type: NVARCHAR2

Catalog Details

Catalog Item ID: 35615
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-11-14 14:54+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-07-07
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-07-08