Item Identification

Title: Water Chemistry Details
Abstract:

Water Chemistry Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Water Chemistry Entity and Attributes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Region Text The geographic region from which the data is collected (Coral Triangle).
100
Year Double The year the sample was collected in 4-digit year format (2013 to 2014).
100
Location Text The island nation from which the data is collected. This is a subset within REGION (Timor-Leste).
100
Latitude Double Latitude in decimal degree format of the water sample (-8.15301 to -9.19571).
100
Longitude Double Longitude in decimal degree format of the water sample (124.36834 to 127.31219)
100
UTCDateTime Date/Time The Coordinated Universal Time in which the sample was collected (Timor-Leste local time is UTC or GMT +9). Format m/d/yyyy (6/6/2013 to 10/6/2014).
100
DIC Double The dissolved inorganic carbon (DIC) concentration measured from the water sample in micromoles per kilogram (1867.63 to 1958.34).
100
TA Double The total alkalinity (TA) concentration measured from the water sample in micromoles per kilogram (2168.50 to 2260.40).
100
Salinity_Bottle Double The in-situ salinity present at the time of water sample collection, at the location of water sample collected in practical salinity units (32.61 to 33.83).
100
Temperature_DegC_4DICCalc Double The in-situ water temperature present at the time of water sample collection, at the location of water sample collection, measured in degrees Celsius (26.52 to 29.92).
100
REA_Site Text A NOAA specific code used to identify reef study sites across the Pacific, formatted as a 3-digit alpha code followed by a unique number identifier (e.g., DIL-02).
100
ShallowH2OSampleKey Text A NOAA specific numerical code identifying each individual sample as a unique line item (3804 to 4226).
100
Sample_Depth_m Double The depth at which the sample was collected, in units of meters (0.9 - 16.8).
100
SampleType Text The descriptor for where the sample was collected. BENTHIC = sample collected at the reef or seafloor, the same latitude and longitude as the reef study site (same as ON_SURFACE). ON_SURFACE = sample collected "onshore" at the surface of the ocean (~1m depth), the same latitude and longitude as the reef study site (same as BENTHIC). OFF_SURFACE = sample collected approximately 1km "offshore" of the reef study site, at the surface of the ocean (~1km depth).
100
snDIC Double The salinity normalized (salinity = 35) DIC concentration (1981.12 to 2015.26).
100
snTA Double The salinity normalized (salinity = 35) TA concentration (2279.63 to 2331.05).
100
pH_sc Double The in-situ, salinity corrected, pH in total scale (8.01 to 8.05) calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).
100
pCO2_sc Double The in-situ, salinity corrected, partial pressure of carbon dioxide in micro atmospheres (373.26 to 423.37) calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).
100
OmegaAragonite_sc Double The in-situ, salinity corrected, saturation state (3.29 to 3.62) with respect to aragonite calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).
100
ShallowCTDComments Text On-site comments made by the scientist conducting the sample collection.

Attribute Details

Region

CC ID: 696859
Seq. Order: 3
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The geographic region from which the data is collected (Coral Triangle).

Year

CC ID: 696873
Seq. Order: 4
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The year the sample was collected in 4-digit year format (2013 to 2014).

Location

CC ID: 696846
Seq. Order: 7
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The island nation from which the data is collected. This is a subset within REGION (Timor-Leste).

Latitude

CC ID: 696845
Seq. Order: 8
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degree format of the water sample (-8.15301 to -9.19571).

Unit of Measure: decimal degree

Longitude

CC ID: 696848
Seq. Order: 9
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degree format of the water sample (124.36834 to 127.31219)

Unit of Measure: decimal degree

UTCDateTime

CC ID: 696872
Seq. Order: 10
Data Storage Type: Date/Time
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The Coordinated Universal Time in which the sample was collected (Timor-Leste local time is UTC or GMT +9). Format m/d/yyyy (6/6/2013 to 10/6/2014).

DIC

CC ID: 696840
Seq. Order: 25
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The dissolved inorganic carbon (DIC) concentration measured from the water sample in micromoles per kilogram (1867.63 to 1958.34).

Unit of Measure: umol/kg

TA

CC ID: 696869
Seq. Order: 26
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The total alkalinity (TA) concentration measured from the water sample in micromoles per kilogram (2168.50 to 2260.40).

Unit of Measure: umol/kg

Salinity_Bottle

CC ID: 696863
Seq. Order: 28
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The in-situ salinity present at the time of water sample collection, at the location of water sample collected in practical salinity units (32.61 to 33.83).

Unit of Measure: PSU

Temperature_DegC_4DICCalc

CC ID: 696871
Seq. Order: 31
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The in-situ water temperature present at the time of water sample collection, at the location of water sample collection, measured in degrees Celsius (26.52 to 29.92).

Unit of Measure: degree C

REA_Site

CC ID: 696858
Seq. Order: 40
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A NOAA specific code used to identify reef study sites across the Pacific, formatted as a 3-digit alpha code followed by a unique number identifier (e.g., DIL-02).

ShallowH2OSampleKey

CC ID: 696874
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

A NOAA specific numerical code identifying each individual sample as a unique line item (3804 to 4226).

Sample_Depth_m

CC ID: 696881
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The depth at which the sample was collected, in units of meters (0.9 - 16.8).

SampleType

CC ID: 696900
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The descriptor for where the sample was collected. BENTHIC = sample collected at the reef or seafloor, the same latitude and longitude as the reef study site (same as ON_SURFACE). ON_SURFACE = sample collected "onshore" at the surface of the ocean (~1m depth), the same latitude and longitude as the reef study site (same as BENTHIC). OFF_SURFACE = sample collected approximately 1km "offshore" of the reef study site, at the surface of the ocean (~1km depth).

snDIC

CC ID: 696901
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The salinity normalized (salinity = 35) DIC concentration (1981.12 to 2015.26).

snTA

CC ID: 696902
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The salinity normalized (salinity = 35) TA concentration (2279.63 to 2331.05).

pH_sc

CC ID: 696903
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The in-situ, salinity corrected, pH in total scale (8.01 to 8.05) calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).

pCO2_sc

CC ID: 696904
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The in-situ, salinity corrected, partial pressure of carbon dioxide in micro atmospheres (373.26 to 423.37) calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).

OmegaAragonite_sc

CC ID: 696905
Data Storage Type: Double
Required: No
Primary Key: No
Status: Active
Description:

The in-situ, salinity corrected, saturation state (3.29 to 3.62) with respect to aragonite calculated through SEACARB, a carbonate chemistry calculation program created by J.P. Gattuso (https://cran.r-project.org/web/packages/seacarb/index.html).

ShallowCTDComments

CC ID: 696906
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

On-site comments made by the scientist conducting the sample collection.

Catalog Details

Catalog Item ID: 50383
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-11-27 13:59+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-12-06
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-12-07