Item Identification

Title: DielSurvey_Entity_Meta
Status: Completed
Abstract:

Metadata entity and attributes for diel surveys. Includes information for each site where diel surveys were conducted in that particular region and year.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Metadata entities and attributes for diel surveys.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Region Text Code for the region surveyed in the Pacific.
100
Year NUMERIC 4-digit year the survey was conducted (UTCdateStart).
100
Mission Text Cruise/mission ID and REGION.
100
Location Text Name of island or atoll where SiteID is located in the Pacific (REGION).
100
Site TEXT Sub-location of a LOCATION such as a bay, city, reef area, etc. that can contain one to many SITEIDs.
100
SiteID Text The code for the site surveyed at the island or atoll (LOCATION). Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.
100
Latitude NUMERIC Latitude in decimal degrees, WGS84, for the given SiteID.
100
Longitude NUMERIC Longitude in decimal degrees, WGS84, for the given SiteID.
100
SiteDepthClass TEXT Categories a SiteID as shallow (~5 m) or deep (>15 m).
100
Depth_m NUMERIC Depth of SiteID in meters.
100
UTCdateStart DATE UTC date the diel survey started (m/d/yyyy).
100
UTCdateEnd DATE UTC date the diel survey ended (m/d/yyyy).
100
CTD_deploy TEXT Flag to indicate if CTD data is available for a SiteID (yes or no).
100
pH_deploy TEXT Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no).
100
ADCP_deploy TEXT Flag to indicate if ADCP data is available for a SiteID (yes or no).
100
WaterSample_deploy TEXT Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no).
100
Oxygen TEXT Flag to indicate if oxygen data is available for a SiteID (yes or no). Oxygen data is included in CTD file.
100
CTD_SampleInterval TEXT Sample interval for CTD data.
100
pH_SampleInterval TEXT Sample interval for pH data.
100
ADCP_SampleInterval TEXT Sample interval for ADCP data.
100
WaterSample_SampleInterval TEXT Sample interval for water sample collection.
100
Notes TEXT Comments about the diel survey conducted at the SiteID provided by OCC team that may be useful to the data user.

Attribute Details

Region

CC ID: 846539
Seq. Order: 1
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Code for the region surveyed in the Pacific.

Year

CC ID: 846545
Seq. Order: 2
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

4-digit year the survey was conducted (UTCdateStart).

Mission

CC ID: 846537
Seq. Order: 3
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Cruise/mission ID and REGION.

Location

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

Name of island or atoll where SiteID is located in the Pacific (REGION).

Site

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

Sub-location of a LOCATION such as a bay, city, reef area, etc. that can contain one to many SITEIDs.

SiteID

CC ID: 846540
Seq. Order: 5
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The code for the site surveyed at the island or atoll (LOCATION). Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.

Latitude

CC ID: 846534
Seq. Order: 6
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given SiteID.

Longitude

CC ID: 846536
Seq. Order: 7
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given SiteID.

SiteDepthClass

CC ID: 846568
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Categories a SiteID as shallow (~5 m) or deep (>15 m).

Depth_m

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

Depth of SiteID in meters.

UTCdateStart

CC ID: 846542
Seq. Order: 9
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

UTC date the diel survey started (m/d/yyyy).

UTCdateEnd

CC ID: 846541
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

UTC date the diel survey ended (m/d/yyyy).

CTD_deploy

CC ID: 846532
Seq. Order: 11
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if CTD data is available for a SiteID (yes or no).

pH_deploy

CC ID: 846547
Seq. Order: 12
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no).

ADCP_deploy

CC ID: 846530
Seq. Order: 13
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if ADCP data is available for a SiteID (yes or no).

WaterSample_deploy

CC ID: 846544
Seq. Order: 14
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no).

Oxygen

CC ID: 846569
Seq. Order: 14
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if oxygen data is available for a SiteID (yes or no). Oxygen data is included in CTD file.

CTD_SampleInterval

CC ID: 846531
Seq. Order: 15
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for CTD data.

pH_SampleInterval

CC ID: 846546
Seq. Order: 16
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for pH data.

ADCP_SampleInterval

CC ID: 846529
Seq. Order: 17
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for ADCP data.

WaterSample_SampleInterval

CC ID: 846543
Seq. Order: 18
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for water sample collection.

Notes

CC ID: 846538
Seq. Order: 20
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Comments about the diel survey conducted at the SiteID provided by OCC team that may be useful to the data user.

Catalog Details

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