Slide Menu
Search Help Show/Hide Menu

Item Identification

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

CREP Benthic Towed-Diver Survey spatial view

Notes:

Loaded by batch 9510, 11-21-2016 14:37

Entity Information

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

Benthic towed-diver survey spatial view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
METHODCODE NVARCHAR2 Survey method used
100
NO_OBS NUMBER No data recorded for a towed-diver survey due to diver recall, hazardous conditions, depth, etc.
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 DATE Local start time of the Towed Diver Survey
100
ENDLOCALTIME DATE 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
DOMINANT_HABITAT NVARCHAR2 Dominant Habitat
100
DOMINANT_HABITAT_DESC NVARCHAR2 Dominant Habitat description
100
COMPLEXITY NVARCHAR2 Complexity
100
LIVE_CORAL_MID NUMBER Live coral mid-point
100
SOFT_CORAL_MID NUMBER Soft coral mid-point
100
SAND_MID NUMBER Sand mid-point
100
STRESSED_CORAL_MID NUMBER Stressed coral mid-point
100
MACROALGAE_MID NUMBER Macro algae mid-point
100
CORALLINE_MID NUMBER Coralline algae mid-point
100
CROWN_OF_THORN NUMBER Acanthaster planci. Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000
100
BORING_URCHIN NUMBER "Boring" sea urchins (e.g. Echinostrephus, Echinometra). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000
100
FREE_URCHIN NUMBER "Free" sea urchins (e.g. Tripneustes, Diadema). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000
100
GIANT_CLAM NUMBER Giant clams (Tridacna sp.). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000
100
NET_LINE NUMBER Derelict fishing gear of any type (e.g. monofilament line, fishing nets or fragments of fishing nets, etc.)
100
MUNITION NUMBER Munitions/unexploded ordinance
100
WRECK NUMBER Shipwrecks
100
MANMADE_OBJECT NUMBER Man-made objects, whether of nautical or terrestrial origins (e.g. anchors/discarded mooring, tires, corrugated tin roofing). It is important to note that marine debris observations do not include highly mobile marine debris (e.g. bottles, cans, plastic bags, etc.)
100
MANMADE_NOTE NVARCHAR2 Manmade Note

Attribute Details

ROUNDID

CC ID: 360210
Seq. Order: 1
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: 360202
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission Identifier

REGION_NAME

CC ID: 360209
Seq. Order: 3
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: 360194
Seq. Order: 4
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

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

LATITUDE

CC ID: 360195
Seq. Order: 5
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: 360197
Seq. Order: 6
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: 360206
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Year the survey was conducted

DIVEID

CC ID: 360186
Seq. Order: 8
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: 360213
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, segment #

DATE_

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

Date of the Tow survey

REEF_ZONE

CC ID: 360208
Seq. Order: 11
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.

METHODCODE

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

Survey method used

NO_OBS

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

No data recorded for a towed-diver survey due to diver recall, hazardous conditions, depth, etc.

DIVER1

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

Initials of fish diver

DIVER2

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

Initials of benthic diver

TOWKEY

CC ID: 360219
Seq. Order: 16
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: 360212
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

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

DEPTH

CC ID: 360184
Seq. Order: 18
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: 360185
Seq. Order: 19
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: 360217
Seq. Order: 20
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: 360218
Seq. Order: 21
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: 360215
Seq. Order: 22
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Local start time of the Towed Diver Survey

ENDLOCALTIME

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

Local end time of the Towed Diver Survey

CENTROIDLAT

CC ID: 360178
Seq. Order: 24
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: 360179
Seq. Order: 25
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: 360207
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

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

DOMINANT_HABITAT

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

Dominant Habitat

DOMINANT_HABITAT_DESC

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

Dominant Habitat description

COMPLEXITY

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

Complexity

LIVE_CORAL_MID

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

Live coral mid-point

SOFT_CORAL_MID

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

Soft coral mid-point

SAND_MID

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

Sand mid-point

STRESSED_CORAL_MID

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

Stressed coral mid-point

MACROALGAE_MID

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

Macro algae mid-point

CORALLINE_MID

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

Coralline algae mid-point

CROWN_OF_THORN

CC ID: 360182
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Acanthaster planci. Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000

BORING_URCHIN

CC ID: 360177
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

"Boring" sea urchins (e.g. Echinostrephus, Echinometra). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000

FREE_URCHIN

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

"Free" sea urchins (e.g. Tripneustes, Diadema). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000

GIANT_CLAM

CC ID: 360193
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Giant clams (Tridacna sp.). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000

NET_LINE

CC ID: 360204
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Derelict fishing gear of any type (e.g. monofilament line, fishing nets or fragments of fishing nets, etc.)

MUNITION

CC ID: 360203
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Munitions/unexploded ordinance

WRECK

CC ID: 360220
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Shipwrecks

MANMADE_OBJECT

CC ID: 360200
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Man-made objects, whether of nautical or terrestrial origins (e.g. anchors/discarded mooring, tires, corrugated tin roofing). It is important to note that marine debris observations do not include highly mobile marine debris (e.g. bottles, cans, plastic bags, etc.)

MANMADE_NOTE

CC ID: 360199
Seq. Order: 44
Data Storage Type: NVARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Manmade Note

Catalog Details

Catalog Item ID: 35770
GUID: gov.noaa.nmfs.inport:35770
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-11-21 19:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-03-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-03-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-03-16