Item Identification

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

Foundational view for towed-diver bleaching surveys (includes spatial data)

Notes:

Loaded by batch 9530, 11-29-2016 13:22

Entity Information

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

Foundational view for towed-diver bleaching surveys (includes spatial data)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OBJECTID NUMBER Unique Object ID for the record
100
MISSIONID VARCHAR2 Mission Identifier
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
ISLAND NVARCHAR2 Island or Atoll surveyed
100
OBS_YEAR NUMBER Year of the Tow survey
100
DATE_ DATE Date of the Tow survey
100
TOWKEY NUMBER A unique value used by other tables to join on the TOW table
100
DIVEID NUMBER Unique ID representing year, month, day, tow # of day
100
SEGMENTID NUMBER A unique value for the segment, comprised of DIVEID and SEGMENT
100
REEF_ZONE NVARCHAR2 The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified).
100
METHODNAME NVARCHAR2 Survey method employed
100
SEGMENT NUMBER This indicates the number of the 5-minute survey portion. E.g. segment 1 = 0 - 5 minutes, segment 2 = 5 - 10 minutes, segment 3 = 10 - 15 minutes, etc.
100
STARTLOCALTIME DATE Start time of segment (local time)
100
ENDLOCALTIME DATE End time of segment (local time)
100
CENTROIDLAT NUMBER Centroid latitude of the segment
100
CENTROIDLON NUMBER Centroid longitude of the segment
100
DEPTH NUMBER Average depth over the segment captured by the benthic board (measured in meters)
100
DEPTH_SD NUMBER Standard deviation of depth over the segment captured by the benthic board (measured in meters)
100
TEMPERATURE NUMBER Average temperature of the segment captured by the benthic board (measured in degrees Celcius)
100
TEMPERATURE_SD NUMBER Standard deviation of temperature over the segment captured by the benthic board board (measured in degrees Celcius)
100
PROJECTEDLENGTH NUMBER Projected length of the segment (measured in meters)
100
DIVER VARCHAR2 Initials of diver
100
BOARD VARCHAR2 Oceanographic or Benthic Board
100
NO_OBS CHAR No data recorded for a segment due to diver recall, hazardous conditions, depth, etc.
100
HABITAT NVARCHAR2 Dominant Habitat
100
COMPLEXITY NVARCHAR2 Towed-diver surveys collect habitat complexity data based on a six-point subjective assessment of topographical diversity and complexity of the benthic habitat. Classified according to 1 of 6 categories: low (L), medium-low (ML), medium (M), medium-high (MH), high (H), and very high (VH). Low habitat complexity is often associated with flat sand plains or rubble habitats. Medium habitat complexity is often associated with small to moderate spur and groove, coral or boulder habitats. High or very high habitat complexity are often observed as high or extreme vertical relief associated with steep spur-and-groove canyons, pinnacles, and walls (or a combination therein).
100
LIVE_CORAL NUMBER Percent Live Coral
100
MIN_LIVE_CORAL_YN CHAR Indicates LIVE_CORAL value <1 captured in the field
100
PALE NUMBER Percent Pale Coral
100
MIN_PALE_YN CHAR Indicates PALE value <1 captured in the field
100
BLEACHED NUMBER Percent Bleached Coral
100
MIN_BLEACHED_YN CHAR Indicate BLEACHED value <1 captured in the field
100
H_FUNGIA CHAR Presence of Fungia = 'Healthy'
100
P_FUNGIA CHAR Presence of Fungia = 'Pale'
100
B_FUNGIA CHAR Presence of Fungia = 'Bleached'
100
D_FUNGIA CHAR Presence of Fungia = 'Recently Dead'
100
H_LEPTASTREA CHAR Presence of Leptastrea = 'Healthy'
100
P_LEPTASTREA CHAR Presence of Leptastrea = 'Pale'
100
B_LEPTASTREA CHAR Presence of Leptastrea = 'Bleached'
100
D_LEPTASTREA CHAR Presence of Leptastrea = 'Recently Dead'
100
H_MONTIPORA CHAR Presence of Montipora = 'Healthy'
100
P_MONTIPORA CHAR Presence of Montipora = 'Pale'
100
B_MONTIPORA CHAR Presence of Montipora = 'Bleached'
100
D_MONTIPORA CHAR Presence of Montipora = 'Recently Dead'
100
H_PAVONA CHAR Presence of Pavona = 'Healthy'
100
P_PAVONA CHAR Presence of Pavona = 'Pale'
100
B_PAVONA CHAR Presence of Pavona = 'Bleached'
100
D_PAVONA CHAR Presence of Pavona = 'Recently Dead'
100
H_POCILLOPORA CHAR Presence of Pocillopora = 'Healthy'
100
P_POCILLOPORA CHAR Presence of Pocillopora = 'Pale'
100
B_POCILLOPORA CHAR Presence of Pocillopora = 'Bleached'
100
D_POCILLOPORA CHAR Presence of Pocillopora = 'Recently Dead'
100
H_PORITESBRANCHING CHAR Presence of Porites Branching = 'Healthy'
100
P_PORITESBRANCHING CHAR Presence of Porites Branching = 'Pale'
100
B_PORITESBRANCHING CHAR Presence of Porites Branching = 'Bleached'
100
D_PORITESBRANCHING CHAR Presence of Porites Branching = 'Recently Dead'
100
H_PORITESMASSIVE CHAR Presence of Porites Massive = 'Healthy'
100
P_PORITESMASSIVE CHAR Presence of Porites Massive = 'Pale'
100
B_PORITESMASSIVE CHAR Presence of Porites Massive = 'Bleached'
100
D_PORITESMASSIVE CHAR Presence of Porites Massive = 'Recently Dead'
100
SEGMENT_DESCRIPTION NVARCHAR2 Segment description

Attribute Details

OBJECTID

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

Unique Object ID for the record

General Data Type: NUMBER

MISSIONID

CC ID: 361183
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: 361184
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: 361185
Seq. Order: 4
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed

General Data Type: NVARCHAR2

OBS_YEAR

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

Year of the Tow survey

General Data Type: NUMBER

DATE_

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

Date of the Tow survey

General Data Type: DATE

TOWKEY

CC ID: 361188
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

A unique value used by other tables to join on the TOW table

General Data Type: NUMBER

DIVEID

CC ID: 361189
Seq. Order: 8
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

General Data Type: NUMBER

SEGMENTID

CC ID: 361190
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

A unique value for the segment, comprised of DIVEID and SEGMENT

General Data Type: NUMBER

REEF_ZONE

CC ID: 361191
Seq. Order: 10
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).

General Data Type: NVARCHAR2

METHODNAME

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

Survey method employed

General Data Type: NVARCHAR2

SEGMENT

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

This indicates the number of the 5-minute survey portion. E.g. segment 1 = 0 - 5 minutes, segment 2 = 5 - 10 minutes, segment 3 = 10 - 15 minutes, etc.

General Data Type: NUMBER

STARTLOCALTIME

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

Start time of segment (local time)

General Data Type: DATE

ENDLOCALTIME

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

End time of segment (local time)

General Data Type: DATE

CENTROIDLAT

CC ID: 361196
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Centroid latitude of the segment

General Data Type: NUMBER

CENTROIDLON

CC ID: 361197
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Centroid longitude of the segment

General Data Type: NUMBER

DEPTH

CC ID: 361198
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Average depth over the segment captured by the benthic board (measured in meters)

General Data Type: NUMBER

DEPTH_SD

CC ID: 361199
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Standard deviation of depth over the segment captured by the benthic board (measured in meters)

General Data Type: NUMBER

TEMPERATURE

CC ID: 361200
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Average temperature of the segment captured by the benthic board (measured in degrees Celcius)

General Data Type: NUMBER

TEMPERATURE_SD

CC ID: 361201
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Standard deviation of temperature over the segment captured by the benthic board board (measured in degrees Celcius)

General Data Type: NUMBER

PROJECTEDLENGTH

CC ID: 361202
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Projected length of the segment (measured in meters)

General Data Type: NUMBER

DIVER

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

Initials of diver

General Data Type: VARCHAR2

BOARD

CC ID: 361204
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Oceanographic or Benthic Board

General Data Type: VARCHAR2

NO_OBS

CC ID: 361205
Seq. Order: 24
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

No data recorded for a segment due to diver recall, hazardous conditions, depth, etc.

General Data Type: CHAR

HABITAT

CC ID: 361206
Seq. Order: 25
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Dominant Habitat

General Data Type: NVARCHAR2

COMPLEXITY

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

Towed-diver surveys collect habitat complexity data based on a six-point subjective assessment of topographical diversity and complexity of the benthic habitat. Classified according to 1 of 6 categories: low (L), medium-low (ML), medium (M), medium-high (MH), high (H), and very high (VH). Low habitat complexity is often associated with flat sand plains or rubble habitats. Medium habitat complexity is often associated with small to moderate spur and groove, coral or boulder habitats. High or very high habitat complexity are often observed as high or extreme vertical relief associated with steep spur-and-groove canyons, pinnacles, and walls (or a combination therein).

General Data Type: NVARCHAR2

LIVE_CORAL

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

Percent Live Coral

General Data Type: NUMBER

MIN_LIVE_CORAL_YN

CC ID: 361209
Seq. Order: 28
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates LIVE_CORAL value <1 captured in the field

General Data Type: CHAR

PALE

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

Percent Pale Coral

General Data Type: NUMBER

MIN_PALE_YN

CC ID: 361211
Seq. Order: 30
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates PALE value <1 captured in the field

General Data Type: CHAR

BLEACHED

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

Percent Bleached Coral

General Data Type: NUMBER

MIN_BLEACHED_YN

CC ID: 361213
Seq. Order: 32
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicate BLEACHED value <1 captured in the field

General Data Type: CHAR

H_FUNGIA

CC ID: 361214
Seq. Order: 33
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Fungia = 'Healthy'

General Data Type: CHAR

P_FUNGIA

CC ID: 361215
Seq. Order: 34
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Fungia = 'Pale'

General Data Type: CHAR

B_FUNGIA

CC ID: 361216
Seq. Order: 35
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Fungia = 'Bleached'

General Data Type: CHAR

D_FUNGIA

CC ID: 361217
Seq. Order: 36
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Fungia = 'Recently Dead'

General Data Type: CHAR

H_LEPTASTREA

CC ID: 361218
Seq. Order: 37
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Leptastrea = 'Healthy'

General Data Type: CHAR

P_LEPTASTREA

CC ID: 361219
Seq. Order: 38
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Leptastrea = 'Pale'

General Data Type: CHAR

B_LEPTASTREA

CC ID: 361220
Seq. Order: 39
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Leptastrea = 'Bleached'

General Data Type: CHAR

D_LEPTASTREA

CC ID: 361221
Seq. Order: 40
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Leptastrea = 'Recently Dead'

General Data Type: CHAR

H_MONTIPORA

CC ID: 361222
Seq. Order: 41
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Montipora = 'Healthy'

General Data Type: CHAR

P_MONTIPORA

CC ID: 361223
Seq. Order: 42
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Montipora = 'Pale'

General Data Type: CHAR

B_MONTIPORA

CC ID: 361224
Seq. Order: 43
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Montipora = 'Bleached'

General Data Type: CHAR

D_MONTIPORA

CC ID: 361225
Seq. Order: 44
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Montipora = 'Recently Dead'

General Data Type: CHAR

H_PAVONA

CC ID: 361226
Seq. Order: 45
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pavona = 'Healthy'

General Data Type: CHAR

P_PAVONA

CC ID: 361227
Seq. Order: 46
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pavona = 'Pale'

General Data Type: CHAR

B_PAVONA

CC ID: 361228
Seq. Order: 47
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pavona = 'Bleached'

General Data Type: CHAR

D_PAVONA

CC ID: 361229
Seq. Order: 48
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pavona = 'Recently Dead'

General Data Type: CHAR

H_POCILLOPORA

CC ID: 361230
Seq. Order: 49
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pocillopora = 'Healthy'

General Data Type: CHAR

P_POCILLOPORA

CC ID: 361231
Seq. Order: 50
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pocillopora = 'Pale'

General Data Type: CHAR

B_POCILLOPORA

CC ID: 361232
Seq. Order: 51
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pocillopora = 'Bleached'

General Data Type: CHAR

D_POCILLOPORA

CC ID: 361233
Seq. Order: 52
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Pocillopora = 'Recently Dead'

General Data Type: CHAR

H_PORITESBRANCHING

CC ID: 361234
Seq. Order: 53
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Branching = 'Healthy'

General Data Type: CHAR

P_PORITESBRANCHING

CC ID: 361235
Seq. Order: 54
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Branching = 'Pale'

General Data Type: CHAR

B_PORITESBRANCHING

CC ID: 361236
Seq. Order: 55
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Branching = 'Bleached'

General Data Type: CHAR

D_PORITESBRANCHING

CC ID: 361237
Seq. Order: 56
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Branching = 'Recently Dead'

General Data Type: CHAR

H_PORITESMASSIVE

CC ID: 361238
Seq. Order: 57
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Massive = 'Healthy'

General Data Type: CHAR

P_PORITESMASSIVE

CC ID: 361239
Seq. Order: 58
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Massive = 'Pale'

General Data Type: CHAR

B_PORITESMASSIVE

CC ID: 361240
Seq. Order: 59
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Massive = 'Bleached'

General Data Type: CHAR

D_PORITESMASSIVE

CC ID: 361241
Seq. Order: 60
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of Porites Massive = 'Recently Dead'

General Data Type: CHAR

SEGMENT_DESCRIPTION

CC ID: 361242
Seq. Order: 61
Data Storage Type: NVARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Segment description

General Data Type: NVARCHAR2

Catalog Details

Catalog Item ID: 35795
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-11-29 13:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-12-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-12-21