Item Identification

Title: TDS_BLEACHING_OCEANOGRAPHIC
Short Name: TDS_BLEACHING_OCEANOGRAPHIC
Status: Completed
Abstract:

Oceanographic data from towed-diver surveys in the Main Hawaiian Islands to assess impacts from the 2015 bleaching event.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Oceanographic data from towed-diver surveys in the Main Hawaiian Islands to assess impacts from the 2015 bleaching event.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ISLAND TEXT 3-letter code for the Island in the Main Hawaiian Islands. HAW = Hawaii, LAN = Lanai, MAI = Maui, OAH = Oahu.
100
Dive_ID NUMBER Unique ID for each dive/survey representing 4-digit year, 2-digit month, 2-digit day, 1-digit Dive_Number. YYYYMMDD#, where # = Dive_Number for the day.
100
Local_Date DATE Local Date, mm/d/yyyy
100
Dive_Number NUMBER Consecutive number of each day's dive, 1-5
100
Segment NUMBER Dive segment number for a given dive/survey. Segments represent 5-minute increments (~200 m) and there are typically, but not always, 10 segments per dive/survey. 1-10
100
Segment_ID NUMBER Dive_ID with 2-digit Segment appended. YYYYMMDD###, where ### = Dive_Number for the day (1-5) plus the 2-digit Segment (01-10)
100
StartTime DATETIME Start date and time for the 5-min Segment, mm/d/yyyy hh:mm
100
EndTime DATETIME End date and time for the 5-min Segment, mm/d/yyyy hh:mm
100
ComputedLength NUMBER Segment length computed by GPS lay-back (meters)
100
CentroidLAT NUMBER Mean GPS position, latitude, for each segment (decimal degrees)
100
CentroidLON NUMBER Mean GPS position, longitude, for each segment (decimal degrees)
100
prdM_med NUMBER CTD 19+ median pressure by segment (decibars)
100
depSM_med NUMBER CTD 19+ median depth by segment (meters)
100
tv290C_med NUMBER CTD19+ median temperature by segment (degrees Celsius)
100
c0S.m_med NUMBER CTD19+ median conductivity by segment (Siemens per meter)
100
sal00_med NUMBER CTD19+ median salinity by segment (practical salinity units)
100
sbeox0PS_med NUMBER CTD19+ median oxygen saturation by segment (% saturation)
100
sbeox0ML.L_med NUMBER CTD19+ median oxygen concentration by segment (mg/L)
100
flECO.AFL_med NUMBER CTD19+ median flourescence by segment (flouresence units)
100
turbWETntu0_med NUMBER CTD19+ median turbidity by segment (NTU - nephelometric turbidity unit)
100
prdM_sd NUMBER CTD 19+ standard deviation pressure by segment (decibars)
100
depSM_sd NUMBER CTD 19+ standard deviation depth by segment (meters)
100
tv290C_sd NUMBER CTD19+ standard deviation temperature by segment (degrees Celsius)
100
c0S.m_sd NUMBER CTD19+ standard deviation conductivity by segment (Siemens per meter)
100
sal00_sd NUMBER CTD19+ standard deviation salinity by segment (practical salinity units)
100
sbeox0PS_sd NUMBER CTD19+ standard deviation oxygen saturation by segment (% saturation)
100
sbeox0ML.L_sd NUMBER CTD19+ standard deviation oxygen concentration by segment (mg/L)
100
flECO.AFL_sd NUMBER CTD19+ standard deviation flourescence by segment (flouresence units)
100
turbWETntu0_sd NUMBER CTD19+ standard deviation turbidity by segment (NTU - nephelometric turbidity unit)

Attribute Details

ISLAND

CC ID: 839597
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 90
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for the Island in the Main Hawaiian Islands. HAW = Hawaii, LAN = Lanai, MAI = Maui, OAH = Oahu.

Dive_ID

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

Unique ID for each dive/survey representing 4-digit year, 2-digit month, 2-digit day, 1-digit Dive_Number. YYYYMMDD#, where # = Dive_Number for the day.

Local_Date

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

Local Date, mm/d/yyyy

Dive_Number

CC ID: 839598
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Consecutive number of each day's dive, 1-5

Segment

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

Dive segment number for a given dive/survey. Segments represent 5-minute increments (~200 m) and there are typically, but not always, 10 segments per dive/survey. 1-10

Segment_ID

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

Dive_ID with 2-digit Segment appended. YYYYMMDD###, where ### = Dive_Number for the day (1-5) plus the 2-digit Segment (01-10)

StartTime

CC ID: 839610
Seq. Order: 7
Data Storage Type: DATETIME
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Start date and time for the 5-min Segment, mm/d/yyyy hh:mm

EndTime

CC ID: 839595
Seq. Order: 8
Data Storage Type: DATETIME
Required: No
Primary Key: No
Status: Active
Description:

End date and time for the 5-min Segment, mm/d/yyyy hh:mm

ComputedLength

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

Segment length computed by GPS lay-back (meters)

CentroidLAT

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

Mean GPS position, latitude, for each segment (decimal degrees)

CentroidLON

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

Mean GPS position, longitude, for each segment (decimal degrees)

prdM_med

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

CTD 19+ median pressure by segment (decibars)

depSM_med

CC ID: 839593
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

CTD 19+ median depth by segment (meters)

tv290C_med

CC ID: 839613
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median temperature by segment (degrees Celsius)

c0S.m_med

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

CTD19+ median conductivity by segment (Siemens per meter)

sal00_med

CC ID: 839591
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median salinity by segment (practical salinity units)

sbeox0PS_med

CC ID: 839609
Seq. Order: 30
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median oxygen saturation by segment (% saturation)

sbeox0ML.L_med

CC ID: 839602
Seq. Order: 31
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median oxygen concentration by segment (mg/L)

flECO.AFL_med

CC ID: 839588
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median flourescence by segment (flouresence units)

turbWETntu0_med

CC ID: 839601
Seq. Order: 33
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ median turbidity by segment (NTU - nephelometric turbidity unit)

prdM_sd

CC ID: 839596
Seq. Order: 34
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD 19+ standard deviation pressure by segment (decibars)

depSM_sd

CC ID: 839589
Seq. Order: 35
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD 19+ standard deviation depth by segment (meters)

tv290C_sd

CC ID: 839606
Seq. Order: 36
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation temperature by segment (degrees Celsius)

c0S.m_sd

CC ID: 839590
Seq. Order: 37
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation conductivity by segment (Siemens per meter)

sal00_sd

CC ID: 839599
Data Storage Type: NUMBER
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

CTD19+ standard deviation salinity by segment (practical salinity units)

sbeox0PS_sd

CC ID: 845877
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation oxygen saturation by segment (% saturation)

sbeox0ML.L_sd

CC ID: 845878
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation oxygen concentration by segment (mg/L)

flECO.AFL_sd

CC ID: 845879
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation flourescence by segment (flouresence units)

turbWETntu0_sd

CC ID: 845880
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

CTD19+ standard deviation turbidity by segment (NTU - nephelometric turbidity unit)

Catalog Details

Catalog Item ID: 56270
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-05-10 08:32+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-30