50383 Entity Published / External 46163 Water chemistry at coral reef sites in Timor-Leste from discrete surface and bottom water samples collected in 2013 and 2014 Data Set Water Chemistry Entity and Attributes Spreadsheet Yes Water Chemistry Entity and Attributes Updated 10-2021 with relevant columns for data revisions 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. YEAR_UTC NUMERIC No No Active 4-digit year of the water sample collected by a Programmable Underwater Collector (PUC) CAST_NUMBER NUMERIC No No Active Cast number, where a cast is the lowering of equipment over the side at one station (STATION_ID). Cast_number is sequential and starts with 1 for each station. CRUISE_ID TEXT No No Active Mission Identifier CTDCASTID_ESD NUMERIC No No Active Unique numeric ID of CTD cast (4-digit number). DAY_UTC NUMERIC No No Active Numeric day in UTC of water sample collected by a Programmable Underwater Collector (PUC) DEPTH_METER NUMERIC No No Active Depth at which sample was collected (meters). 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. DIC_UMOL_KG_FLAG NUMERIC No No Active Flag for dissolved inorganic carbon values EXPOCODE TEXT No No Active Defined as the Ship ICES code + departure date formatted as YYYYMMDD LATITUDE_DEC NUMERIC No No Active Latitude in decimal degrees, WGS84, for the given Site LOCATION TEXT No No Active Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). LOCATIONCODE TEXT No No Active 3-Letter unique code for LOCATION. LONGITUDE_DEC NUMERIC No No Active Longitude in decimal degrees, WGS84, for the given Site MONTH_UTC NUMERIC No No Active Numeric month in UTC of water sample collected by a Programmable Underwater Collector (PUC) PCO2_UATM_CALCULATED NUMERIC No No Active Partial pressure of carbon dioxide, calculated from DIC, TA, temperature, salinity, and pressure. PH_TS_CALCULATED NUMERIC No No Active pH calculated on Total Scale (TS) from DIC and TALK PRESSURE_DB_CALCULATED NUMERIC No No Active Pressure calculated from depth (using the R package "oce") for samples not associated with a CTD cast PRESSURE_DB_CTD NUMERIC No No Active Hydrostatic pressure recorded from CTD at the depth where the sample is taken REGION TEXT No No Active The name of the region where the CTD cast was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. 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). 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. 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) 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 SALINITY_PSS78_BOTTLE_FLAG NUMERIC No No Active Quality control flag for Salinity_PSS78 SALINITY_PSS78_CTD NUMERIC No No Active Salinity calculated from conductivity recorded by CTD using the equation of the Practical Salinity Scale of 1978 SALINITY_PSS78_CTD_FLAG NUMERIC No No Active Quality control flag for CTDSAL SALINITY_PSS78_SCS NUMERIC No No Active Salinity measured by Scientific Computer System, SCS (SBE45) 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). SAMPLE_ID NUMERIC No No Active Unique numeric identifer for each water sample (4-digit number) associated with Station_ID and Cast_number 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. 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). TALK_UMOL_KG NUMERIC No No Active Total alkalinity measured in micromoles per kilogram. TALK_UMOL_KG_FLAG NUMERIC No No Active Quality control flag for TALK; TA_QC from V_OCC_A_H2O_FIELDDATA_OBS TEMPERATURE_ITS90_BEST NUMERIC No No Active Best temperature value associated with the sample, derived from either TEMPERATURE_ITS90_CTD or TEMPERATURE_ITS90_SCS TEMPERATURE_ITS90_BEST_ORIGIN NUMERIC No No Active source of 'TEMPERATURE_ITS90_BEST' measurement: CTD (TEMPERATURE_ITS90_CTD) or SCS (TEMPERATURE_ITS90_SCS) TEMPERATURE_ITS90_CTD NUMERIC No No Active In situ temperature recorded from CTD with the scale of ITS-90. TEMPERATURE_ITS90_CTD_FLAG NUMERIC No No Active Quality control flag for CTDTEMP TEMPERATURE_ITS90_SCS NUMERIC No No Active Temperature measured by Scientific Computer System, SCS (SBE38) TIMESTAMP_UTC DATE No No Active Date and time of water sample in UTC TIME_UTC DATE No No Active UTC time of water sample collected by a Programmable Underwater Collector (PUC), hh:mm:ss in 4-hr intervals. YEARDAY_UTC NUMERIC No No Active Decimal value of the days, hours, and minutes from the beginning of the year ASSOC_OCC_SITEID TEXT No No Active An identifier for the fixed NCRMP climate site associated with the sample, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. A sample is assigned an ASSOC_OCC_SITEID only if its coordinates (LATITUDE and LONGITUDE) are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned (NULL). gov.noaa.nmfs.inport:50383 Annette DesRochers 2017-11-27T13:59:36 SysAdmin InPortAdmin 2022-08-09T17:11:38 2021-10-28 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-10-28 1 Year 2022-10-28