Item Identification

Title: DielSurvey_Entity_WaterSample
Status: Completed
Abstract:

Water sample entity and attributes for diel surveys.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Water sample entities and attributes for diel surveys.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CTDID TEXT Unique ID for CTD Cast (typically cruise/MISSION id, REGION code, 3-letter island code [LOCATION], last 4 digits of serial number, cast number/id). Same as ShallowCTDID in CTD data for the same SiteID.
100
Region TEXT Code for the region surveyed in the Pacific.
100
Year NUMERIC 4-digit year the water sample was collected (UTCDATE).
100
Mission Text Mission ID and REGION.
100
Location Text 3-letter code derived from the name of island or atoll where SiteID is located in the Pacific (REGION).
100
Latitude NUMERIC Latitude in decimal degrees, WGS84, for the given SiteID.
100
Longitude NUMERIC Longitude in decimal degrees, WGS84, for the given SiteID.
100
UTCDATE DATE UTC date of water sample collected by a Programmable Underwater Collector (PUC), m/d/yyyy.
100
UTCTIME TIME UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.
100
Sample_Depth_M NUMERIC Depth of water sample in meters.
100
DIC 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
TA NUMERIC Total alkalinity measured in micromoles per kilogram.
100
pH NUMERIC pH value of seawater, calculated from DIC, TA, temperature, salinity and pressure.
100
pCO2 NUMERIC Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.
100
Aragonite_Sat NUMERIC Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.
100
Conductivity_Sm NUMERIC Conductivity measured from the CTD in Siemens per meter.
100
Salinity_CTD NUMERIC Calculated salinity value in Practical Salinity Units (PSU) from the CTD.
100
Temperature_C NUMERIC Temperature value in degrees Celsius measured from the CTD.
100
Pressure_db NUMERIC Pressure value in decibars measured from the CTD.
100
Density_Sigmat NUMERIC Calculated density value in kilograms/cubic meter from the CTD.
100
SiteID TEXT The code for the site surveyed at the island or atoll (LOCATION). Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.
100
Survey_design TEXT SiteID attribute. Permanent/fixed site that is revisited over time, or randomly selected site that is surveyed only once.
100
Sample_frequency TEXT Indicates if water sample is discrete or if the sample is part a series of water samples collected ~every 4 hrs in a ~24-hr period at the same SiteID using a Programmable Underwater Collector (Diel).

Attribute Details

CTDID

CC ID: 846571
Seq. Order: 1
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for CTD Cast (typically cruise/MISSION id, REGION code, 3-letter island code [LOCATION], last 4 digits of serial number, cast number/id). Same as ShallowCTDID in CTD data for the same SiteID.

Region

CC ID: 846580
Seq. Order: 2
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Code for the region surveyed in the Pacific.

Year

CC ID: 846590
Seq. Order: 2
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

4-digit year the water sample was collected (UTCDATE).

Mission

CC ID: 846578
Seq. Order: 3
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Mission ID and REGION.

Location

CC ID: 846576
Seq. Order: 4
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

3-letter code derived from the name of island or atoll where SiteID is located in the Pacific (REGION).

Latitude

CC ID: 846575
Seq. Order: 6
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given SiteID.

Longitude

CC ID: 846577
Seq. Order: 7
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given SiteID.

UTCDATE

CC ID: 846588
Seq. Order: 8
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

UTC date of water sample collected by a Programmable Underwater Collector (PUC), m/d/yyyy.

UTCTIME

CC ID: 846589
Seq. Order: 9
Data Storage Type: TIME
Required: No
Primary Key: No
Status: Active
Description:

UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.

Sample_Depth_M

CC ID: 846582
Seq. Order: 10
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Depth of water sample in meters.

DIC

CC ID: 846573
Seq. Order: 11
Data Storage Type: NUMERIC
Required: No
Primary Key: No
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.

TA

CC ID: 846586
Seq. Order: 12
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Total alkalinity measured in micromoles per kilogram.

pH

CC ID: 846592
Seq. Order: 13
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

pH value of seawater, calculated from DIC, TA, temperature, salinity and pressure.

pCO2

CC ID: 846591
Seq. Order: 14
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.

Aragonite_Sat

CC ID: 846570
Seq. Order: 15
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.

Conductivity_Sm

CC ID: 846572
Seq. Order: 16
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Conductivity measured from the CTD in Siemens per meter.

Salinity_CTD

CC ID: 846581
Seq. Order: 17
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated salinity value in Practical Salinity Units (PSU) from the CTD.

Temperature_C

CC ID: 846587
Seq. Order: 18
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Temperature value in degrees Celsius measured from the CTD.

Pressure_db

CC ID: 846579
Seq. Order: 19
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Pressure value in decibars measured from the CTD.

Density_Sigmat

CC ID: 846574
Seq. Order: 20
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated density value in kilograms/cubic meter from the CTD.

SiteID

CC ID: 846584
Seq. Order: 21
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

The code for the site surveyed at the island or atoll (LOCATION). Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.

Survey_design

CC ID: 846585
Seq. Order: 22
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

SiteID attribute. Permanent/fixed site that is revisited over time, or randomly selected site that is surveyed only once.

Sample_frequency

CC ID: 846583
Seq. Order: 23
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Indicates if water sample is discrete or if the sample is part a series of water samples collected ~every 4 hrs in a ~24-hr period at the same SiteID using a Programmable Underwater Collector (Diel).

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: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-31
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-31