ESD_NCRMP_CTD_DataDictionary_HA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36819 | Updated: January 13, 2025 | Published / External
Item Identification
Title: | ESD_NCRMP_CTD_DataDictionary_HA |
---|---|
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. LOCATION and LOCATIONCODE (used in 2013, 2016, 2024) are equivalent to ISLAND and ISLANDCODE (used in 2019). |
Data Attributes
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 or 5-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
|
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
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
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique numeric ID of CTD cast (4 or 5-digit number). |
ASSOC_OCC_SITEID
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
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
Seq. Order: | 6 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier. |
REGIONCODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for REGION. |
REGION
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-Letter unique code for LOCATION. |
LOCATION
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
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
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
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
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
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
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
Seq. Order: | 18 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured pressure value in decibars. |
DEPTH_M
Seq. Order: | 19 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated depth value in meters. |
TEMP_DEGC
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
Seq. Order: | 21 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured conductivity value in Siemens per meter. |
SALN_PSU
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
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: | Lori H Luers |
Metadata Record Last Modified: | 2025-01-13 22:25+0000 |
Metadata Record Published: | 2025-01-13 |
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 |