DielSurvey_Entity_WaterSample | ID: 56573

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

	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).

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

NUMERIC

Total alkalinity measured in micromoles per kilogram.

100

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