Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Hawaiian Archipelago > National Coral Reef Monitoring Program: Diel se... >

ESD_DS_DataDict_2019_HI_SUMMARY

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:55938  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
DSUITEID
NUMERIC 		Unique identifier for each Diel Suite deployed
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.
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).
YEAR
NUMERIC 		Year diel suite was deployed
CRUISE_ID
TEXT 		Mission Identifier
EXPO_CODE
TEXT 		Defined as the Ship ICES code + departure date formatted as YYYYMMDD
NOAA_MISSIONID
TEXT 		Official Mission ID assigned by OMAO
LEG
TEXT 		If multiple legs are spanned by one round, numbers are separated by a comma (e.g. '2,3')
CRUISE_COMMON_NAME
TEXT 		More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
MISSION_CODE
TEXT 		A single designation that applies to all the rounds associated with a given mission/cruise
LOCATION
TEXT 		Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
TEXT 		3-Letter unique code for LOCATION.
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.
LATITUDE
NUMERIC 		Latitude in decimal degrees, WGS84, for the given Site
LONGITUDE
NUMERIC 		Longitude in decimal degrees, WGS84, for the given Site
DEPTH_M
NUMERIC 		OCC Survey depth (m) from dive computer at diel suite deployment
VALIDDATASTART
DATE 		Time and Date of earliest vaild data record
VALIDDATAEND
DATE 		Time and Date of latest vaild data record
DEPLOY_SITEVISITID
NUMERIC 		Unique Identifier for Deployment SITE_VISIT record
RETRIEVE_SITEVISITID
NUMERIC 		Unique Identifier for Retrieval SITE_VISIT record
ADCP_YN
TEXT 		Flag to indicate if ADCP data is available for a SiteID (yes or no).
CTD_YN
TEXT 		Flag to indicate if CTD data is available for a SiteID (yes or no).
OXYGEN_YN
TEXT 		Flag to indicate if DO data is available for a SiteID (yes or no).
PAR_YN
TEXT 		Flag to indicate if PAR datais available for a SiteID (yes or no).
PH_YN
TEXT 		Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no).
WATERSAMPLE_YN
TEXT 		Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no).
ADCP_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for ADCP data.
CTD_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for CTD data.
OXYGEN_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for DO data.
PAR_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for PAR data.
PH_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for pH data.
WATERSAMPLE_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for water sample collection.
NOTES
TEXT 		Comments about the diel survey conducted at the SiteID provided by OCC team that may be useful to the data user.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: ESD_DS_DataDict_2019_HI_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: 1077019
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: 1077052
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: 1077034
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: 1077021
Seq. Order: 4
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Year diel suite was deployed

CRUISE_ID

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

Mission Identifier

EXPO_CODE

CC ID: 1077036
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: 1077037
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Official Mission ID assigned by OMAO

LEG

CC ID: 1077038
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: 1077039
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: 1077040
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: 1077041
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: 1077042
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: 1077043
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: 1077022
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: 1077023
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: 1077024
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: 1077044
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: 1077045
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: 1077046
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: 1077047
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: 1077027
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: 1077025
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: 1077048
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: 1077049
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: 1077026
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: 1077028
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: 1077031
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: 1077029
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: 1077051
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: 1077050
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: 1077030
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: 1077032
Seq. Order: 33
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for water sample collection.

NOTES

CC ID: 1077033
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: 55938
GUID: gov.noaa.nmfs.inport:55938
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-03-22 19:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-08-06
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-08-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-08-06