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_CTD_DataDictionary

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:55420  |  Updated: March 11, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Conductivity-Temperature-Depth entities and attributes for diel surveys.

Description

Conductivity-Temperature-Depth entity for diel surveys.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DSUITEID
NUMERIC 		Unique identifier for each Diel Suite deployed.
EXPOCODE
TEXT 		Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
CRUISE_ID
TEXT 		A single designation that applies to all the rounds associated with a given mission/cruise.
MISSION_CODE
TEXT 		More descriptive name of cruise/mission.
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.
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.
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).
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.
LATITUDE
NUMERIC 		Latitude in decimal degrees, WGS84, for the given site.
LONGITUDE
NUMERIC 		Longitude in decimal degrees, WGS84, for the given site.
DEPTH_M_CALC
NUMERIC 		Depth calculated from pressure in meters.
SITE_DEPTH_M
NUMERIC 		Depth of sensor deployment site in meters.
YEAR
NUMERIC 		Year of the mission.
UTCDATETIME
DATE 		UTC date and time of observation (yyyy-mm-dd hh:mm:ss).
CTD_SAMPLEINTERVAL_SEC
NUMERIC 		Sample interval for CTD data in seconds.
PRESSURE_DB
NUMERIC 		Measured pressure value in decibars.
TEMP_DEGC
NUMERIC 		Measured temperature value in degrees Celsius.
SALN_PSU
NUMERIC 		Calculated salinity value in Practical Salinity Units (PSU) .
DENSITY_SIGMAT
NUMERIC 		Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.
COND_S_PER_M
NUMERIC 		Measured conductivity value in Siemens per meter. Occasionally conductivity data cannot be recovered from the CTD, resulting in NULL values.

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_CTD_DataDictionary
Short Name: ESD_NCRMP_DS_2022_MARIAN_CTD_DataDictionary
Status: Completed
Abstract:

Conductivity-Temperature-Depth entities and attributes for diel surveys.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Conductivity-Temperature-Depth entity for diel surveys.
Change Summary:

In 2021 columns were renamed and added to standardize data structure.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 DSUITEID NUMERIC Unique identifier for each Diel Suite deployed.
100
 EXPOCODE TEXT Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
100
 CRUISE_ID TEXT A single designation that applies to all the rounds associated with a given mission/cruise.
100
 MISSION_CODE TEXT More descriptive name of cruise/mission.
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
 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
 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
 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
 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_CALC NUMERIC Depth calculated from pressure in meters.
100
 SITE_DEPTH_M NUMERIC Depth of sensor deployment site in meters.
100
 YEAR NUMERIC Year of the mission.
100
 UTCDATETIME DATE UTC date and time of observation (yyyy-mm-dd hh:mm:ss).
100
 CTD_SAMPLEINTERVAL_SEC NUMERIC Sample interval for CTD data in seconds.
100
 PRESSURE_DB NUMERIC Measured pressure value in decibars.
100
 TEMP_DEGC NUMERIC Measured temperature value in degrees Celsius.
100
 SALN_PSU NUMERIC Calculated salinity value in Practical Salinity Units (PSU) .
100
 DENSITY_SIGMAT NUMERIC Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.
100
 COND_S_PER_M NUMERIC Measured conductivity value in Siemens per meter. Occasionally conductivity data cannot be recovered from the CTD, resulting in NULL values.

Attribute Details

DSUITEID

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

Unique identifier for each Diel Suite deployed.

EXPOCODE

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

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

CRUISE_ID

CC ID: 1078048
Seq. Order: 3
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.

MISSION_CODE

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

More descriptive name of cruise/mission.

ASSOC_REA_SITE

CC ID: 1078050
Seq. Order: 5
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.

OCC_SITEID

CC ID: 1078051
Seq. Order: 6
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.

REGION

CC ID: 1078052
Seq. Order: 7
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: 1078053
Seq. Order: 8
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).

LOCATION

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

3-Letter unique code for LOCATION.

LATITUDE

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

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

LONGITUDE

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

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

DEPTH_M_CALC

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

Depth calculated from pressure in meters.

SITE_DEPTH_M

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

Depth of sensor deployment site in meters.

YEAR

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

Year of the mission.

UTCDATETIME

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

UTC date and time of observation (yyyy-mm-dd hh:mm:ss).

CTD_SAMPLEINTERVAL_SEC

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

Sample interval for CTD data in seconds.

PRESSURE_DB

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

Measured pressure value in decibars.

TEMP_DEGC

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

Measured temperature value in degrees Celsius.

SALN_PSU

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

Calculated salinity value in Practical Salinity Units (PSU) .

DENSITY_SIGMAT

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

Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.

COND_S_PER_M

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

Measured conductivity value in Siemens per meter. Occasionally conductivity data cannot be recovered from the CTD, resulting in NULL values.

Catalog Details

Catalog Item ID: 55420
GUID: gov.noaa.nmfs.inport:55420
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-01-31 21:02+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