Slide Menu
Maintenance Notice: Tuesday, May 30 @ 8-9:30am Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.6. Downtime Schedule Tuesday, May 30, 2023 2:00pm - 3:30pm Eastern / 10:00am - 11:30am Pacific / 8:00am - 9:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https...
View All
Search Help Show/Hide Menu

Item Identification

Title: ESD_USAID_H2O_DataDictionary_CT_2015
Abstract:

Water Chemistry Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Water Chemistry Entity and Attributes

Change Summary:

Updated 10-2021 with data revisions

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
EXPOCODE TEXT Defined as the Ship ICES code + departure date formatted as YYYYMMDD
100
CRUISE_ID TEXT Mission Identifier
100
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.
100
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.
100
SAMPLE_ID NUMERIC Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number
100
YEAR_UTC NUMERIC 4-digit year of the water sample collected by a Programmable Underwater Collector (PUC)
100
MONTH_UTC NUMERIC Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC)
100
DAY_UTC NUMERIC Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC)
100
TIME_UTC DATE UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.
100
YEARDAY_UTC NUMERIC Decimal value of the days, hours, and minutes from the beginning of the year
100
LATITUDE_DEC NUMERIC Latitude in decimal degrees, WGS84, for the given Site
100
LONGITUDE_DEC NUMERIC Longitude in decimal degrees, WGS84, for the given Site
100
PRESSURE_DB_CTD NUMERIC Hydrostatic pressure recorded from CTD at the depth where the sample is taken
100
PRESSURE_DB_CALCULATED NUMERIC Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast
100
DEPTH_METER NUMERIC Depth at which sample was collected (meters).
100
TEMPERATURE_ITS90_CTD NUMERIC In situ temperature recorded from CTD with the scale of ITS-90.
100
TEMPERATURE_ITS90_CTD_FLAG NUMERIC Quality control flag for CTDTEMP
100
TEMPERATURE_ITS90_SCS NUMERIC Temperature measured by Scientific Computer System, SCS (SBE38)
100
SALINITY_PSS78_CTD NUMERIC Salinity calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978
100
SALINITY_PSS78_CTD_FLAG NUMERIC Quality control flag for CTDSAL
100
SALINITY_PSS78_BOTTLE NUMERIC Salinity calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978
100
SALINITY_PSS78_BOTTLE_FLAG NUMERIC Quality control flag for Salinity_PSS78
100
SALINITY_PSS78_SCS NUMERIC Salinity measured by Scientific Computer System, SCS (SBE45)
100
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.
100
DIC_UMOL_KG_FLAG NUMERIC Flag for dissolved inorganic carbon values
100
TALK_UMOL_KG NUMERIC Total alkalinity measured in micromoles per kilogram.
100
TALK_UMOL_KG_FLAG NUMERIC Quality control flag for TALK; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS
100
CTDCASTID_ESD NUMERIC Unique numeric ID of CTD cast (4-digit number).
100
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).
100
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.
100
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).
100
LOCATION TEXT Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100
LOCATIONCODE TEXT 3-Letter unique code for LOCATION.
100
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).
100
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).
100
TEMPERATURE_ITS90_BEST NUMERIC Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS
100
TEMPERATURE_ITS90_BEST_ORIGIN NUMERIC source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)
100
SALINITY_PSS78_BEST NUMERIC Best salinity value associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
100
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)
100
PH_TS_CALCULATED NUMERIC pH calculated on Total Scale (TS) from DIC and TALK
100
PCO2_UATM_CALCULATED 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
TIMESTAMP_UTC DATE Date and time of water sample in UTC

Attribute Details

EXPOCODE

CC ID: 1094607
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Defined as the Ship ICES code + departure date formatted as YYYYMMDD

CRUISE_ID

CC ID: 1094608
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Mission Identifier

STATION_ID

CC ID: 1094609
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094610
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094611
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number

YEAR_UTC

CC ID: 1094612
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

4-digit year of the water sample collected by a Programmable Underwater Collector (PUC)

MONTH_UTC

CC ID: 1094613
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC)

DAY_UTC

CC ID: 1094614
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC)

TIME_UTC

CC ID: 1094615
Data Storage Type: DATE
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.

YEARDAY_UTC

CC ID: 1094616
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Decimal value of the days, hours, and minutes from the beginning of the year

LATITUDE_DEC

CC ID: 1094617
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given Site

LONGITUDE_DEC

CC ID: 1094618
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given Site

PRESSURE_DB_CTD

CC ID: 1094619
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Hydrostatic pressure recorded from CTD at the depth where the sample is taken

PRESSURE_DB_CALCULATED

CC ID: 1094620
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast

DEPTH_METER

CC ID: 1094621
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Depth at which sample was collected (meters).

TEMPERATURE_ITS90_CTD

CC ID: 1094622
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

In situ temperature recorded from CTD with the scale of ITS-90.

TEMPERATURE_ITS90_CTD_FLAG

CC ID: 1094623
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for CTDTEMP

TEMPERATURE_ITS90_SCS

CC ID: 1094624
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Temperature measured by Scientific Computer System, SCS (SBE38)

SALINITY_PSS78_CTD

CC ID: 1094625
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978

SALINITY_PSS78_CTD_FLAG

CC ID: 1094626
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for CTDSAL

SALINITY_PSS78_BOTTLE

CC ID: 1094627
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978

SALINITY_PSS78_BOTTLE_FLAG

CC ID: 1094628
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for Salinity_PSS78

SALINITY_PSS78_SCS

CC ID: 1094629
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity measured by Scientific Computer System, SCS (SBE45)

DIC_UMOL_KG

CC ID: 1094630
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.

DIC_UMOL_KG_FLAG

CC ID: 1094631
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Flag for dissolved inorganic carbon values

TALK_UMOL_KG

CC ID: 1094632
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Total alkalinity measured in micromoles per kilogram.

TALK_UMOL_KG_FLAG

CC ID: 1094633
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for TALK; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS

CTDCASTID_ESD

CC ID: 1094634
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique numeric ID of CTD cast (4-digit number).

ASSOC_OCC_SITEID

CC ID: 1094635
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094636
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094637
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094638
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).

LOCATIONCODE

CC ID: 1094639
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for LOCATION.

SURVEY_DESIGN

CC ID: 1094640
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094641
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1094642
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS

TEMPERATURE_ITS90_BEST_ORIGIN

CC ID: 1094643
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)

SALINITY_PSS78_BEST

CC ID: 1094644
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Best salinity value associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.

SALINITY_PSS78_BEST_ORIGIN

CC ID: 1094645
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

source of 'SALINITY_PSS78_BEST' measurement: CTD (SALINITY_PSS78_CTD), discrete bottle sample (SALINITY_PSS78_BOTTLE), or SCS (SALINITY_PSS78_SCS)

PH_TS_CALCULATED

CC ID: 1094646
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

pH calculated on Total Scale (TS) from DIC and TALK

PCO2_UATM_CALCULATED

CC ID: 1094647
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: 1094648
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.

TIMESTAMP_UTC

CC ID: 1094649
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date and time of water sample in UTC

Catalog Details

Catalog Item ID: 45943
GUID: gov.noaa.nmfs.inport:45943
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-05-01 15:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-10-28
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-10-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-10-28