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_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

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

	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.

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