Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Marianas Archipelago > National Coral Reef Monitoring Program: Diel se... >

ESD_DS_DataDict_2017_CNMI_SUMMARY

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

Item Identification

Title:	ESD_DS_DataDict_2017_CNMI_SUMMARY
Short Name:	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 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

	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.

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: 1078114

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: 1078115

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: 1078116

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: 1078117

Seq. Order:	4
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Year diel suite was deployed

CRUISE_ID

CC ID: 1078118

Seq. Order:	5
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Mission Identifier

EXPO_CODE

CC ID: 1078119

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: 1078120

Seq. Order:	7
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Official Mission ID assigned by OMAO

LEG

CC ID: 1078121

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: 1078122

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: 1078123

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: 1078124

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: 1078125

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: 1078126

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: 1078127

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: 1078128

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: 1078129

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: 1078130

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: 1078131

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: 1078132

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: 1078133

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: 1078134

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: 1078135

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: 1078136

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: 1078137

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: 1078138

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: 1078139

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: 1078140

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: 1078141

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: 1078142

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: 1078143

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: 1078144

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: 1078145

Seq. Order:	33
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Sample interval for water sample collection.

NOTES

CC ID: 1078146

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:	55421
GUID:	gov.noaa.nmfs.inport:55421
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2019-01-31 21:17+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