Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Water Chemistry Entity and Attributes

Description

Water Chemistry Entity and Attributes

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
EXPOCODE
TEXT
Defined as the Ship ICES code + departure date formatted as YYYYMMDD
CRUISE_ID
TEXT
Mission Identifier
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.
CAST_NUMBER
NUMERIC
Cast number, where a cast is the lowering of equipment over the side at one station (STATION_ID). Cast_number is sequential and starts with 1 for each station.
SAMPLE_ID
NUMERIC
Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number
YEAR_UTC
NUMERIC
4-digit year of the water sample collected by a Programmable Underwater Collector (PUC)
MONTH_UTC
NUMERIC
Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC)
DAY_UTC
NUMERIC
Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC)
TIME_UTC
DATE
UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.
YEARDAY_UTC
NUMERIC
Decimal value of the days, hours, and minutes from the beginning of the year
LATITUDE_DEC
NUMERIC
Latitude in decimal degrees, WGS84, for the given Site
LONGITUDE_DEC
NUMERIC
Longitude in decimal degrees, WGS84, for the given Site
PRESSURE_DB_CTD
NUMERIC
Hydrostatic pressure recorded from CTD at the depth where the sample is taken
PRESSURE_DB_CALCULATED
NUMERIC
Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast
DEPTH_METER
NUMERIC
Depth at which sample was collected (meters).
TEMPERATURE_ITS90_CTD
NUMERIC
In situ temperature recorded from CTD with the scale of ITS-90.
TEMPERATURE_ITS90_CTD_FLAG
NUMERIC
Quality control flag for CTDTEMP
TEMPERATURE_ITS90_SCS
NUMERIC
Temperature measured by Scientific Computer System, SCS (SBE38)
SALINITY_PSS78_CTD
NUMERIC
Salinity calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978
SALINITY_PSS78_CTD_FLAG
NUMERIC
Quality control flag for CTDSAL
SALINITY_PSS78_BOTTLE
NUMERIC
Salinity calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978
SALINITY_PSS78_BOTTLE_FLAG
NUMERIC
Quality control flag for Salinity_PSS78
SALINITY_PSS78_SCS
NUMERIC
Salinity measured by Scientific Computer System, SCS (SBE45)
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.
DIC_UMOL_KG_FLAG
NUMERIC
Flag for dissolved inorganic carbon values
TALK_UMOL_KG
NUMERIC
Total alkalinity measured in micromoles per kilogram.
TALK_UMOL_KG_FLAG
NUMERIC
Quality control flag for TALK; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS
CTDCASTID_ESD
NUMERIC
Unique numeric ID of CTD cast (4-digit number).
ASSOC_OCC_SITEID
TEXT
An identifier for the fixed NCRMP climate site associated with the sample, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. A sample is assigned an ASSOC_OCC_SITEID only if its coordinates (LATITUDE and LONGITUDE) are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned (NULL).
REGION
TEXT
The name of the region where the CTD cast was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
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).
LOCATION
TEXT
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
TEXT
3-Letter unique code for LOCATION.
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).
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).
TEMPERATURE_ITS90_BEST
NUMERIC
Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS
TEMPERATURE_ITS90_BEST_ORIGIN
NUMERIC
source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)
SALINITY_PSS78_BEST
NUMERIC
Best salinity value associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
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)
PH_TS_CALCULATED
NUMERIC
pH calculated on Total Scale (TS) from DIC and TALK
PCO2_UATM_CALCULATED
NUMERIC
Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.
ARAGONITE_SAT
NUMERIC
Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.
TIMESTAMP_UTC
DATE
Date and time of water sample in UTC

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.