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

General Data Type: NUMBER

MISSIONID

CC ID: 359206
Seq. Order: 2
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: 359207
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

General Data Type: VARCHAR2

ISLAND

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

General Data Type: NVARCHAR2

LATITUDE

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

General Data Type: NUMBER

LONGITUDE

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

General Data Type: NUMBER

OBS_YEAR

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

General Data Type: NUMBER

DIVEID

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

General Data Type: NUMBER

SEGMENTID

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

General Data Type: NUMBER

DATE_

CC ID: 359214
Seq. Order: 10
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: 359215
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.

General Data Type: NVARCHAR2

METHODCODE

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

Survey method used

General Data Type: NVARCHAR2

NO_OBS

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

General Data Type: NUMBER

DIVER1

CC ID: 359218
Seq. Order: 14
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: 359219
Seq. Order: 15
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: 359220
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

General Data Type: NUMBER

SEGMENT

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

General Data Type: NUMBER

DEPTH

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

General Data Type: NUMBER

DEPTH_SD

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

General Data Type: NUMBER

TEMPERATURE

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

General Data Type: NUMBER

TEMPERATURE_SD

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

General Data Type: NUMBER

STARTLOCALTIME

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

General Data Type: DATE

ENDLOCALTIME

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

General Data Type: DATE

CENTROIDLAT

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

General Data Type: NUMBER

CENTROIDLON

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

General Data Type: NUMBER

PROJECTEDLENGTH

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

General Data Type: NUMBER

DOMINANT_HABITAT

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

Dominant Habitat

General Data Type: NVARCHAR2

DOMINANT_HABITAT_DESC

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

Dominant Habitat description

General Data Type: NVARCHAR2

COMPLEXITY

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

Complexity

General Data Type: NVARCHAR2

LIVE_CORAL_MID

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

General Data Type: NUMBER

SOFT_CORAL_MID

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

General Data Type: NUMBER

SAND_MID

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

General Data Type: NUMBER

STRESSED_CORAL_MID

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

General Data Type: NUMBER

MACROALGAE_MID

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

General Data Type: NUMBER

CORALLINE_MID

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

General Data Type: NUMBER

CROWN_OF_THORN

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

General Data Type: NUMBER

BORING_URCHIN

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

General Data Type: NUMBER

FREE_URCHIN

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

General Data Type: NUMBER

GIANT_CLAM

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

General Data Type: NUMBER

NET_LINE

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

General Data Type: NUMBER

MUNITION

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

General Data Type: NUMBER

WRECK

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

Shipwrecks

General Data Type: NUMBER

MANMADE_OBJECT

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

General Data Type: NUMBER

MANMADE_NOTE

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

Manmade Note

General Data Type: NVARCHAR2

Catalog Details

Catalog Item ID: 35758
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-11-21 14:37+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