Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Pacific Remote Island Areas > National Coral Reef Monitoring Program: Shallow... >

ESD_NCRMP_CTD_DataDictionary_PRIAs

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36717 | Updated: January 13, 2025 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Conductivity-Temperature-Depth Entity and Attributes

Description

Conductivity-Temperature-Depth Entity

Entity Type
Spreadsheet

Data Attribute / Type	Description
CTDCASTNAME TEXT	Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.
CTDDATAID NUMERIC	Unique numeric ID for each depth bin within a CTD cast (6-digit number).
CTDCASTID NUMERIC	Unique numeric ID of CTD cast (4-digit number).
ASSOC_OCC_SITEID TEXT	An identifier for the fixed climate site associated with the CTD cast, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. CTD casts are assigned an associated OCC_SITEID (ASSOC_OCC_SITEID) rather than an OCC_SITEID because the CTD profile includes the entire water column rather than a single depth on the benthos. A CTD cast is assigned an ASSOC_OCC_SITEID only if its coordinates are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned.
ASSOC_REA_SITE TEXT	An identifier for the ecological site at the island or atoll (LOCATION) associated with the CTD cast. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
CRUISE TEXT	Mission identifier.
REGIONCODE TEXT	Code for REGION.
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.
LOCATIONCODE TEXT	3-Letter unique code for LOCATION.
LOCATION TEXT	Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).
LATITUDE NUMERIC	Latitude in decimal degrees, WGS84, for the CTD cast.
LONGITUDE NUMERIC	Longitude in decimal degrees, WGS84, for the CTD cast.
UTCDATETIME DATE	UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss).
CASTYEAR NUMERIC	4-digit year the CTD cast was conducted (UTCDATETIME).
WATERSAMPLE TEXT	A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.
OFFSHORE_YN TEXT	CTD cast was/was not (YES/NO) conducted offshore, where offshore is defined as a cast location (LATITUDE and LONGITUDE) more than 10km away from land (for islands) or the 20m depth contour (for atolls).
SURVEY_DESIGN TEXT	NCRMP survey design associated with the CTD cast. Survey designs include: casts conducted at permanent climate sites (Permanent); casts co-located with fish or benthic stratified random survey sites (Stratified_Random); casts at random sites not associated with climate, benthic, or fish sites (Random); and casts conducted offshore to collect end member data (End_member).
PRESSURE_DB NUMERIC	Measured pressure value in decibars.
DEPTH_M NUMERIC	Calculated depth value in meters.
TEMP_DEGC NUMERIC	Measured temperature value in degrees Celsius.
COND_S_PER_M NUMERIC	Measured conductivity value in Siemens per meter.
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.

Data Attribute / Type

Description

CTDCASTNAME
TEXT

Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.

CTDDATAID
NUMERIC

Unique numeric ID for each depth bin within a CTD cast (6-digit number).

CTDCASTID
NUMERIC

Unique numeric ID of CTD cast (4-digit number).

ASSOC_OCC_SITEID
TEXT

An identifier for the fixed climate site associated with the CTD cast, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. CTD casts are assigned an associated OCC_SITEID (ASSOC_OCC_SITEID) rather than an OCC_SITEID because the CTD profile includes the entire water column rather than a single depth on the benthos. A CTD cast is assigned an ASSOC_OCC_SITEID only if its coordinates are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned.

ASSOC_REA_SITE
TEXT

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

CRUISE
TEXT

Mission identifier.

REGIONCODE
TEXT

Code for REGION.

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.

LOCATIONCODE
TEXT

3-Letter unique code for LOCATION.

LOCATION
TEXT

Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).

LATITUDE
NUMERIC

Latitude in decimal degrees, WGS84, for the CTD cast.

LONGITUDE
NUMERIC

Longitude in decimal degrees, WGS84, for the CTD cast.

UTCDATETIME
DATE

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

CASTYEAR
NUMERIC

4-digit year the CTD cast was conducted (UTCDATETIME).

WATERSAMPLE
TEXT

A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.

OFFSHORE_YN
TEXT

CTD cast was/was not (YES/NO) conducted offshore, where offshore is defined as a cast location (LATITUDE and LONGITUDE) more than 10km away from land (for islands) or the 20m depth contour (for atolls).

SURVEY_DESIGN
TEXT

NCRMP survey design associated with the CTD cast. Survey designs include: casts conducted at permanent climate sites (Permanent); casts co-located with fish or benthic stratified random survey sites (Stratified_Random); casts at random sites not associated with climate, benthic, or fish sites (Random); and casts conducted offshore to collect end member data (End_member).

PRESSURE_DB
NUMERIC

Measured pressure value in decibars.

DEPTH_M
NUMERIC

Calculated depth value in meters.

TEMP_DEGC
NUMERIC

Measured temperature value in degrees Celsius.

COND_S_PER_M
NUMERIC

Measured conductivity value in Siemens per meter.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	ESD_NCRMP_CTD_DataDictionary_PRIAs
Short Name:	CTD Entity
Abstract:	Conductivity-Temperature-Depth Entity and Attributes

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	Conductivity-Temperature-Depth Entity
Change Summary:	As of 2018 these are the active / relevant fields: SHALLOWCTDID, CTDDATAKEY, CTDCASTID, ASSOC_OCC_SITEID, ASSOC_REA_SITE, CRUISE, REGIONCODE, REGION, LOCATIONCODE, LOCATION, LATITUDE, LONGITUDE, UTCDATETIME, CASTYEAR, WATERSAMPLE, OFFSHORE_YN, SURVEY_DESIGN, PRESSURE_DB, DEPTH_M, TEMP_DEGC, COND_S_PER_M, SALN_PSU, DENSITY_SIGMAT In 2023, CTDDATAKEY was updated to CTDDATAID , SHALLOWCTDID updated to CTDCASTNAME.

Attribute Summary

	Name	Type	Description
100	CTDCASTNAME	TEXT	Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.
100	CTDDATAID	NUMERIC	Unique numeric ID for each depth bin within a CTD cast (6-digit number).
100	CTDCASTID	NUMERIC	Unique numeric ID of CTD cast (4-digit number).
100	ASSOC_OCC_SITEID	TEXT	An identifier for the fixed climate site associated with the CTD cast, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. CTD casts are assigned an associated OCC_SITEID (ASSOC_OCC_SITEID) rather than an OCC_SITEID because the CTD profile includes the entire water column rather than a single depth on the benthos. A CTD cast is assigned an ASSOC_OCC_SITEID only if its coordinates are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned.
100	ASSOC_REA_SITE	TEXT	An identifier for the ecological site at the island or atoll (LOCATION) associated with the CTD cast. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
100	CRUISE	TEXT	Mission identifier.
100	REGIONCODE	TEXT	Code for REGION.
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	LOCATIONCODE	TEXT	3-Letter unique code for LOCATION.
100	LOCATION	TEXT	Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).
100	LATITUDE	NUMERIC	Latitude in decimal degrees, WGS84, for the CTD cast.
100	LONGITUDE	NUMERIC	Longitude in decimal degrees, WGS84, for the CTD cast.
100	UTCDATETIME	DATE	UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss).
100	CASTYEAR	NUMERIC	4-digit year the CTD cast was conducted (UTCDATETIME).
100	WATERSAMPLE	TEXT	A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.
100	OFFSHORE_YN	TEXT	CTD cast was/was not (YES/NO) conducted offshore, where offshore is defined as a cast location (LATITUDE and LONGITUDE) more than 10km away from land (for islands) or the 20m depth contour (for atolls).
100	SURVEY_DESIGN	TEXT	NCRMP survey design associated with the CTD cast. Survey designs include: casts conducted at permanent climate sites (Permanent); casts co-located with fish or benthic stratified random survey sites (Stratified_Random); casts at random sites not associated with climate, benthic, or fish sites (Random); and casts conducted offshore to collect end member data (End_member).
100	PRESSURE_DB	NUMERIC	Measured pressure value in decibars.
100	DEPTH_M	NUMERIC	Calculated depth value in meters.
100	TEMP_DEGC	NUMERIC	Measured temperature value in degrees Celsius.
100	COND_S_PER_M	NUMERIC	Measured conductivity value in Siemens per meter.
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.

Name

Type

Description

100

CTDCASTNAME

TEXT

Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.

100

CTDDATAID

NUMERIC

Unique numeric ID for each depth bin within a CTD cast (6-digit number).

100

CTDCASTID

NUMERIC

Unique numeric ID of CTD cast (4-digit number).

100

ASSOC_OCC_SITEID

TEXT

100

ASSOC_REA_SITE

TEXT

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

100

CRUISE

TEXT

Mission identifier.

100

REGIONCODE

TEXT

Code for REGION.

100

REGION

TEXT

100

LOCATIONCODE

TEXT

3-Letter unique code for LOCATION.

100

LOCATION

TEXT

Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).

100

LATITUDE

NUMERIC

Latitude in decimal degrees, WGS84, for the CTD cast.

100

LONGITUDE

NUMERIC

Longitude in decimal degrees, WGS84, for the CTD cast.

100

UTCDATETIME

DATE

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

100

CASTYEAR

NUMERIC

4-digit year the CTD cast was conducted (UTCDATETIME).

100

WATERSAMPLE

TEXT

A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.

100

OFFSHORE_YN

TEXT

100

SURVEY_DESIGN

TEXT

100

PRESSURE_DB

NUMERIC

Measured pressure value in decibars.

100

DEPTH_M

NUMERIC

Calculated depth value in meters.

100

TEMP_DEGC

NUMERIC

Measured temperature value in degrees Celsius.

100

COND_S_PER_M

NUMERIC

Measured conductivity value in Siemens per meter.

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.

Attribute Details

CTDCASTNAME

CC ID: 1044583

Seq. Order:	1
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.

CTDDATAID

CC ID: 1044584

Seq. Order:	2
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique numeric ID for each depth bin within a CTD cast (6-digit number).

CTDCASTID

CC ID: 1044585

Seq. Order:	3
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique numeric ID of CTD cast (4-digit number).

ASSOC_OCC_SITEID

CC ID: 1044586

Seq. Order:	4
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the fixed climate site associated with the CTD cast, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. CTD casts are assigned an associated OCC_SITEID (ASSOC_OCC_SITEID) rather than an OCC_SITEID because the CTD profile includes the entire water column rather than a single depth on the benthos. A CTD cast is assigned an ASSOC_OCC_SITEID only if its coordinates are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned.

ASSOC_REA_SITE

CC ID: 1044587

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 CTD cast. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.

CRUISE

CC ID: 1044588

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

REGIONCODE

CC ID: 1044589

Seq. Order:	7
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for REGION.

REGION

CC ID: 1044590

Seq. Order:	8
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.

LOCATIONCODE

CC ID: 1044591

Seq. Order:	9
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	3-Letter unique code for LOCATION.

LOCATION

CC ID: 1044592

Seq. Order:	10
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).

LATITUDE

CC ID: 1044593

Seq. Order:	11
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the CTD cast.

LONGITUDE

CC ID: 1044594

Seq. Order:	12
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude in decimal degrees, WGS84, for the CTD cast.

UTCDATETIME

CC ID: 1044595

Seq. Order:	13
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss).

CASTYEAR

CC ID: 1044596

Seq. Order:	14
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit year the CTD cast was conducted (UTCDATETIME).

WATERSAMPLE

CC ID: 1044597

Seq. Order:	15
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.

OFFSHORE_YN

CC ID: 1044598

Seq. Order:	16
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	CTD cast was/was not (YES/NO) conducted offshore, where offshore is defined as a cast location (LATITUDE and LONGITUDE) more than 10km away from land (for islands) or the 20m depth contour (for atolls).

SURVEY_DESIGN

CC ID: 1044599

Seq. Order:	17
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	NCRMP survey design associated with the CTD cast. Survey designs include: casts conducted at permanent climate sites (Permanent); casts co-located with fish or benthic stratified random survey sites (Stratified_Random); casts at random sites not associated with climate, benthic, or fish sites (Random); and casts conducted offshore to collect end member data (End_member).

PRESSURE_DB

CC ID: 1044600

Seq. Order:	18
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Measured pressure value in decibars.

DEPTH_M

CC ID: 1044601

Seq. Order:	19
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Calculated depth value in meters.

TEMP_DEGC

CC ID: 1044602

Seq. Order:	20
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Measured temperature value in degrees Celsius.

COND_S_PER_M

CC ID: 1044603

Seq. Order:	21
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Measured conductivity value in Siemens per meter.

SALN_PSU

CC ID: 1044604

Seq. Order:	22
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Calculated salinity value in Practical Salinity Units (PSU).

DENSITY_SIGMAT

CC ID: 1044605

Seq. Order:	23
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.

Catalog Item ID:	36717
GUID:	gov.noaa.nmfs.inport:36717
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2017-02-09 18:30+0000
Metadata Record Last Modified By:	Lori H Luers
Metadata Record Last Modified:	2025-01-13 22:24+0000
Metadata Record Published:	2025-01-13
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-03-10
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-03-10

ESD_NCRMP_CTD_DataDictionary_PRIAs

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CTDCASTNAME

CTDDATAID

CTDCASTID

ASSOC_OCC_SITEID

ASSOC_REA_SITE

CRUISE

REGIONCODE

REGION

LOCATIONCODE

LOCATION

LATITUDE

LONGITUDE

UTCDATETIME

CASTYEAR

WATERSAMPLE

OFFSHORE_YN

SURVEY_DESIGN

PRESSURE_DB

DEPTH_M

TEMP_DEGC

COND_S_PER_M

SALN_PSU

DENSITY_SIGMAT

Catalog Details