Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ocean and Climate Change > Towed-Diver Observations in the Main Hawaiian I... >

View: VS_BENT_TDS_BLEACHING_OBS

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:35795 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

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

Description

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

Entity Type
Data View

Data Attribute / Type	Description
OBJECTID NUMBER	Unique Object ID for the record
MISSIONID VARCHAR2	Mission Identifier
REGION_NAME VARCHAR2	One of the five Pacific Island regions CRED surveys
ISLAND NVARCHAR2	Island or Atoll surveyed
OBS_YEAR NUMBER	Year of the Tow survey
DATE_ DATE	Date of the Tow survey
TOWKEY NUMBER	A unique value used by other tables to join on the TOW table
DIVEID NUMBER	Unique ID representing year, month, day, tow # of day
SEGMENTID NUMBER	A unique value for the segment, comprised of DIVEID and SEGMENT
REEF_ZONE NVARCHAR2	The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified).
METHODNAME NVARCHAR2	Survey method employed
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.
STARTLOCALTIME DATE	Start time of segment (local time)
ENDLOCALTIME DATE	End time of segment (local time)
CENTROIDLAT NUMBER	Centroid latitude of the segment
CENTROIDLON NUMBER	Centroid longitude of the segment
DEPTH NUMBER	Average depth over the segment captured by the benthic board (measured in meters)
DEPTH_SD NUMBER	Standard deviation of depth over the segment captured by the benthic board (measured in meters)
TEMPERATURE NUMBER	Average temperature of the segment captured by the benthic board (measured in degrees Celcius)
TEMPERATURE_SD NUMBER	Standard deviation of temperature over the segment captured by the benthic board board (measured in degrees Celcius)
PROJECTEDLENGTH NUMBER	Projected length of the segment (measured in meters)
DIVER VARCHAR2	Initials of diver
BOARD VARCHAR2	Oceanographic or Benthic Board
NO_OBS CHAR	No data recorded for a segment due to diver recall, hazardous conditions, depth, etc.
HABITAT NVARCHAR2	Dominant Habitat
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).
LIVE_CORAL NUMBER	Percent Live Coral
MIN_LIVE_CORAL_YN CHAR	Indicates LIVE_CORAL value <1 captured in the field
PALE NUMBER	Percent Pale Coral
MIN_PALE_YN CHAR	Indicates PALE value <1 captured in the field
BLEACHED NUMBER	Percent Bleached Coral
MIN_BLEACHED_YN CHAR	Indicate BLEACHED value <1 captured in the field
H_FUNGIA CHAR	Presence of Fungia = 'Healthy'
P_FUNGIA CHAR	Presence of Fungia = 'Pale'
B_FUNGIA CHAR	Presence of Fungia = 'Bleached'
D_FUNGIA CHAR	Presence of Fungia = 'Recently Dead'
H_LEPTASTREA CHAR	Presence of Leptastrea = 'Healthy'
P_LEPTASTREA CHAR	Presence of Leptastrea = 'Pale'
B_LEPTASTREA CHAR	Presence of Leptastrea = 'Bleached'
D_LEPTASTREA CHAR	Presence of Leptastrea = 'Recently Dead'
H_MONTIPORA CHAR	Presence of Montipora = 'Healthy'
P_MONTIPORA CHAR	Presence of Montipora = 'Pale'
B_MONTIPORA CHAR	Presence of Montipora = 'Bleached'
D_MONTIPORA CHAR	Presence of Montipora = 'Recently Dead'
H_PAVONA CHAR	Presence of Pavona = 'Healthy'
P_PAVONA CHAR	Presence of Pavona = 'Pale'
B_PAVONA CHAR	Presence of Pavona = 'Bleached'
D_PAVONA CHAR	Presence of Pavona = 'Recently Dead'
H_POCILLOPORA CHAR	Presence of Pocillopora = 'Healthy'
P_POCILLOPORA CHAR	Presence of Pocillopora = 'Pale'
B_POCILLOPORA CHAR	Presence of Pocillopora = 'Bleached'
D_POCILLOPORA CHAR	Presence of Pocillopora = 'Recently Dead'
H_PORITESBRANCHING CHAR	Presence of Porites Branching = 'Healthy'
P_PORITESBRANCHING CHAR	Presence of Porites Branching = 'Pale'
B_PORITESBRANCHING CHAR	Presence of Porites Branching = 'Bleached'
D_PORITESBRANCHING CHAR	Presence of Porites Branching = 'Recently Dead'
H_PORITESMASSIVE CHAR	Presence of Porites Massive = 'Healthy'
P_PORITESMASSIVE CHAR	Presence of Porites Massive = 'Pale'
B_PORITESMASSIVE CHAR	Presence of Porites Massive = 'Bleached'
D_PORITESMASSIVE CHAR	Presence of Porites Massive = 'Recently Dead'
SEGMENT_DESCRIPTION NVARCHAR2	Segment description

Data Attribute / Type

Description

OBJECTID
NUMBER

Unique Object ID for the record

MISSIONID
VARCHAR2

Mission Identifier

REGION_NAME
VARCHAR2

One of the five Pacific Island regions CRED surveys

ISLAND
NVARCHAR2

Island or Atoll surveyed

OBS_YEAR
NUMBER

Year of the Tow survey

DATE_
DATE

Date of the Tow survey

TOWKEY
NUMBER

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

DIVEID
NUMBER

Unique ID representing year, month, day, tow # of day

SEGMENTID
NUMBER

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

REEF_ZONE
NVARCHAR2

The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified).

METHODNAME
NVARCHAR2

Survey method employed

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.

STARTLOCALTIME
DATE

Start time of segment (local time)

ENDLOCALTIME
DATE

End time of segment (local time)

CENTROIDLAT
NUMBER

Centroid latitude of the segment

CENTROIDLON
NUMBER

Centroid longitude of the segment

DEPTH
NUMBER

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

DEPTH_SD
NUMBER

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

TEMPERATURE
NUMBER

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

TEMPERATURE_SD
NUMBER

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

PROJECTEDLENGTH
NUMBER

Projected length of the segment (measured in meters)

DIVER
VARCHAR2

Initials of diver

BOARD
VARCHAR2

Oceanographic or Benthic Board

NO_OBS
CHAR

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

HABITAT
NVARCHAR2

Dominant Habitat

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).

LIVE_CORAL
NUMBER

Percent Live Coral

MIN_LIVE_CORAL_YN
CHAR

Indicates LIVE_CORAL value <1 captured in the field

PALE
NUMBER

Percent Pale Coral

MIN_PALE_YN
CHAR

Indicates PALE value <1 captured in the field

BLEACHED
NUMBER

Percent Bleached Coral

MIN_BLEACHED_YN
CHAR

Indicate BLEACHED value <1 captured in the field

H_FUNGIA
CHAR

Presence of Fungia = 'Healthy'

P_FUNGIA
CHAR

Presence of Fungia = 'Pale'

B_FUNGIA
CHAR

Presence of Fungia = 'Bleached'

D_FUNGIA
CHAR

Presence of Fungia = 'Recently Dead'

H_LEPTASTREA
CHAR

Presence of Leptastrea = 'Healthy'

P_LEPTASTREA
CHAR

Presence of Leptastrea = 'Pale'

B_LEPTASTREA
CHAR

Presence of Leptastrea = 'Bleached'

D_LEPTASTREA
CHAR

Presence of Leptastrea = 'Recently Dead'

H_MONTIPORA
CHAR

Presence of Montipora = 'Healthy'

P_MONTIPORA
CHAR

Presence of Montipora = 'Pale'

B_MONTIPORA
CHAR

Presence of Montipora = 'Bleached'

D_MONTIPORA
CHAR

Presence of Montipora = 'Recently Dead'

H_PAVONA
CHAR

Presence of Pavona = 'Healthy'

P_PAVONA
CHAR

Presence of Pavona = 'Pale'

B_PAVONA
CHAR

Presence of Pavona = 'Bleached'

D_PAVONA
CHAR

Presence of Pavona = 'Recently Dead'

H_POCILLOPORA
CHAR

Presence of Pocillopora = 'Healthy'

P_POCILLOPORA
CHAR

Presence of Pocillopora = 'Pale'

B_POCILLOPORA
CHAR

Presence of Pocillopora = 'Bleached'

D_POCILLOPORA
CHAR

Presence of Pocillopora = 'Recently Dead'

H_PORITESBRANCHING
CHAR

Presence of Porites Branching = 'Healthy'

P_PORITESBRANCHING
CHAR

Presence of Porites Branching = 'Pale'

B_PORITESBRANCHING
CHAR

Presence of Porites Branching = 'Bleached'

D_PORITESBRANCHING
CHAR

Presence of Porites Branching = 'Recently Dead'

H_PORITESMASSIVE
CHAR

Presence of Porites Massive = 'Healthy'

P_PORITESMASSIVE
CHAR

Presence of Porites Massive = 'Pale'

B_PORITESMASSIVE
CHAR

Presence of Porites Massive = 'Bleached'

D_PORITESMASSIVE
CHAR

Presence of Porites Massive = 'Recently Dead'

SEGMENT_DESCRIPTION
NVARCHAR2

Segment description

No Child Items for this record.

No contact information is available for this record.

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

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 Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Foundational view for towed-diver bleaching surveys (includes spatial data)

Attribute Summary

	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

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

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 Item ID:	35795
GUID:	gov.noaa.nmfs.inport: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:	2022-08-09 17:11+0000
Metadata Record Published:	2016-12-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-12-20
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-12-20

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

OBJECTID

MISSIONID

REGION_NAME

ISLAND

OBS_YEAR

DATE_

TOWKEY

DIVEID

SEGMENTID

REEF_ZONE

METHODNAME

SEGMENT

STARTLOCALTIME

ENDLOCALTIME

CENTROIDLAT

CENTROIDLON

DEPTH

DEPTH_SD

TEMPERATURE

TEMPERATURE_SD

PROJECTEDLENGTH

DIVER

BOARD

NO_OBS

HABITAT

COMPLEXITY

LIVE_CORAL

MIN_LIVE_CORAL_YN

PALE

MIN_PALE_YN

BLEACHED

MIN_BLEACHED_YN

H_FUNGIA

P_FUNGIA

B_FUNGIA

D_FUNGIA

H_LEPTASTREA

P_LEPTASTREA

B_LEPTASTREA

D_LEPTASTREA

H_MONTIPORA

P_MONTIPORA

B_MONTIPORA

D_MONTIPORA

H_PAVONA

P_PAVONA

B_PAVONA

D_PAVONA

H_POCILLOPORA

P_POCILLOPORA

B_POCILLOPORA

D_POCILLOPORA

H_PORITESBRANCHING

P_PORITESBRANCHING

B_PORITESBRANCHING

D_PORITESBRANCHING

H_PORITESMASSIVE

P_PORITESMASSIVE

B_PORITESMASSIVE

D_PORITESMASSIVE

SEGMENT_DESCRIPTION

Catalog Details