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

Mission Identifier

REGION_NAME

CC ID: 360297
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: 360282
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: 360283
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: 360285
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: 360294
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: 360274
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: 360301
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: 360271
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: 360296
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: 360289
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: 360293
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: 360275
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: 360276
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: 360307
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: 360300
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: 360272
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: 360273
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: 360305
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: 360306
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: 360303
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: 360279
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: 360266
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: 360267
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: 360295
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: 360277
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: 360278
Seq. Order: 28
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Dominant Habitat description

COMPLEXITY

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

Complexity

LIVE_CORAL_MID

CC ID: 360284
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: 360302
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: 360299
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: 360304
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: 360286
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: 360269
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: 360270
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: 360265
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: 360280
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: 360281
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: 360292
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: 360291
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: 360308
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: 360288
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: 360287
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: 35772
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-11-21 19:46+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-03-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-03-17