Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: ESD_DS_DataDict_2015_CT_SUMMARY
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 as well as notes for instruments deployed.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Metadata entities and attributes for diel surveys. Includes the summary details for the deployment of each diel suite, by DSUITEID. At different sites different instruments may have been deployed, or there may have been a failure in an instrument.

Change Summary:

In 2021, a unique identifier for diel suite deployments was included as DSUITEID to improve data structure across data tables. Other columns were renamed or added to improve data management efficiency.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DSUITEID NUMERIC Unique identifier for each Diel Suite deployed
100
REGION TEXT The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
REGIONCODE TEXT Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
100
YEAR NUMERIC Year diel suite was deployed
100
CRUISE_ID TEXT Mission Identifier
100
EXPO_CODE TEXT Defined as the Ship ICES code + departure date formatted as YYYYMMDD
100
NOAA_MISSIONID TEXT Official Mission ID assigned by OMAO
100
LEG TEXT If multiple legs are spanned by one round, numbers are separated by a comma (e.g. '2,3')
100
CRUISE_COMMON_NAME TEXT More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
100
MISSION_CODE TEXT A single designation that applies to all the rounds associated with a given mission/cruise
100
LOCATION TEXT Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100
LOCATIONCODE TEXT 3-Letter unique code for LOCATION.
100
OCC_SITEID TEXT A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
100
LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given Site
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84, for the given Site
100
DEPTH_M NUMERIC OCC Survey depth (m) from dive computer at diel suite deployment
100
VALIDDATASTART DATE Time and Date of earliest vaild data record
100
VALIDDATAEND DATE Time and Date of latest vaild data record
100
DEPLOY_SITEVISITID NUMERIC Unique Identifier for Deployment SITE_VISIT record
100
RETRIEVE_SITEVISITID NUMERIC Unique Identifier for Retrieval SITE_VISIT record
100
ADCP_YN TEXT Flag to indicate if ADCP data is available for a SiteID (yes or no).
100
CTD_YN TEXT Flag to indicate if CTD data is available for a SiteID (yes or no).
100
OXYGEN_YN TEXT Flag to indicate if DO data is available for a SiteID (yes or no).
100
PAR_YN TEXT Flag to indicate if PAR datais available for a SiteID (yes or no).
100
PH_YN TEXT Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no).
100
WATERSAMPLE_YN TEXT Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no).
100
ADCP_SAMPLEINTERVAL_SEC NUMERIC Sample interval for ADCP data.
100
CTD_SAMPLEINTERVAL_SEC NUMERIC Sample interval for CTD data.
100
OXYGEN_SAMPLEINTERVAL_SEC NUMERIC Sample interval for DO data.
100
PAR_SAMPLEINTERVAL_SEC NUMERIC Sample interval for PAR data.
100
PH_SAMPLEINTERVAL_SEC NUMERIC Sample interval for pH data.
100
WATERSAMPLE_SAMPLEINTERVAL_SEC NUMERIC 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

DSUITEID

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

Unique identifier for each Diel Suite deployed

REGION

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

The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

REGIONCODE

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

Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).

YEAR

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

Year diel suite was deployed

CRUISE_ID

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

Mission Identifier

EXPO_CODE

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

Defined as the Ship ICES code + departure date formatted as YYYYMMDD

NOAA_MISSIONID

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

Official Mission ID assigned by OMAO

LEG

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

If multiple legs are spanned by one round, numbers are separated by a comma (e.g. '2,3')

CRUISE_COMMON_NAME

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

More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]

MISSION_CODE

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

A single designation that applies to all the rounds associated with a given mission/cruise

LOCATION

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

Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).

LOCATIONCODE

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

3-Letter unique code for LOCATION.

OCC_SITEID

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

A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given Site

LONGITUDE

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

Longitude in decimal degrees, WGS84, for the given Site

DEPTH_M

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

OCC Survey depth (m) from dive computer at diel suite deployment

VALIDDATASTART

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

Time and Date of earliest vaild data record

VALIDDATAEND

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

Time and Date of latest vaild data record

DEPLOY_SITEVISITID

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

Unique Identifier for Deployment SITE_VISIT record

RETRIEVE_SITEVISITID

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

Unique Identifier for Retrieval SITE_VISIT record

ADCP_YN

CC ID: 1078723
Seq. Order: 22
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).

CTD_YN

CC ID: 1078724
Seq. Order: 23
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).

OXYGEN_YN

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

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

PAR_YN

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

Flag to indicate if PAR datais available for a SiteID (yes or no).

PH_YN

CC ID: 1078727
Seq. Order: 26
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).

WATERSAMPLE_YN

CC ID: 1078728
Seq. Order: 27
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).

ADCP_SAMPLEINTERVAL_SEC

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

Sample interval for ADCP data.

CTD_SAMPLEINTERVAL_SEC

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

Sample interval for CTD data.

OXYGEN_SAMPLEINTERVAL_SEC

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

Sample interval for DO data.

PAR_SAMPLEINTERVAL_SEC

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

Sample interval for PAR data.

PH_SAMPLEINTERVAL_SEC

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

Sample interval for pH data.

WATERSAMPLE_SAMPLEINTERVAL_SEC

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

Sample interval for water sample collection.

NOTES

CC ID: 1078735
Seq. Order: 34
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
GUID: gov.noaa.nmfs.inport: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: 2022-08-09 17:11+0000
Metadata Record Published: 2021-09-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-09-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-09-01