55948
ESD_DS_DataDict_2018_PRIA_H2O
Entity
Published / External
54926
National Coral Reef Monitoring Program: Diel seawater carbonate chemistry observations from a suite of instrumentation deployed at coral reef sites in the Pacific Remote Islands Marine National Monument since 2015
Data Set
Completed
Water sample entity and attributes for diel surveys. Includes columns specifically for outsourced water sample analysis (to PMEL) such as flags for quality control.
Data Table
Yes
Water sample entities and attributes for diel surveys.
In 2021 columns were renamed and added to standardize data structure.
1
DSUITEID
NUMERIC
No
No
Active
Unique identifier for each Diel Suite deployed
2
EXPOCODE
TEXT
No
No
Active
Defined as the Ship ICES code + departure date formatted as YYYYMMDD
3
CRUISE_ID
TEXT
No
No
Active
Mission Identifier
4
CRUISE_COMMON_NAME
TEXT
No
No
Active
More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
5
MISSION_CODE
TEXT
No
No
Active
A single designation that applies to all the rounds associated with a given mission/cruise
6
OCC_SITEID
TEXT
No
No
Active
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.
7
ASSOC_REA_SITE
TEXT
No
No
Active
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.
8
REGION
TEXT
No
No
Active
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.
9
LOCATION
TEXT
No
No
Active
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
10
LOCATIONCODE
TEXT
No
No
Active
3-Letter unique code for LOCATION.
11
REGIONCODE
TEXT
No
No
Active
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).
12
LATITUDE
NUMERIC
No
No
Active
Latitude in decimal degrees, WGS84, for the given Site
13
LONGITUDE
NUMERIC
No
No
Active
Longitude in decimal degrees, WGS84, for the given Site
14
CTDCASTID_ESD
NUMERIC
No
No
Active
Unique numeric ID of CTD cast (4-digit number).
15
SAMPLE_ID
NUMERIC
No
No
Active
Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number
16
STATION_ID
TEXT
No
No
Active
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.
17
SAMPLE_FREQUENCY
TEXT
No
No
Active
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).
18
DEPTH_METER
NUMERIC
No
No
Active
Depth at which sample was collected (meters).
19
SURVEY_DESIGN
TEXT
No
No
Active
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).
20
YEAR_UTC
NUMERIC
No
No
Active
4-digit year of the water sample collected by a Programmable Underwater Collector (PUC)
21
DAY_UTC
NUMERIC
No
No
Active
Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC)
22
MONTH_UTC
NUMERIC
No
No
Active
Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC)
23
TIMESTAMP_UTC
DATE
No
No
Active
Date and time of water sample in UTC
24
TIME_UTC
NUMERIC
No
No
Active
UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals.
25
YEARDAY_UTC
NUMERIC
No
No
Active
Decimal value of the days, hours, and minutes from the beginning of the year
26
WATERSAMPLE_SAMPLEINTERVAL_SEC
NUMERIC
No
No
Active
Water sampling interval in seconds, as programmed by PUC
27
ARAGONITE_SAT
NUMERIC
No
No
Active
Calculated aragonite saturation based on CTD measurements made during sample collection. Calculated from DIC, TA, temperature, salinity and pressure.
28
DIC_UMOL_KG
NUMERIC
No
No
Active
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.
29
DIC_UMOL_KG_FLAG
NUMERIC
No
No
Active
Flag for dissolved inorganic carbon values
30
PCO2_UATM_CALCULATED
NUMERIC
No
No
Active
Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure.
31
PH_TS_CALCULATED
NUMERIC
No
No
Active
pH calculated on Total Scale (TS) from DIC and TALK
32
PRESSURE_DB_CALCULATED
NUMERIC
No
No
Active
Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast
33
PRESSURE_DB_CTD
NUMERIC
No
No
Active
Hydrostatic pressure recorded from CTD at the depth where the sample is taken
34
SALINITY_PSS78_BEST
NUMERIC
No
No
Active
Best salinity value associated with the sample, derived from either SALINITY_PSS78_CTD, SALINITY_PSS78_BOTTLE, or SALINITY_PSS78_SCS.
35
SALINITY_PSS78_BEST_ORIGIN
NUMERIC
No
No
Active
source of 'SALINITY_PSS78_BEST' measurement: CTD (SALINITY_PSS78_CTD), discrete bottle sample (SALINITY_PSS78_BOTTLE), or SCS (SALINITY_PSS78_SCS)
36
SALINITY_PSS78_BOTTLE
NUMERIC
No
No
Active
Salinity calculated from conductivity measured from discrete bottles using the equation of the Practical Salinity Scale of 1978
37
SALINITY_PSS78_BOTTLE_FLAG
NUMERIC
No
No
Active
Quality control flag for Salinity_PSS78
38
SALINITY_PSS78_CTD
NUMERIC
No
No
Active
Salinity calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978
39
SALINITY_PSS78_CTD_FLAG
NUMERIC
No
No
Active
Quality control flag for CTDSAL
40
SALINITY_PSS78_SCS
NUMERIC
No
No
Active
Salinity measured by Scientific Computer System, SCS (SBE45)
41
TALK_UMOL_KG
NUMERIC
No
No
Active
Total alkalinity measured in micromoles per kilogram.
42
TALK_UMOL_KG_FLAG
NUMERIC
No
No
Active
Quality control flag for TALK; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS
43
TEMPERATURE_ITS90_BEST_ORIGIN
NUMERIC
No
No
Active
source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS)
44
TEMPERATURE_ITS90_BEST
NUMERIC
No
No
Active
Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS
45
TEMPERATURE_ITS90_CTD
NUMERIC
No
No
Active
In situ temperature recorded from CTD with the scale of ITS-90.
46
TEMPERATURE_ITS90_CTD_FLAG
NUMERIC
No
No
Active
Quality control flag for CTDTEMP
47
TEMPERATURE_ITS90_SCS
NUMERIC
No
No
Active
Temperature measured by Scientific Computer System, SCS (SBE38)
gov.noaa.nmfs.inport:55948
Annette DesRochers
2019-03-22T19:34:18
SysAdmin InPortAdmin
2022-08-09T17:11:02
2021-08-03
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-08-03
1 Year
2022-08-03