ESD_DS_DataDict_2015_CT_H2O

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 56573 | Published / External
Created: 2019-05-31 | Last Modified: 2022-08-09

Parent: Diel seawater carbonate chemistry observations from a suite of instrumentation deployed at coral reef sites in Batangas, Philippines from May 21-31, 2015
Data Set (DS) | ID: 45954

ID: 56573
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	ESD_DS_DataDict_2015_CT_H2O
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.

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	Mission Identifier
100	No	No	CRUISE_COMMON_NAME	TEXT	More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
100	No	No	MISSION_CODE	TEXT	A single designation that applies to all the rounds associated with a given mission/cruise
100	No	No	OCC_SITEID	TEXT	A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
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	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	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	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	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	CTDCASTID_ESD	NUMERIC	Unique numeric ID of CTD cast (4-digit number).
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	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	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 offshorefor end member data (End_member); and shipboard samples collected to calibrate underway systems (Calibration).
100	No	No	YEAR_UTC	NUMERIC	4-digit year of the water sample collected by a Programmable Underwater Collector (PUC)
100	No	No	DAY_UTC	NUMERIC	Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC)
100	No	No	MONTH_UTC	NUMERIC	Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC)
100	No	No	TIMESTAMP_UTC	DATE	Date and time of water sample in UTC
100	No	No	TIME_UTC	NUMERIC	UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.
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
100	No	No	ARAGONITE_SAT	NUMERIC	Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.
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 dissolved inorganic carbon values
100	No	No	PCO2_UATM_CALCULATED	NUMERIC	Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.
100	No	No	PH_TS_CALCULATED	NUMERIC	pH calculated on Total Scale (TS) from DIC and TALK
100	No	No	PRESSURE_DB_CALCULATED	NUMERIC	Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast
100	No	No	PRESSURE_DB_CTD	NUMERIC	Hydrostatic pressure recorded from CTD at the depth where the sample is taken
100	No	No	SALINITY_PSS78_BEST	NUMERIC	Best salinity value associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
100	No	No	SALINITY_PSS78_BEST_ORIGIN	NUMERIC	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 calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978
100	No	No	SALINITY_PSS78_BOTTLE_FLAG	NUMERIC	Quality control flag for Salinity_PSS78
100	No	No	SALINITY_PSS78_CTD	NUMERIC	Salinity 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 CTDSAL
100	No	No	SALINITY_PSS78_SCS	NUMERIC	Salinity measured by Scientific Computer System, SCS (SBE45)
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; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS
100	No	No	TEMPERATURE_ITS90_BEST_ORIGIN	NUMERIC	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
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 CTDTEMP
100	No	No	TEMPERATURE_ITS90_SCS	NUMERIC	Temperature measured by Scientific Computer System, SCS (SBE38)

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	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	CRUISE_COMMON_NAME
Seq. Order	4
Data Storage Type	TEXT
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
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	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	OCC_SITEID
Seq. Order	6
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 location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
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	7
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	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	LOCATION
Seq. Order	9
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	10
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	REGIONCODE
Seq. Order	11
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	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	CTDCASTID_ESD
Seq. Order	14
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-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	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	SAMPLE_FREQUENCY
Seq. Order	17
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	18
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	SURVEY_DESIGN
Seq. Order	19
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 offshorefor end member data (End_member); 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	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)
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	21
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)
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	22
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)
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	NUMERIC
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), hh:mm:ss in 4-hr intervals.
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
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 based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.
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 dissolved inorganic carbon values
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 of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.
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 and TALK
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 calculated from depth (using the R package "oce") for samples not associated with a 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	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 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 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	NUMERIC
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 calculated from conductivity measured from discrete bottles 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_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
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 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 CTDSAL
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 measured by Scientific Computer System, SCS (SBE45)
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; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS
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	NUMERIC
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
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 CTDTEMP
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)
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	56573
Metadata Record Created By	Annette M DesRochers
Metadata Record Created	2019-05-31 06:59+0000
Metadata Record Last Modified By	SysAdmin InPortAdmin
» Metadata Record Last Modified	2022-08-09 17:11+0000
Metadata Record Published	2021-09-01
Owner Org	PIFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2021-09-01
Metadata Review Frequency	1 Year
Metadata Next Review Date	2022-09-01

Tags