Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Conductivity-Temperature-Depth Entity and Attributes

Description

Conductivity-Temperature-Depth Entity

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
SHALLOWCTDID
Text
Unique ID for CTD Cast: typically cruise/MISSION ID, REGION (optional), 3-letter island code (LOCATIONCODE), last 4 digits of CTD serial number, cast number/id.
CTDCASTID
NUMERIC
Unique numeric ID of CTD cast (4-digit number).
REGIONCODE
Text
Code for REGION.
CASTYEAR
NUMERIC
4-digit year the CTD cast was conducted (UTCDATETIME).
CRUISE
Text
Mission identifier.
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).
WATERSAMPLE
Text
A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.
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.
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.
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
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).
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.
CTDDATAKEY
NUMERIC
Unique numeric ID for each depth bin within a CTD cast (6-digit number).

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

Conductivity-Temperature-Depth Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Conductivity-Temperature-Depth Entity

Change Summary:

Revised 10-2021 to include active/relevant fields.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SHALLOWCTDID Text Unique ID for CTD Cast: typically cruise/MISSION ID, REGION (optional), 3-letter island code (LOCATIONCODE), last 4 digits of CTD serial number, cast number/id.
100
CTDCASTID NUMERIC Unique numeric ID of CTD cast (4-digit number).
100
REGIONCODE Text Code for REGION.
100
CASTYEAR NUMERIC 4-digit year the CTD cast was conducted (UTCDATETIME).
100
CRUISE Text Mission identifier.
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
WATERSAMPLE Text A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.
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.
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
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 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
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
CTDDATAKEY NUMERIC Unique numeric ID for each depth bin within a CTD cast (6-digit number).

Attribute Details

SHALLOWCTDID

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

Unique ID for CTD Cast: typically cruise/MISSION ID, REGION (optional), 3-letter island code (LOCATIONCODE), last 4 digits of CTD serial number, cast number/id.

CTDCASTID

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

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

REGIONCODE

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

Code for REGION.

CASTYEAR

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

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

CRUISE

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

Mission identifier.

LOCATIONCODE

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

3-Letter unique code for LOCATION.

LOCATION

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

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

LONGITUDE

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

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

UTCDATETIME

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

WATERSAMPLE

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

PRESSURE_DB

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

Measured pressure value in decibars.

DEPTH_M

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

Calculated depth value in meters.

TEMP_DEGC

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

Measured temperature value in degrees Celsius.

COND_S_PER_M

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

Measured conductivity value in Siemens per meter.

SALN_PSU

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

Calculated salinity value in Practical Salinity Units (PSU).

DENSITY_SIGMAT

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

ASSOC_OCC_SITEID

CC ID: 1055852
Seq. Order: 18
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: 1055853
Seq. Order: 19
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.

OFFSHORE_YN

CC ID: 1055889
Seq. Order: 20
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: 1055890
Seq. Order: 21
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

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).

REGION

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

CTDDATAKEY

CC ID: 1092154
Seq. Order: 23
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).

Catalog Details

Catalog Item ID: 45985
GUID: gov.noaa.nmfs.inport:45985
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-05-04 05:34+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-10-28
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-10-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-10-28