ESD_LBSP_CTD_DataDictionary_Aua_2022
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:69889 | Updated: June 1, 2023 | Published / External
Item Identification
Title: | ESD_LBSP_CTD_DataDictionary_Aua_2022 |
---|---|
Abstract: |
Conductivity-Temperature-Depth Entity and Attributes |
Entity Information
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 |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CTDCASTNAME | 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
|
CTDDATAID | Long Integer | Unique numeric ID for each depth bin within a CTD cast (6-digit number). | |
100
|
CTDCASTID | Long Integer | 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
|
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 LOCATION. | |
100
|
ISLAND | Text | Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION). | |
100
|
LATITUDE | Double | Latitude in decimal degrees, WGS84, for the CTD cast. | |
100
|
LONGITUDE | Double | Longitude in decimal degrees, WGS84, for the CTD cast. | |
100
|
UTCDATETIME | Date/Time | UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss); for MP2206 only hh:mm was recorded. | |
100
|
CASTYEAR | Double | 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 | Double | Measured pressure value in decibars. | |
100
|
DEPTH_M | Double | Calculated depth value in meters. | |
100
|
TEMP_DEGC | Double | Measured temperature value in degrees Celsius. | |
100
|
COND_S_PER_M | Double | Measured conductivity value in Siemens per meter. | |
100
|
SALN_PSU | Double | Calculated salinity value in Practical Salinity Units (PSU). | |
100
|
DENSITY_SIGMAT | Double | 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 CTD Cast: typically cruise/MISSION ID, REGION (optional), 3-letter island code (LOCATIONCODE), last 4 digits of CTD serial number, cast number/id. |
CTDDATAID
Seq. Order: | 2 |
---|---|
Data Storage Type: | Long Integer |
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: | Long Integer |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique numeric ID of CTD cast (4-digit number). |
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. |
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. |
ISLANDCODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-Letter unique code for LOCATION. |
ISLAND
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: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the CTD cast. |
LONGITUDE
Seq. Order: | 12 |
---|---|
Data Storage Type: | Double |
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/Time |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss); for MP2206 only hh:mm was recorded. |
CASTYEAR
Seq. Order: | 14 |
---|---|
Data Storage Type: | Double |
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: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured pressure value in decibars. |
DEPTH_M
Seq. Order: | 19 |
---|---|
Data Storage Type: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated depth value in meters. |
TEMP_DEGC
Seq. Order: | 20 |
---|---|
Data Storage Type: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured temperature value in degrees Celsius. |
COND_S_PER_M
Seq. Order: | 21 |
---|---|
Data Storage Type: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured conductivity value in Siemens per meter. |
SALN_PSU
Seq. Order: | 22 |
---|---|
Data Storage Type: | Double |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated salinity value in Practical Salinity Units (PSU). |
DENSITY_SIGMAT
Data Storage Type: | Double |
---|---|
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: | 69889 |
---|---|
GUID: | gov.noaa.nmfs.inport:69889 |
Metadata Record Created By: | Lori H Luers |
Metadata Record Created: | 2023-05-11 02:12+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2023-06-01 18:47+0000 |
Metadata Record Published: | 2023-05-17 |
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 |