ESD_DS_DataDict_2018_PRIA_H2O
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:55948 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | ESD_DS_DataDict_2018_PRIA_H2O |
---|---|
Status: | Completed |
Abstract: |
Water sample entity and attributes for diel surveys. Includes columns specifically for outsourced water sample analysis (to PMEL) such as flags for quality control. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Water sample entities and attributes for diel surveys. |
Change Summary: |
In 2021 columns were renamed and added to standardize data structure. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DSUITEID | NUMERIC | Unique identifier for each Diel Suite deployed | |
100
|
EXPOCODE | TEXT | Defined as the Ship ICES code + departure date formatted as YYYYMMDD | |
100
|
CRUISE_ID | TEXT | Mission Identifier | |
100
|
CRUISE_COMMON_NAME | TEXT | More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited] | |
100
|
MISSION_CODE | TEXT | A single designation that applies to all the rounds associated with a given mission/cruise | |
100
|
OCC_SITEID | TEXT | A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID. | |
100
|
ASSOC_REA_SITE | TEXT | An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number. | |
100
|
REGION | TEXT | The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. | |
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
|
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
|
LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given Site | |
100
|
LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84, for the given Site | |
100
|
CTDCASTID_ESD | NUMERIC | Unique numeric ID of CTD cast (4-digit number). | |
100
|
SAMPLE_ID | NUMERIC | Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number | |
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
|
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
|
DEPTH_METER | NUMERIC | Depth at which sample was collected (meters). | |
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
|
YEAR_UTC | NUMERIC | 4-digit year of the 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
|
MONTH_UTC | NUMERIC | Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC) | |
100
|
TIMESTAMP_UTC | DATE | Date and time of water sample in UTC | |
100
|
TIME_UTC | NUMERIC | 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
|
WATERSAMPLE_SAMPLEINTERVAL_SEC | NUMERIC | Water sampling interval in seconds, as programmed by PUC | |
100
|
ARAGONITE_SAT | NUMERIC | Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure. | |
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
|
PCO2_UATM_CALCULATED | NUMERIC | Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure. | |
100
|
PH_TS_CALCULATED | NUMERIC | pH calculated on Total Scale (TS) from DIC and TALK | |
100
|
PRESSURE_DB_CALCULATED | NUMERIC | Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast | |
100
|
PRESSURE_DB_CTD | NUMERIC | Hydrostatic pressure recorded from CTD at the depth where the sample is taken | |
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
|
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_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_SCS | NUMERIC | Salinity measured by Scientific Computer System, SCS (SBE45) | |
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
|
TEMPERATURE_ITS90_BEST_ORIGIN | NUMERIC | source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS) | |
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_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) |
Attribute Details
DSUITEID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for each Diel Suite deployed |
EXPOCODE
Seq. Order: | 2 |
---|---|
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
CRUISE_COMMON_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited] |
MISSION_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A single designation that applies to all the rounds associated with a given mission/cruise |
OCC_SITEID
Seq. Order: | 6 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID. |
ASSOC_REA_SITE
Seq. Order: | 7 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number. |
REGION
Seq. Order: | 8 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
LOCATION
Seq. Order: | 9 |
---|---|
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
Seq. Order: | 10 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-Letter unique code for LOCATION. |
REGIONCODE
Seq. Order: | 11 |
---|---|
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). |
LATITUDE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given Site |
LONGITUDE
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84, for the given Site |
CTDCASTID_ESD
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique numeric ID of CTD cast (4-digit number). |
SAMPLE_ID
Seq. Order: | 15 |
---|---|
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 |
STATION_ID
Seq. Order: | 16 |
---|---|
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. |
SAMPLE_FREQUENCY
Seq. Order: | 17 |
---|---|
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). |
DEPTH_METER
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth at which sample was collected (meters). |
SURVEY_DESIGN
Seq. Order: | 19 |
---|---|
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). |
YEAR_UTC
Seq. Order: | 20 |
---|---|
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) |
DAY_UTC
Seq. Order: | 21 |
---|---|
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) |
MONTH_UTC
Seq. Order: | 22 |
---|---|
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) |
TIMESTAMP_UTC
Seq. Order: | 23 |
---|---|
Data Storage Type: | DATE |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time of water sample in UTC |
TIME_UTC
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMERIC |
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
Seq. Order: | 25 |
---|---|
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 |
WATERSAMPLE_SAMPLEINTERVAL_SEC
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water sampling interval in seconds, as programmed by PUC |
ARAGONITE_SAT
Seq. Order: | 27 |
---|---|
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. |
DIC_UMOL_KG
Seq. Order: | 28 |
---|---|
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
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag for dissolved inorganic carbon values |
PCO2_UATM_CALCULATED
Seq. Order: | 30 |
---|---|
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. |
PH_TS_CALCULATED
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
pH calculated on Total Scale (TS) from DIC and TALK |
PRESSURE_DB_CALCULATED
Seq. Order: | 32 |
---|---|
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 |
PRESSURE_DB_CTD
Seq. Order: | 33 |
---|---|
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 |
SALINITY_PSS78_BEST
Seq. Order: | 34 |
---|---|
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
Seq. Order: | 35 |
---|---|
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) |
SALINITY_PSS78_BOTTLE
Seq. Order: | 36 |
---|---|
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
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for Salinity_PSS78 |
SALINITY_PSS78_CTD
Seq. Order: | 38 |
---|---|
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
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for CTDSAL |
SALINITY_PSS78_SCS
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Salinity measured by Scientific Computer System, SCS (SBE45) |
TALK_UMOL_KG
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total alkalinity measured in micromoles per kilogram. |
TALK_UMOL_KG_FLAG
Seq. Order: | 42 |
---|---|
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 |
TEMPERATURE_ITS90_BEST_ORIGIN
Seq. Order: | 43 |
---|---|
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) |
TEMPERATURE_ITS90_BEST
Seq. Order: | 44 |
---|---|
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_CTD
Seq. Order: | 45 |
---|---|
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
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Quality control flag for CTDTEMP |
TEMPERATURE_ITS90_SCS
Seq. Order: | 47 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Temperature measured by Scientific Computer System, SCS (SBE38) |
Catalog Details
Catalog Item ID: | 55948 |
---|---|
GUID: | gov.noaa.nmfs.inport:55948 |
Metadata Record Created By: | Annette M DesRochers |
Metadata Record Created: | 2019-03-22 19:34+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-08-03 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-08-03 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-08-03 |