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 > Hawaiian Archipelago > National Coral Reef Monitoring Program: Shallow... >

ESD_NCRMP_CTD_DataDictionary_HI

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36819  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Conductivity-Temperature-Depth Entity and Attributes

Description

Column descriptions for CTD datasets.

Entity Information

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_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.
OCC_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.
ISLANDCODE
Text 		3-Letter unique code for ISLAND.
ISLAND
Text 		Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).
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 ISLANDCODE), 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.
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).
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.

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_CTD_DataDictionary_HI
Short Name: CTD Entity
Abstract:

Conductivity-Temperature-Depth Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Column descriptions for CTD datasets.
Change Summary:

As of 2022, SHALLOWCTDID was deprecated and CTDCASTNAME was generated.

Current relevant columns are detailed below.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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_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
 OCC_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
 ISLANDCODE Text 3-Letter unique code for ISLAND.
100
 ISLAND Text Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).
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 ISLANDCODE), 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
 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
 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.

Attribute Details

CTDCASTNAME

CC ID: 1044689
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: 1044690
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: 1044691
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_REA_SITE

CC ID: 1044693
Seq. Order: 4
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.

OCC_CRUISE

CC ID: 1044694
Seq. Order: 5
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Mission identifier.

REGIONCODE

CC ID: 1044695
Seq. Order: 6
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Code for REGION.

REGION

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

ISLANDCODE

CC ID: 1044697
Seq. Order: 8
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for ISLAND.

ISLAND

CC ID: 1044698
Seq. Order: 9
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).

ASSOC_OCC_SITEID

CC ID: 1044692
Seq. Order: 10
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 ISLANDCODE), 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.

LATITUDE

CC ID: 1044699
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: 1044700
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: 1044701
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: 1044702
Seq. Order: 14
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

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

OFFSHORE_YN

CC ID: 1044704
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: 1044705
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: 1044706
Seq. Order: 18
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Measured pressure value in decibars.

DEPTH_M

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

Calculated depth value in meters.

TEMP_DEGC

CC ID: 1044708
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: 1044709
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: 1044710
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: 1044711
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 Details

Catalog Item ID: 36819
GUID: gov.noaa.nmfs.inport:36819
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-02-15 20:04+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-04-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-04-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-04-01