Sea level data archaeology at Socoa (Saint Jean-de-Luz, France)

<strong>1. Description</strong> This repository contains the data, notebooks, and documents covering the archeology and rescue of tide gauge observation at Socoa (Saint Jean-de-Luz, Southwestern France), and is complementary to the paper (henceforth "data paper") titled "Extension of high temporal resolution sea level time series at Socoa (Saint Jean-de-Luz, France) back to 1875". Authors: Md Jamal Uddin Khan, Inge Van Den Beld, Guy Woppelmann, Laurent Testut, Alexa Latapy, Nicolas Pouvreau For up-to-date sea level timeseries, visit the Shom data distribution portal linked in the Related identifier section below. At the time of writing, corrected and valid data over 1875 to date at original sampling is identified as 'Validées temps différé'. The data and source-codes presented here is open-access. Please consider citing the data paper if you use the data. More information is given in the Data-use section below. A brief structure of the files contained in this repository is shown below, and a brief description is given in the following sections - <pre><code>|- data |- auxiliary |- brest_data.shom.fr/ |- santander_marcos_etal.dat |- socoa |- data.shom.fr/ |- corrections.csv |- corrections_marigram.csv |- corrections_registry.csv |- data_inventory.csv |- socoa_L0.csv |- socoa_L1.csv |- socoa_L2.csv |- socoa_L2_nominal.csv |- socoa_L3.csv |- socoa_L4.csv |- socoa_raw.txt |- documents |- archive_records |- AD64__Pau_4S 33.docx |- Archives_Shom_plusieursCotes.docx |- SHD_Brest_MB3W.docx |- SHD_Rochefort_7JJ418-7JJ1551.docx |- SHD_Vincennes_plusieurCotes.docx |- tidegauge_journal |- &lt;year&gt;_Socoa_Notes_Registres.docx |- inventory.xlsx |- figures |- figure01 |- ... |- figure 06 |- supp |- notebooks |- 01_data_processing.ipynb |- 02_buddy_checking.ipynb |- 03_trend_analysis.ipynb |- README.md</code></pre> <strong>2. Data and codes</strong> <strong>2.1 Data (<em>/data</em>)</strong> Data directory (/data) contains two folder - auxiliary, and socoa. /data/socoa contains raw data (socoa_raw.txt) as well as processed dataset (socoa_L*.csv). The directory also contains information regarding the data inventory (data_inventory.csv), and the corrections applied during the processing (corrections_*.csv). A snapshot of data from https://data.shom.fr (April 2022) is also available in the /data/socoa/data.shom.fr directory. Data files corresponding to various level of dataset is following - Level 0: No corrections applied (/data/socoa/socoa_L0.csv) Level 1: Time corrections applied, including conversion to UTC time (/data/socoa/socoa_L1.csv) Level 2: Time and height corrections applied (/data/socoa/socoa_L2.csv) Level 3: Hourly interpolated and merged with existing data (/data/socoa/socoa_L3.csv) Level 4: Hourly data additionally flagged for siltation from tidal analysis (/data/socoa/socoa_L4.csv) All datafiles are provided as standard comma-separated text files encoded in utf-8. The final Level 4 data has three columns with column header titled - Datetime, Value, and Flag, where, Datetime: The UTC timestamp of the data Value: Sea level with respect to Hydrographic Zero Flag: Data flag as described in the data paper In addition, Level 4 data contains the following information header - <pre><code># Station: SAINT-JEAN-DE-LUZ_SOCOA # Longitude: -1.68162 # Latitude: 43.39524 # Organization: Shom, Pyrénées-Atlantiques # Timesystem: UTC # VerticalReference: Hydrographic Zero # Unit: m # Flag: 4-bit flags yes(1)/no(0) - [siltation][uncertain_correction][height_correction][time_correction] # DOI_DataPaper: Data: 10.5281/zenodo.7438469, Article: 10.5194/essd-2022-443 # DOI_SHOM: 10.17183/REFMAR#95</code></pre> /data/auxiliary contains the auxiliary dataset used for analysis and comparison in the data paper. Brest dataset, /data/auxiliary/brest_data.shom.fr, is retrieved from https://data.shom.fr. Monthly sea level at Santander, /data/auxiliary/santander_marcos_etal.dat, comes from the dataset published by Marcos et al. (2020). <strong>2.2 Documents (<em>/documents</em>)</strong> The <em>/documents</em> folder contains supplimentary documents related to the dataset. <em>/documents/tidegauge_journal</em> contains the extraction from the tide gauge journal year by year. The files are named as – <em>YEAR_Socoa_Notes_Registres.docx</em> where <em>YEAR</em> is the 4-digit year. <em>/documents/archive_records</em> contains the excerpts of metadata documents from the various archives. For 5 archives, 5 separate files are provided. These archives are and file names are – Service historique de la Défense (SHD) at Brest (SHD-Brest): <em>SHD_Brest_MB3W.docx</em> Service historique de la Défense (SHD) at Rochefort (SHD-Rochefort): <em>SHD_Rochefort_7JJ418-7JJ1551.docx</em> Service historique de la Défense (SHD) at Vincennes (SHD-Vincennes): <em>SHD_Vincennes_plusieurCotes.docx</em> Archives des Pyrénées-Atlantiques (AD64): <em>AD64_Pau_4S 33.docx</em> SHOM archive: <em>Archives_Shom_plusieursCotes.docx</em> <em>/documents/inventory.xlsx</em> gives an overall inventory of the historic documents catalogued. <strong>2.3 Figures (<em>/figures</em>)</strong> The figures directory (<em>/figures</em>) contains the figures presented in the accompanying data paper organized into individual directories for each figure. The most of the figures related to the analysis is generated using python and their source-code is provided in the <em>/notebooks</em> directory. In case where external graphical software has been used for generating the final image is provided inside the directory for each individual figure. <strong>2.4 Codes (<em>/notebooks</em>)</strong> The codes used in processing this data is provided in the `/notebooks` directory. The full code is segmented into three self-contained python/jupyter notebooks - Data processing (<em>01_data_processing.ipynb</em>) Buddy checking (<em>02_buddy_checking.ipynb</em>) Trend analysis (<em>03_trend_analysis.ipynb</em>) The python environment necessary for running the notebooks can be created using <em>conda</em> (https://www.anaconda.com/products/distribution) with the following commands - <pre><code class="language-bash">conda create -n socoa python=3.7 numpy scipy statsmodels cartopy netcdf4 pandas xarray jupyter conda activate socoa pip install utide==0.2.6 jupyter-notebook</code></pre> <strong>3. Data-use information</strong> Citation: Khan, M. J. U., Van Den Beld, I., Wöppelmann, G., Testut, L., Latapy, A., and Pouvreau, N.: Extension of high temporal resolution sea level time series at Socoa (Saint Jean-de-Luz, France) back to 1875, Earth Syst. Sci. Data Discuss. [preprint], https://doi.org/10.5194/essd-2022-443, in review, 2023. Use rights: The data and source-code is freely available to anyone. Please consider citing the data paper using the citation above. License: Creative Commons Attribution 4.0 International (CC BY 4.0) <strong>4. Related identifiers</strong> SHOM historical dataset portal: http://refmar.shom.fr/dataRescue/HTML/FR/SOCOA%20(SAINT-JEAN-DE-LUZ).html SHOM data distribution portal: http://dx.doi.org/10.17183/REFMAR#95