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 > Marianas Archipelago > National Coral Reef Monitoring Program: Diel se... >

ESD_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:55421  |  Updated: March 11, 2025  |  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 CTD cast 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 		A single designation that applies to all the rounds associated with a given mission/cruise.
EXPOCODE
TEXT 		Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
MISSION_CODE
TEXT 		More descriptive name of cruise/mission.
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 site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
ASSOC_REA_SITE
TEXT 		An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
LATITUDE
NUMERIC 		Latitude in decimal degrees, WGS84, for the given site.
LONGITUDE
NUMERIC 		Longitude in decimal degrees, WGS84, for the given site.
SITE_DEPTH_M
NUMERIC 		Depth of sensor deployment site in meters.
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).
TCM_YN
TEXT 		Flag to indicate if tilt current meter data is available for a SiteID (yes or no).
ADCP_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for ADCP data. NULL if no data.
CTD_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for CTD data. NULL if no data.
OXYGEN_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for DO data. NULL if no data.
PAR_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for PAR data. NULL if no data.
PH_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for pH data. NULL if no data.
WATERSAMPLE_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for water sample data. NULL if no data.
TCM_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for TCM data. NULL if no data.
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_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary
Short Name: ESD_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary
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 CTD cast 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 A single designation that applies to all the rounds associated with a given mission/cruise.
100
 EXPOCODE TEXT Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
100
 MISSION_CODE TEXT More descriptive name of cruise/mission.
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 site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
100
 ASSOC_REA_SITE TEXT An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
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
 SITE_DEPTH_M NUMERIC Depth of sensor deployment site in meters.
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
 TCM_YN TEXT Flag to indicate if tilt current meter data is available for a SiteID (yes or no).
100
 ADCP_SAMPLEINTERVAL_SEC NUMERIC Sample interval for ADCP data. NULL if no data.
100
 CTD_SAMPLEINTERVAL_SEC NUMERIC Sample interval for CTD data. NULL if no data.
100
 OXYGEN_SAMPLEINTERVAL_SEC NUMERIC Sample interval for DO data. NULL if no data.
100
 PAR_SAMPLEINTERVAL_SEC NUMERIC Sample interval for PAR data. NULL if no data.
100
 PH_SAMPLEINTERVAL_SEC NUMERIC Sample interval for pH data. NULL if no data.
100
 WATERSAMPLE_SAMPLEINTERVAL_SEC NUMERIC Sample interval for water sample data. NULL if no data.
100
 TCM_SAMPLEINTERVAL_SEC NUMERIC Sample interval for TCM data. NULL if no data.
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 CTD cast 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:

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

EXPOCODE

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.

MISSION_CODE

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

More descriptive name of cruise/mission.

LOCATION

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

A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.

ASSOC_REA_SITE

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

An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.

LATITUDE

CC ID: 1078127
Seq. Order: 12
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: 13
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

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

SITE_DEPTH_M

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

Depth of sensor deployment site in meters.

VALIDDATASTART

CC ID: 1078130
Seq. Order: 15
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: 16
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: 17
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: 18
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: 19
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: 20
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: 21
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: 22
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: 23
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: 24
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).

TCM_YN

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

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

ADCP_SAMPLEINTERVAL_SEC

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

Sample interval for ADCP data. NULL if no data.

CTD_SAMPLEINTERVAL_SEC

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

Sample interval for CTD data. NULL if no data.

OXYGEN_SAMPLEINTERVAL_SEC

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

Sample interval for DO data. NULL if no data.

PAR_SAMPLEINTERVAL_SEC

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

Sample interval for PAR data. NULL if no data.

PH_SAMPLEINTERVAL_SEC

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

Sample interval for pH data. NULL if no data.

WATERSAMPLE_SAMPLEINTERVAL_SEC

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

Sample interval for water sample data. NULL if no data.

TCM_SAMPLEINTERVAL_SEC

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

Sample interval for TCM data. NULL if no data.

NOTES

CC ID: 1078146
Seq. Order: 33
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: Lori H Luers
Metadata Record Last Modified: 2025-03-11 17:14+0000
Metadata Record Published: 2025-03-11
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