ESD_NCRMP_CTD_DataDictionary_MARIAN
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36821 | Updated: September 28, 2023 | Published / External
Item Identification
Title: | ESD_NCRMP_CTD_DataDictionary_MARIAN |
---|---|
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: |
As of 2017 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 2022, CTDDATAKEY was updated to CTDDATAID , SHALLOWCTDID updated to CTDCASTNAME. |
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-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. |
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-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). |
WATERSAMPLE
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
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: | 36821 |
---|---|
GUID: | gov.noaa.nmfs.inport:36821 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-02-15 20:07+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2023-09-28 21:36+0000 |
Metadata Record Published: | 2023-09-28 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-04-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-04-23 |