DielSurvey_Entity_WaterSample
Pacific Islands Fisheries Science Center (PIFSC)Entity (ENT) | ID: 56573 | Published / External
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). |
Attribute Details
CTDID
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
Seq. Order: | 2 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the region surveyed in the Pacific. |
Year
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mission ID and REGION. |
Location
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
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
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
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
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
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth of water sample in meters. |
DIC
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
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total alkalinity measured in micromoles per kilogram. |
pH
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
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
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
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
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
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
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
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
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
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
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 |