D3.v1_Reference_Open_Database_Development

This dataset is composed of the data collected during 2023 and 2024 sampling campaigns conducted as part of the TARA Expedition, the TARA-TREC project and the associated ESA funded HyperBOOST campaign. Sampling was carried out (a) during the TARA23 campaign, from April to November 2023, along the coasts of the Baltic Sea, North Sea, and Atlantic Ocean; (b) during the TARA24 campaign, from April to August 2024, along the Mediterranean coastline; and (c) during the HyperBOOST campaign in August 2024, which focused on open-ocean waters. The resulting dataset covers a broad range of coastal environment across Europe, including the Mediterranean Sea, North Atlantic Ocean and the Baltic Sea. It comprises 136 co-located stations with measurements of hyperspectral Rrs, Temperature and biogeochemical parameters. Measurements included in this subset passed through a quality control (QC) by the partners of the HyperBOOST project and the database comprises only the final version of the dataset.Dataset comprised of four .csv files, each of them for a different set of parameters:• CHIME-like Rrs, std CHIME and Uncertainties• LSTM-like SST and Uncertainties• Carbon-related parameters: Turb, SPM, PIF, POF, PIF/POF, POC, DOC, TOC, C_N, dC13, C% and phytoplankton pigments• Absorption: Hyperspectral ap (300 – 800 nm), aphy(300 – 800 nm), aNAP (300 – 800 nm) and aCDOM (230 – 700 nm). • CHIME-like Rrs data are provided in the file SUPaCOOL_D3v1_Rrs.csv, formatted as a comma-delimited csv file. This file contains 174 rows and 300 columns, including:• Meta and auxiliary data (columns 1 – 12) ‘id’, 'Cruise', 'StationNumber', 'StationName', 'dateDd_mm_yyyy', 'Latitude_oN_' (decimal degrees, with Southern Hemisphere coordinates reported as negative values), 'Longitude_oE_' (decimal degrees, with Western Hemisphere coordinates reported as negative values), ‘TimeStart_datetime’, ‘TimeEnd_datetime’, ‘Salinity_psu’, ‘Temperature_C’, ‘Instrument’. • CHIME-like Remote-sensing reflectance between 400 to 800 nm (columns 13 – 60)'Rrs_404.2', 'Rrs_412.6', 'Rrs_421.0', etc. Units sr-1• Total Uncertainty of CHIME-like Rrs (columns 61 – 108). Total uncertainty represents spectrally uncorrelatated random errors due to: (i) errors in in-situ measurements, (ii) errors in instrumental convolution, and (iii) sensor noise at the top of the atmosphere.'Rrs_404.2_unc', 'Rrs_412.6_unc', 'Rrs_421.0_unc', etc. Units sr-1• Errors in in-situ measurements (columns 109 – 156). 'Rrs_404.2_unc_i', 'Rrs_412.6_unc_i', 'Rrs_421.0_unc_i', etc. Units sr-1• Errors in instrumental convolution (columns 157 – 204).'Rrs_404.2_unc_c', 'Rrs_412.6_unc_c', 'Rrs_421.0_unc_c', etc. Units sr-1• Sensor noise at the top of the atmosphere (columns 205 – 252). 'Rrs_404.2_unc_n', 'Rrs_412.6_unc_n', 'Rrs_421.0_unc_n', etc. Units sr-1• Uncertainty due to radiometric accuracy at the top of the atmosphere represents spectrally fully-correlated errors (columns 253 – 300).'Rrs_404.2_unc_a', 'Rrs_412.6_unc_a', 'Rrs_421.0_unc_a’, etc. Units sr-1 • LSTM-like SST data are contained in the SUPaCOOL_D3v1_SST.csv, formatted as a comma-delimited csv file. This file contains 137 rows and 13 columns.• Meta and auxiliary data (columns 1 – 11) ‘id’, 'Cruise', 'StationNumber', 'StationName', 'dateDd_mm_yyyy', 'Latitude_oN_' (decimal degrees, with Southern Hemisphere coordinates reported as negative values), 'Longitude_oE_' (decimal degrees, with Western Hemisphere coordinates reported as negative values), ‘TimeStart_datetime’, ‘TimeEnd_datetime’, ‘Salinity_psu’, ‘Temperature_C’. • LSTM-like SST (column 12)'SST'. Units °C• Uncertainties of LSTM-like SST (column 13) 'SST_unc'. Units °C • Carbon-related parameters and phytoplankton pigments retrieved by HPLC are contained in the SUPaCOOL_D3v1_carbon.csv, formatted as a comma-delimited csv file. This file contains 137 rows and 54 columns.• Meta and auxiliary data (columns 1 – 11) ‘id’, 'Cruise', 'StationNumber', 'StationName', 'dateDd_mm_yyyy', 'Latitude_oN_' (decimal degrees, with Southern Hemisphere coordinates reported as negative values), 'Longitude_oE_' (decimal degrees, with Western Hemisphere coordinates reported as negative values), ‘TimeStart_datetime’, ‘TimeEnd_datetime’, ‘Salinity_psu’, ‘Temperature_C’. • ‘Turbidity’. Units FNU (column 12)• ‘SPM’. Units mg.L-1 (column 13)• ‘PIF’, ‘POF’. Units % (columns 14 – 15)• ‘PIF/POF’. Dimensionless (column 16)• POC, DOC, TOC. Units uM (columns 17 – 19)• C_N, dC13, C % (columns 20 – 22)• Pigment concentrations (columns 23 – 54)'Allo', ‘Anthera’, ‘Asta’, ‘BChla’, 'But', 'Chlc2', ‘Chlc2MGDG’, 'Chlc3', ‘Chldb’, 'Diadino', 'Diato', 'DVchla', 'DVChlb', 'Fuco', 'Hex', ’Hex4k’, 'Lut', ‘Monado’, 'MVchla', 'MVChlb', ‘Myxo’, 'Neo', 'Peri', ’Phda’, ‘Phytna’, 'Pras', ‘sumChlda’, 'Tcar', 'TChla', 'TChlb', 'Viola', 'Zea'. Units mg m-3. • Hyperspectral aCDOM, ap, aphy and aNAP data are contained in the SUPaCOOL_D3v1_absorption.csv, formatted as a comma-delimited csv file. This file contains 137 rows and 1985 columns.• Meta and auxiliary data (columns 1 – 11) ‘id’, 'Cruise', 'StationNumber', 'StationName', 'dateDd_mm_yyyy', 'Latitude_oN_' (decimal degrees, with Southern Hemisphere coordinates reported as negative values), 'Longitude_oE_' (decimal degrees, with Western Hemisphere coordinates reported as negative values), ‘TimeStart_datetime’, ‘TimeEnd_datetime’, ‘Salinity’, ‘Temperature’. • ap from 300 to 800 nm (columns 12 - 512)‘ap_300', 'ap_301', 'ap_302', etc. Units m-1• aNAP from 300 to 800 nm (columns 513 – 1013)‘anap_300', ' anap_301', ' anap_302', etc. Units m-1• aphy from 300 to 800 nm (columns 1014 - 1514)‘aph_300', 'aph_301', 'aph_302', etc. Units m-1• acdom from 230 to 700 nm (columns 1515 – 1985)‘aCDOM_230’, ‘aCDOM _231’, etc. Units m-1