ESD_NCRMP_CTD_DataDictionary_HA
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 36819
| Published / External
Created: 2017-02-15
|
Last Modified: 2025-01-13
Data Set (DS) | ID: 36818
ID: 36819
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | ESD_NCRMP_CTD_DataDictionary_HA |
---|---|
Short Name | CTD Entity |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Conductivity-Temperature-Depth Entity and Attributes |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» 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
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | CTDCASTNAME | Text | Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id. |
100 | No | No | CTDDATAID | Numeric | Unique numeric ID for each depth bin within a CTD cast (6-digit number). |
100 | No | No | CTDCASTID | Numeric | Unique numeric ID of CTD cast (4 or 5-digit number). |
100 | No | No | 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 | No | No | 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 | No | No | CRUISE | Text | Mission identifier. |
100 | No | No | REGIONCODE | Text | Code for REGION. |
100 | No | No | 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 | No | No | LOCATIONCODE | Text | 3-Letter unique code for LOCATION. |
100 | No | No | LOCATION | Text | Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION). |
100 | No | No | LATITUDE | Numeric | Latitude in decimal degrees, WGS84, for the CTD cast. |
100 | No | No | LONGITUDE | Numeric | Longitude in decimal degrees, WGS84, for the CTD cast. |
100 | No | No | UTCDATETIME | Date | UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss). |
100 | No | No | CASTYEAR | Numeric | 4-digit year the CTD cast was conducted (UTCDATETIME). |
100 | No | No | 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 | No | No | 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 | No | No | PRESSURE_DB | Numeric | Measured pressure value in decibars. |
100 | No | No | DEPTH_M | Numeric | Calculated depth value in meters. |
100 | No | No | TEMP_DEGC | Numeric | Measured temperature value in degrees Celsius. |
100 | No | No | COND_S_PER_M | Numeric | Measured conductivity value in Siemens per meter. |
100 | No | No | SALN_PSU | Numeric | Calculated salinity value in Practical Salinity Units (PSU). |
100 | No | No | DENSITY_SIGMAT | Numeric | Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms / cubic meter. |
Attribute Details
Attribute Name | CTDCASTNAME |
---|---|
Seq. Order | 1 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CTDDATAID |
---|---|
Seq. Order | 2 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique numeric ID for each depth bin within a CTD cast (6-digit number). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CTDCASTID |
---|---|
Seq. Order | 3 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique numeric ID of CTD cast (4 or 5-digit number). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ASSOC_OCC_SITEID |
---|---|
Seq. Order | 4 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ASSOC_REA_SITE |
---|---|
Seq. Order | 5 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE |
---|---|
Seq. Order | 6 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mission identifier. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGIONCODE |
---|---|
Seq. Order | 7 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for REGION. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION |
---|---|
Seq. Order | 8 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATIONCODE |
---|---|
Seq. Order | 9 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-Letter unique code for LOCATION. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION |
---|---|
Seq. Order | 10 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 11 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude in decimal degrees, WGS84, for the CTD cast. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 12 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude in decimal degrees, WGS84, for the CTD cast. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UTCDATETIME |
---|---|
Seq. Order | 13 |
Data Storage Type | Date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CASTYEAR |
---|---|
Seq. Order | 14 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4-digit year the CTD cast was conducted (UTCDATETIME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OFFSHORE_YN |
---|---|
Seq. Order | 16 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SURVEY_DESIGN |
---|---|
Seq. Order | 17 |
Data Storage Type | Text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PRESSURE_DB |
---|---|
Seq. Order | 18 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured pressure value in decibars. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_M |
---|---|
Seq. Order | 19 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Calculated depth value in meters. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEMP_DEGC |
---|---|
Seq. Order | 20 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured temperature value in degrees Celsius. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COND_S_PER_M |
---|---|
Seq. Order | 21 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured conductivity value in Siemens per meter. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SALN_PSU |
---|---|
Seq. Order | 22 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Calculated salinity value in Practical Salinity Units (PSU). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DENSITY_SIGMAT |
---|---|
Seq. Order | 23 |
Data Storage Type | Numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms / cubic meter. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2022-04-01 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2023-04-01 |
Tags |
---|