Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

CREP Fish Towed-Diver Survey spatial view

Description

CRED Fish Towed Diver Survey spatial view

Entity Information

Entity Type
Data View

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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: 359828
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: 359833
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: 359827
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission Identifier

REGION_NAME

CC ID: 359832
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: 359821
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: 359822
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: 359824
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: 359829
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: 359816
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: 359835
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: 359813
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: 359831
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: 359817
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: 359818
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: 359842
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: 359834
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: 359814
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: 359815
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: 359840
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: 359841
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: 359838
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: 359819
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: 359806
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: 359807
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: 359830
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: 359820
Seq. Order: 26
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic family classification

COMMONFAMILYALL

CC ID: 359809
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: 359839
Seq. Order: 28
Data Storage Type: NVARCHAR2
Max Length: 765
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name

COMMONNAME

CC ID: 359810
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: 359837
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: 359812
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: 359836
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: 359825
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: 359826
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: 359823
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: 359843
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: 359811
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: 359808
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: 35766
GUID: gov.noaa.nmfs.inport:35766
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-11-21 18:47+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-01-24
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-01-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-01-24