56573 Entity Published / External 45954 Diel seawater carbonate chemistry observations from a suite of instrumentation deployed at coral reef sites in Batangas, Philippines from May 21-31, 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:56573 Annette DesRochers 2019-05-31T06:59:45 SysAdmin InPortAdmin 2022-08-09T17:11:15 2021-09-01 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2021-09-01 1 Year 2022-09-01