ESD_USAID_H2O_DataDictionary_CT_2015
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:45943 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
Data Storage Type: | TEXT |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
STATION_ID
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
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
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
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
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
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
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
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given Site |
LONGITUDE_DEC
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84, for the given Site |
PRESSURE_DB_CTD
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
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth at which sample was collected (meters). |
TEMPERATURE_ITS90_CTD
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for CTDTEMP |
TEMPERATURE_ITS90_SCS
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Temperature measured by Scientific Computer System, SCS (SBE38) |
SALINITY_PSS78_CTD
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for CTDSAL |
SALINITY_PSS78_BOTTLE
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for Salinity_PSS78 |
SALINITY_PSS78_SCS
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Salinity measured by Scientific Computer System, SCS (SBE45) |
DIC_UMOL_KG
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag for dissolved inorganic carbon values |
TALK_UMOL_KG
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total alkalinity measured in micromoles per kilogram. |
TALK_UMOL_KG_FLAG
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
Data Storage Type: | NUMERIC |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique numeric ID of CTD cast (4-digit number). |
ASSOC_OCC_SITEID
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
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
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
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
Data Storage Type: | TEXT |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-Letter unique code for LOCATION. |
SURVEY_DESIGN
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
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
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
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
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
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
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
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
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
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 |