ESD_NCRMP_DS_2022_MARIAN_H2O_DataDictionary

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 55425 | Published / External
Created: 2019-01-31 | Last Modified: 2025-03-11

Parent: National Coral Reef Monitoring Program: Diel seawater carbonate chemistry observations from a suite of instrumentation deployed at coral reef sites in the Mariana Archipelago in...
Data Set (DS) | ID: 54927

ID: 55425
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	ESD_NCRMP_DS_2022_MARIAN_H2O_DataDictionary
Short Name
* Status	Completed
Creation Date
Revision Date
• Publication Date
* » Abstract	Water sample entity and attributes for diel surveys. Includes columns specifically for outsourced water sample analysis (to PMEL) such as flags for quality control.
* 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	Data Table
Active Version?	Y
Alias
Schema Name
» Description	Water sample entities and attributes for diel surveys.
Change Summary	In 2021, columns were renamed and added to standardize data structure. In 2024, CTDCASTID_ESD was not applicable and was removed from data files and data dictionary.

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	No	No	DSUITEID	NUMERIC	Unique identifier for each Diel Suite deployed.
100	No	No	EXPOCODE	TEXT	Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
100	No	No	CRUISE_ID	TEXT	A single designation that applies to all the rounds associated with a given mission/cruise.
100	No	No	MISSION_CODE	TEXT	More descriptive name of cruise/mission.
100	No	No	ASSOC_REA_SITE	TEXT	An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
100	No	No	OCC_SITEID	TEXT	A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
100	No	No	REGION	TEXT	The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100	No	No	REGIONCODE	TEXT	Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
100	No	No	LOCATION	TEXT	Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100	No	No	LOCATIONCODE	TEXT	3-Letter unique code for LOCATION.
100	No	No	LATITUDE	NUMERIC	Latitude in decimal degrees, WGS84, for the given site.
100	No	No	LONGITUDE	NUMERIC	Longitude in decimal degrees, WGS84, for the given site.
100	No	No	SAMPLE_ID	NUMERIC	Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number.
100	No	No	STATION_ID	TEXT	An identifier for the station at the island or atoll (LOCATION) associated with the sample. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
100	No	No	SURVEY_DESIGN	TEXT	NCRMP survey design associated with the sample. Survey designs include: samples collected by small boat at permanent climate sites (Permanent); samples collected by small boat and co-located with fish or benthic stratified random survey sites (Stratified_Random); samples collected by small boat at random sites not associated with climate, benthic, or fish sites (Random); shipboard samples collected offshore for end member data (End_member); samples collected during diel suite surveys (Diel_suite); and shipboard samples collected to calibrate underway systems (Calibration).
100	No	No	SAMPLE_FREQUENCY	TEXT	Indicates if water sample is discrete (Single) or if the sample is part a series of water samples collected ~every 4 hrs in a ~24-hr period at the same STATION_ID using a Programmable Underwater Collector (Diel).
100	No	No	DEPTH_METER	NUMERIC	Depth at which sample was collected (meters).
100	No	No	YEAR_UTC	NUMERIC	4-digit year of the water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100	No	No	MONTH_UTC	NUMERIC	Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100	No	No	DAY_UTC	NUMERIC	Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100	No	No	TIMESTAMP_UTC	DATE	Date and time of water sample in UTC.
100	No	No	TIME_UTC	TIME	UTC time of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS), hh:mm:ss.
100	No	No	YEARDAY_UTC	NUMERIC	Decimal value of the days, hours, and minutes from the beginning of the year.
100	No	No	WATERSAMPLE_SAMPLEINTERVAL_SEC	NUMERIC	Water sampling interval in seconds, as programmed by PUC or SAS. NULL for manual samples that were collected adjacent to, but not by, the PUC or SAS.
100	No	No	ARAGONITE_SAT	NUMERIC	Calculated aragonite saturation from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
100	No	No	DIC_UMOL_KG	NUMERIC	Dissolved inorganic carbon measured in micromoles per kilogram. NULL values result from insufficiently filled sample bags in which the sample volume only allowed for TA analysis.
100	No	No	DIC_UMOL_KG_FLAG	NUMERIC	Flag for DIC_UMOL_KG.
100	No	No	PCO2_UATM_CALCULATED	NUMERIC	Partial pressure in microatmospheres of carbon dioxide, calculated from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
100	No	No	PH_TS_CALCULATED	NUMERIC	pH calculated on Total Scale (TS) from DIC_UMOL_KG and TALK_UMOL_KG.
100	No	No	PRESSURE_DB_CALCULATED	NUMERIC	Pressure in decibars calculated from DEPTH_METER (using the R package "oce") for samples not associated with a CTD cast. NULL if pressure was derived from CTD data.
100	No	No	PRESSURE_DB_CTD	NUMERIC	Hydrostatic pressure in decibars recorded from CTD at the depth where the sample is taken.
100	No	No	SALINITY_PSS78_BEST	NUMERIC	Best salinity value in practical salinity units associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
100	No	No	SALINITY_PSS78_BEST_ORIGIN	TEXT	Source of 'SALINITY_PSS78_BEST' measurement: CTD (SALINITY_PSS78_CTD), discrete bottle sample (SALINITY_PSS78_BOTTLE), or SCS (SALINITY_PSS78_SCS).
100	No	No	SALINITY_PSS78_BOTTLE	NUMERIC	Salinity in practical salinity units calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978. NULL if bottle salinity data were not collected or used for the respective sample.
100	No	No	SALINITY_PSS78_BOTTLE_FLAG	NUMERIC	Quality control flag for SALINITY_PSS78_BOTTLE. NULL if bottle salinity data were not collected or used for the respective sample.
100	No	No	SALINITY_PSS78_CTD	NUMERIC	Salinity in practical salinity units calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978.
100	No	No	SALINITY_PSS78_CTD_FLAG	NUMERIC	Quality control flag for SALINITY_PSS78_CTD.
100	No	No	SALINITY_PSS78_SCS	NUMERIC	Salinity in practical salinity units measured by Scientific Computer System, SCS (SBE45). NULL for samples for which SCS data were not used.
100	No	No	TALK_UMOL_KG	NUMERIC	Total alkalinity measured in micromoles per kilogram.
100	No	No	TALK_UMOL_KG_FLAG	NUMERIC	Quality control flag for TALK_UMOL_KG.
100	No	No	TEMPERATURE_ITS90_BEST_ORIGIN	TEXT	Source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)
100	No	No	TEMPERATURE_ITS90_BEST	NUMERIC	Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS and with the scale of ITS-90.
100	No	No	TEMPERATURE_ITS90_CTD	NUMERIC	In situ temperature recorded from CTD with the scale of ITS-90.
100	No	No	TEMPERATURE_ITS90_CTD_FLAG	NUMERIC	Quality control flag for TEMPERATURE_ITS90_CTD.
100	No	No	TEMPERATURE_ITS90_SCS	NUMERIC	Temperature measured by Scientific Computer System, SCS (SBE38) with the scale of ITS-90. NULL for samples for which SCS data were not used.

Attribute Details

Attribute Name	DSUITEID
Seq. Order	1
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique identifier for each Diel Suite deployed.
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	EXPOCODE
Seq. Order	2
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Defined as the Ship ICES code + departure date formatted as YYYYMMDD.
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_ID
Seq. Order	3
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A single designation that applies to all the rounds associated with a given mission/cruise.
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	MISSION_CODE
Seq. Order	5
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	More descriptive name of cruise/mission.
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	6
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 diel survey. 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	OCC_SITEID
Seq. Order	7
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-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	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 diel survey 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	REGIONCODE
Seq. Order	9
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
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 sample was collected 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	LOCATIONCODE
Seq. Order	11
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	LATITUDE
Seq. Order	12
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 given site.
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	13
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 given site.
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	SAMPLE_ID
Seq. Order	15
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_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	STATION_ID
Seq. Order	16
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	An identifier for the station at the island or atoll (LOCATION) associated with the sample. 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	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 sample. Survey designs include: samples collected by small boat at permanent climate sites (Permanent); samples collected by small boat and co-located with fish or benthic stratified random survey sites (Stratified_Random); samples collected by small boat at random sites not associated with climate, benthic, or fish sites (Random); shipboard samples collected offshore for end member data (End_member); samples collected during diel suite surveys (Diel_suite); and shipboard samples collected to calibrate underway systems (Calibration).
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	SAMPLE_FREQUENCY
Seq. Order	18
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Indicates if water sample is discrete (Single) or if the sample is part a series of water samples collected ~every 4 hrs in a ~24-hr period at the same STATION_ID using a Programmable Underwater Collector (Diel).
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_METER
Seq. Order	19
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Depth at which sample was collected (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	YEAR_UTC
Seq. Order	20
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	4-digit year of the water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
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	MONTH_UTC
Seq. Order	21
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
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	DAY_UTC
Seq. Order	22
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
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	TIMESTAMP_UTC
Seq. Order	23
Data Storage Type	DATE
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time of water sample in UTC.
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	TIME_UTC
Seq. Order	24
Data Storage Type	TIME
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	UTC time of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS), 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	YEARDAY_UTC
Seq. Order	25
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Decimal value of the days, hours, and minutes from the beginning of the year.
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	WATERSAMPLE_SAMPLEINTERVAL_SEC
Seq. Order	26
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Water sampling interval in seconds, as programmed by PUC or SAS. NULL for manual samples that were collected adjacent to, but not by, the PUC or SAS.
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	ARAGONITE_SAT
Seq. Order	27
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Calculated aragonite saturation from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
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	DIC_UMOL_KG
Seq. Order	28
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Dissolved inorganic carbon measured in micromoles per kilogram. NULL values result from insufficiently filled sample bags in which the sample volume only allowed for TA analysis.
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	DIC_UMOL_KG_FLAG
Seq. Order	29
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Flag for DIC_UMOL_KG.
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	PCO2_UATM_CALCULATED
Seq. Order	30
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Partial pressure in microatmospheres of carbon dioxide, calculated from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
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	PH_TS_CALCULATED
Seq. Order	31
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	pH calculated on Total Scale (TS) from DIC_UMOL_KG and TALK_UMOL_KG.
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_CALCULATED
Seq. Order	32
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Pressure in decibars calculated from DEPTH_METER (using the R package "oce") for samples not associated with a CTD cast. NULL if pressure was derived from CTD data.
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_CTD
Seq. Order	33
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Hydrostatic pressure in decibars recorded from CTD at the depth where the sample is taken.
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	SALINITY_PSS78_BEST
Seq. Order	34
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Best salinity value in practical salinity units associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
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	SALINITY_PSS78_BEST_ORIGIN
Seq. Order	35
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Source of 'SALINITY_PSS78_BEST' measurement: CTD (SALINITY_PSS78_CTD), discrete bottle sample (SALINITY_PSS78_BOTTLE), or SCS (SALINITY_PSS78_SCS).
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	SALINITY_PSS78_BOTTLE
Seq. Order	36
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Salinity in practical salinity units calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978. NULL if bottle salinity data were not collected or used for the respective sample.
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	SALINITY_PSS78_BOTTLE_FLAG
Seq. Order	37
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Quality control flag for SALINITY_PSS78_BOTTLE. NULL if bottle salinity data were not collected or used for the respective sample.
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	SALINITY_PSS78_CTD
Seq. Order	38
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Salinity in practical salinity units calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978.
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	SALINITY_PSS78_CTD_FLAG
Seq. Order	39
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Quality control flag for SALINITY_PSS78_CTD.
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	SALINITY_PSS78_SCS
Seq. Order	40
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Salinity in practical salinity units measured by Scientific Computer System, SCS (SBE45). NULL for samples for which SCS data were not used.
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	TALK_UMOL_KG
Seq. Order	41
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Total alkalinity measured in micromoles per kilogram.
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	TALK_UMOL_KG_FLAG
Seq. Order	42
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Quality control flag for TALK_UMOL_KG.
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	TEMPERATURE_ITS90_BEST_ORIGIN
Seq. Order	43
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)
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	TEMPERATURE_ITS90_BEST
Seq. Order	44
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS and with the scale of ITS-90.
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	TEMPERATURE_ITS90_CTD
Seq. Order	45
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	In situ temperature recorded from CTD with the scale of ITS-90.
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	TEMPERATURE_ITS90_CTD_FLAG
Seq. Order	46
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Quality control flag for TEMPERATURE_ITS90_CTD.
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	TEMPERATURE_ITS90_SCS
Seq. Order	47
Data Storage Type	NUMERIC
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Temperature measured by Scientific Computer System, SCS (SBE38) with the scale of ITS-90. NULL for samples for which SCS data were not used.
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

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.

* » 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	55425
Metadata Record Created By	Annette M DesRochers
Metadata Record Created	2019-01-31 22:39+0000
Metadata Record Last Modified By	Lori H Luers
» Metadata Record Last Modified	2025-03-11 17:14+0000
Metadata Record Published	2025-03-11
Owner Org	PIFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2021-08-06
Metadata Review Frequency	1 Year
Metadata Next Review Date	2022-08-06

Tags