Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Marianas Archipelago > National Coral Reef Monitoring Program: Diel se... >

ESD_NCRMP_DS_2022_MARIAN_H2O_DataDictionary

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:55425  |  Updated: March 11, 2025  |  Published / External 

Item Identification

Title: ESD_NCRMP_DS_2022_MARIAN_H2O_DataDictionary
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. In 2024, CTDCASTID_ESD was not applicable and was removed from data files and data dictionary.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 A single designation that applies to all the rounds associated with a given mission/cruise.
100
 MISSION_CODE TEXT More descriptive name of cruise/mission.
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
 OCC_SITEID TEXT A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-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
 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
 LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given site.
100
 LONGITUDE NUMERIC Longitude in decimal degrees, WGS84, for the given site.
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
 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 offshore for end member data (End_member); samples collected during diel suite surveys (Diel_suite); 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
 DEPTH_METER NUMERIC Depth at which sample was collected (meters).
100
 YEAR_UTC NUMERIC 4-digit year of the water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100
 MONTH_UTC NUMERIC Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100
 DAY_UTC NUMERIC Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS).
100
 TIMESTAMP_UTC DATE Date and time of water sample in UTC.
100
 TIME_UTC TIME UTC time of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS), hh:mm:ss.
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 or SAS. NULL for manual samples that were collected adjacent to, but not by, the PUC or SAS.
100
 ARAGONITE_SAT NUMERIC Calculated aragonite saturation from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
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 DIC_UMOL_KG.
100
 PCO2_UATM_CALCULATED NUMERIC Partial pressure in microatmospheres of carbon dioxide, calculated from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.
100
 PH_TS_CALCULATED NUMERIC pH calculated on Total Scale (TS) from DIC_UMOL_KG and TALK_UMOL_KG.
100
 PRESSURE_DB_CALCULATED NUMERIC Pressure in decibars calculated from DEPTH_METER (using the R package "oce") for samples not associated with a CTD cast. NULL if pressure was derived from CTD data.
100
 PRESSURE_DB_CTD NUMERIC Hydrostatic pressure in decibars recorded from CTD at the depth where the sample is taken.
100
 SALINITY_PSS78_BEST NUMERIC Best salinity value in practical salinity units associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
100
 SALINITY_PSS78_BEST_ORIGIN TEXT 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 in practical salinity units calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978. NULL if bottle salinity data were not collected or used for the respective sample.
100
 SALINITY_PSS78_BOTTLE_FLAG NUMERIC Quality control flag for SALINITY_PSS78_BOTTLE. NULL if bottle salinity data were not collected or used for the respective sample.
100
 SALINITY_PSS78_CTD NUMERIC Salinity in practical salinity units 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 SALINITY_PSS78_CTD.
100
 SALINITY_PSS78_SCS NUMERIC Salinity in practical salinity units measured by Scientific Computer System, SCS (SBE45). NULL for samples for which SCS data were not used.
100
 TALK_UMOL_KG NUMERIC Total alkalinity measured in micromoles per kilogram.
100
 TALK_UMOL_KG_FLAG NUMERIC Quality control flag for TALK_UMOL_KG.
100
 TEMPERATURE_ITS90_BEST_ORIGIN TEXT 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 and with the scale of ITS-90.
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 TEMPERATURE_ITS90_CTD.
100
 TEMPERATURE_ITS90_SCS NUMERIC Temperature measured by Scientific Computer System, SCS (SBE38) with the scale of ITS-90. NULL for samples for which SCS data were not used.

Attribute Details

DSUITEID

CC ID: 1078067
Seq. Order: 1
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for each Diel Suite deployed.

EXPOCODE

CC ID: 1078068
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

CC ID: 1078069
Seq. Order: 3
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.

MISSION_CODE

CC ID: 1078071
Seq. Order: 5
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

More descriptive name of cruise/mission.

ASSOC_REA_SITE

CC ID: 1078073
Seq. Order: 6
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.

OCC_SITEID

CC ID: 1078072
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.

REGION

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

REGIONCODE

CC ID: 1078077
Seq. Order: 9
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: 1078075
Seq. Order: 10
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: 1078076
Seq. Order: 11
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for LOCATION.

LATITUDE

CC ID: 1078078
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

CC ID: 1078079
Seq. Order: 13
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given site.

SAMPLE_ID

CC ID: 1078081
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

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

SURVEY_DESIGN

CC ID: 1078085
Seq. Order: 17
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 offshore for end member data (End_member); samples collected during diel suite surveys (Diel_suite); and shipboard samples collected to calibrate underway systems (Calibration).

SAMPLE_FREQUENCY

CC ID: 1078083
Seq. Order: 18
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

CC ID: 1078084
Seq. Order: 19
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Depth at which sample was collected (meters).

YEAR_UTC

CC ID: 1078086
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) or Subsurface Automated Samplers (SAS).

MONTH_UTC

CC ID: 1078088
Seq. Order: 21
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) or Subsurface Automated Samplers (SAS).

DAY_UTC

CC ID: 1078087
Seq. Order: 22
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) or Subsurface Automated Samplers (SAS).

TIMESTAMP_UTC

CC ID: 1078089
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

CC ID: 1078090
Seq. Order: 24
Data Storage Type: TIME
Required: No
Primary Key: No
Status: Active
Description:

UTC time of water sample collected by a Programmable Underwater Collector (PUC) or Subsurface Automated Samplers (SAS), hh:mm:ss.

YEARDAY_UTC

CC ID: 1078091
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

CC ID: 1078092
Seq. Order: 26
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Water sampling interval in seconds, as programmed by PUC or SAS. NULL for manual samples that were collected adjacent to, but not by, the PUC or SAS.

ARAGONITE_SAT

CC ID: 1078093
Seq. Order: 27
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated aragonite saturation from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.

DIC_UMOL_KG

CC ID: 1078094
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

CC ID: 1078095
Seq. Order: 29
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Flag for DIC_UMOL_KG.

PCO2_UATM_CALCULATED

CC ID: 1078096
Seq. Order: 30
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Partial pressure in microatmospheres of carbon dioxide, calculated from DIC_UMOL_KG, TALK_UMOL_KG, TEMPERATURE_ITS90_BEST, SALINITY_PSS78_BEST and PRESSURE_DB_CTD.

PH_TS_CALCULATED

CC ID: 1078097
Seq. Order: 31
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

pH calculated on Total Scale (TS) from DIC_UMOL_KG and TALK_UMOL_KG.

PRESSURE_DB_CALCULATED

CC ID: 1078098
Seq. Order: 32
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Pressure in decibars calculated from DEPTH_METER (using the R package "oce") for samples not associated with a CTD cast. NULL if pressure was derived from CTD data.

PRESSURE_DB_CTD

CC ID: 1078099
Seq. Order: 33
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

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

SALINITY_PSS78_BEST

CC ID: 1078100
Seq. Order: 34
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

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

SALINITY_PSS78_BEST_ORIGIN

CC ID: 1078101
Seq. Order: 35
Data Storage Type: TEXT
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

CC ID: 1078102
Seq. Order: 36
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity in practical salinity units calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978. NULL if bottle salinity data were not collected or used for the respective sample.

SALINITY_PSS78_BOTTLE_FLAG

CC ID: 1078103
Seq. Order: 37
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for SALINITY_PSS78_BOTTLE. NULL if bottle salinity data were not collected or used for the respective sample.

SALINITY_PSS78_CTD

CC ID: 1078104
Seq. Order: 38
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity in practical salinity units calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978.

SALINITY_PSS78_CTD_FLAG

CC ID: 1078105
Seq. Order: 39
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for SALINITY_PSS78_CTD.

SALINITY_PSS78_SCS

CC ID: 1078106
Seq. Order: 40
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Salinity in practical salinity units measured by Scientific Computer System, SCS (SBE45). NULL for samples for which SCS data were not used.

TALK_UMOL_KG

CC ID: 1078107
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

CC ID: 1078108
Seq. Order: 42
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for TALK_UMOL_KG.

TEMPERATURE_ITS90_BEST_ORIGIN

CC ID: 1078109
Seq. Order: 43
Data Storage Type: TEXT
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

CC ID: 1078110
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 and with the scale of ITS-90.

TEMPERATURE_ITS90_CTD

CC ID: 1078111
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

CC ID: 1078112
Seq. Order: 46
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Quality control flag for TEMPERATURE_ITS90_CTD.

TEMPERATURE_ITS90_SCS

CC ID: 1078113
Seq. Order: 47
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Temperature measured by Scientific Computer System, SCS (SBE38) with the scale of ITS-90. NULL for samples for which SCS data were not used.

Catalog Details

Catalog Item ID: 55425
GUID: gov.noaa.nmfs.inport:55425
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-01-31 22:39+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2025-03-11 17:14+0000
Metadata Record Published: 2025-03-11
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-08-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-08-06