Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: ESD_DS_DataDict_2017_CNMI_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

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 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

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:

Mission Identifier

CRUISE_COMMON_NAME

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

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

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

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

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.

LOCATION

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

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

3-Letter unique code for LOCATION.

REGIONCODE

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

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

CTDCASTID_ESD

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

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.

SAMPLE_FREQUENCY

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

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

Depth at which sample was collected (meters).

SURVEY_DESIGN

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

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)

DAY_UTC

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

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

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: 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

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

ARAGONITE_SAT

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

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 dissolved inorganic carbon values

PCO2_UATM_CALCULATED

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

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 and TALK

PRESSURE_DB_CALCULATED

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

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

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

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

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

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

Quality control flag for Salinity_PSS78

SALINITY_PSS78_CTD

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

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

Quality control flag for CTDSAL

SALINITY_PSS78_SCS

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

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; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS

TEMPERATURE_ITS90_BEST_ORIGIN

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

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

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 CTDTEMP

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)

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-08-06
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