notebooks/ROI/01_Offshore/00_Set_Database.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "... ***CURRENTLY UNDER DEVELOPMENT*** ...\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#!/usr/bin/env python\n",
    "# -*- coding: utf-8 -*-\n",
    "\n",
    "# common\n",
    "import os\n",
    "import os.path as op\n",
    "import sys\n",
    "\n",
    "# DEV: override installed teslakit\n",
    "import sys\n",
    "sys.path.insert(0, op.join(os.path.abspath(''), '..', '..', '..'))\n",
    "\n",
    "# teslakit \n",
    "from teslakit.database import Database\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "## Database and Site"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Teslakit Site already exists at /Users/nico/Projects/TESLA-kit/TeslaKit/data/sites/ROI\n"
     ]
    }
   ],
   "source": [
    "# --------------------------------------\n",
    "# Teslakit database\n",
    "\n",
    "p_data = r'/Users/nico/Projects/TESLA-kit/TeslaKit/data'\n",
    "db = Database(p_data)\n",
    "\n",
    "# make new site\n",
    "db.MakeNewSite('ROI')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+--------------------+-----------+-----------------------------------------------+\n",
      "| database ID        | available | site path                                     |\n",
      "+--------------------+-----------+-----------------------------------------------+\n",
      "| MJO.hist           | True      | sites/ROI/MJO/MJO_hist.nc                     |\n",
      "| TCs.noaa           | True      | sites/ROI/TCs/Allstorms.ibtracs_wmo.v03r10.nc |\n",
      "| SST.hist_pacific   | True      | sites/ROI/SST/SST_1854_2017_Pacific.nc        |\n",
      "| WAVES.spectra      | True      | sites/ROI/WAVES/waves_spec_csiro.nc           |\n",
      "| ESTELA.coastmat    | True      | sites/ROI/ESTELA/Costa.mat                    |\n",
      "| ESTELA.estelamat   | True      | sites/ROI/ESTELA/Kwajalein_roi_obj.mat        |\n",
      "| ESTELA.slp         | True      | sites/ROI/ESTELA/SLP.nc                       |\n",
      "| TIDE.mareografo_nc | True      | sites/ROI/TIDE/Mareografo_KWA.nc              |\n",
      "| TIDE.hist_astro    | True      | sites/ROI/TIDE/tide_astro_hist.nc             |\n",
      "+--------------------+-----------+-----------------------------------------------+\n"
     ]
    }
   ],
   "source": [
    "# TODO: guide to create a new site and input data acquisition\n",
    "\n",
    "\n",
    "# --------------------------------------\n",
    "# Manually set required input files for teslakit execution:\n",
    "#\n",
    "# MJO.hist                = MJO_hist.nc  # historical MJO (http://www.bom.gov.au/climate/mjo/graphics/rmm.74toRealtime.txt)\n",
    "#\n",
    "# TCs.noaa                = Allstorms.ibtracs_wmo.v03r10.nc (ftp://eclipse.ncdc.noaa.gov/pub/ibtracs/v03r10/wmo/netcdf/)\n",
    "# TCs.nakajo_mats         = Nakajo_tracks (folder containing nakajo TCs with .mat files)\n",
    "#\n",
    "# SST.hist_pacific        = SST_1854_2017_Pacific.nc (Sea Surface Temperature at Pacific area, ERSSTv4)\n",
    "#\n",
    "# WAVES.spectra           = wave_spec_csiro.nc (waves spectra at point, from CSIRO database)\n",
    "#\n",
    "# ESTELA.coastmat         = Costa.mat (ESTELA coast)\n",
    "# ESTELA.estelamat        = kwajalein_roi_obj.mat (ESTELA data)\n",
    "# ESTELA.gowpoint         = gow2_062_ 9.50_167.25.mat (ESTELA waves data)\n",
    "# ESTELA.slp              = SLP.nc (Sea Level Pressure, extracted from CFSR)\n",
    "#\n",
    "# TIDE.mareografo_nc      = Mareografo_KWA.nc (tide gauge)\n",
    "# TIDE.hist_astro         = tide_astro_hist.nc (astronomical historical tide)\n",
    "#\n",
    "# HYCREWW.rbf_coef        = Hycreww runup RBF coefficients\n",
    "#\n",
    "# NEARSHORE.swan_projects = SWAN numerical model input data (main mesh and nested mesh)\n",
    "\n",
    "# check input files\n",
    "db.CheckInputFiles()\n",
    "\n",
    "# if all input files are available then start with the project notebooks\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "## Check input files format\n",
    "\n",
    "A template of each input file is shown next. While preparing a new site, adjusting databases to theese templates will ease integration with current Teslakit notebooks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:  (time: 14343)\n",
      "Coordinates:\n",
      "  * time     (time) datetime64[ns] 1979-01-01 1979-01-02 ... 2018-04-08\n",
      "Data variables:\n",
      "    phase    (time) int64 ...\n",
      "    rmm1     (time) float64 ...\n",
      "    rmm2     (time) float64 ...\n",
      "    mjo      (time) float64 ...\n"
     ]
    }
   ],
   "source": [
    "# MJO.hist\n",
    "\n",
    "data = db.Load_MJO_hist()\n",
    "print(data)\n",
    "\n",
    "template = '''\n",
    "<xarray.Dataset>\n",
    "Dimensions:  (time: 14343)\n",
    "Coordinates:\n",
    "  * time     (time) datetime64[ns] 1979-01-01 1979-01-02 ... 2018-04-08\n",
    "Data variables:\n",
    "    phase    (time) int64 ...\n",
    "    rmm1     (time) float64 ...\n",
    "    rmm2     (time) float64 ...\n",
    "    mjo      (time) float64 ...\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:          (center: 26, storm: 7367, time: 137)\n",
      "Dimensions without coordinates: center, storm, time\n",
      "Data variables:\n",
      "    storm_sn         (storm) |S13 ...\n",
      "    name             (storm) |S57 ...\n",
      "    numObs           (storm) int16 ...\n",
      "    season           (storm) int16 ...\n",
      "    track_type       (storm) int8 ...\n",
      "    genesis_basin    (storm) int8 ...\n",
      "    num_basins       (storm) int8 ...\n",
      "    basin            (storm, time) float32 ...\n",
      "    wind_avg_period  (center) float32 ...\n",
      "    source           (center) |S10 ...\n",
      "    time_wmo         (storm, time) datetime64[ns] ...\n",
      "    lat_wmo          (storm, time) float32 ...\n",
      "    lon_wmo          (storm, time) float32 ...\n",
      "    alt              (storm, time) float32 ...\n",
      "    wind_wmo         (storm, time) float32 ...\n",
      "    pres_wmo         (storm, time) float32 ...\n",
      "    sub_basin        (storm, time) float32 ...\n",
      "    nature_wmo       (storm, time) float32 ...\n",
      "    source_wmo       (storm, time) float32 ...\n",
      "    dist2land        (storm, time) float32 ...\n",
      "    landfall         (storm, time) float32 ...\n",
      "Attributes:\n",
      "    Title:                IBTrACS-WMO: NetCDF reformat\n",
      "    Version:              v03r10\n",
      "    Description:          IBTrACS-WMO data reformatted to contain \\nall data ...\n",
      "    cdm_datatype:         Trajectory\n",
      "    trajectoryDimension:  storm\n",
      "    Conventions:          CF-1.0\n",
      "    metadata_link:        gov.noaa.ncdc:C00834\n"
     ]
    }
   ],
   "source": [
    "# TCs.noaa\n",
    "\n",
    "data = db.Load_TCs_noaa()\n",
    "print(data)\n",
    "\n",
    "template = '''\n",
    "<xarray.Dataset>\n",
    "Dimensions:          (center: 26, storm: 7367, time: 137)\n",
    "Dimensions without coordinates: center, storm, time\n",
    "Data variables:\n",
    "    storm_sn         (storm) |S13 ...\n",
    "    name             (storm) |S57 ...\n",
    "    numObs           (storm) int16 ...\n",
    "    season           (storm) int16 ...\n",
    "    track_type       (storm) int8 ...\n",
    "    genesis_basin    (storm) int8 ...\n",
    "    num_basins       (storm) int8 ...\n",
    "    basin            (storm, time) float32 ...\n",
    "    wind_avg_period  (center) float32 ...\n",
    "    source           (center) |S10 ...\n",
    "    time_wmo         (storm, time) datetime64[ns] ...\n",
    "    lat_wmo          (storm, time) float32 ...\n",
    "    lon_wmo          (storm, time) float32 ...\n",
    "    alt              (storm, time) float32 ...\n",
    "    wind_wmo         (storm, time) float32 ...\n",
    "    pres_wmo         (storm, time) float32 ...\n",
    "    sub_basin        (storm, time) float32 ...\n",
    "    nature_wmo       (storm, time) float32 ...\n",
    "    source_wmo       (storm, time) float32 ...\n",
    "    dist2land        (storm, time) float32 ...\n",
    "    landfall         (storm, time) float32 ...\n",
    "Attributes:\n",
    "    Title:                IBTrACS-WMO: NetCDF reformat\n",
    "    Version:              v03r10\n",
    "    Description:          IBTrACS-WMO data reformatted to contain \\nall data ...\n",
    "    cdm_datatype:         Trajectory\n",
    "    trajectoryDimension:  storm\n",
    "    Conventions:          CF-1.0\n",
    "    metadata_link:        gov.noaa.ncdc:C00834\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:     (latitude: 5, longitude: 81, time: 1961)\n",
      "Coordinates:\n",
      "  * latitude    (latitude) float32 4.0 2.0 0.0 -2.0 -4.0\n",
      "  * longitude   (longitude) float32 120.0 122.0 124.0 ... 276.0 278.0 280.0\n",
      "  * time        (time) datetime64[ns] 1854-01-01 1854-02-01 ... 2017-05-01\n",
      "Data variables:\n",
      "    SST         (longitude, latitude, time) float64 ...\n",
      "    SST_runavg  (longitude, latitude, time) float64 ...\n"
     ]
    }
   ],
   "source": [
    "# SST.hist_pacific\n",
    "\n",
    "data = db.Load_SST()  \n",
    "print(data)\n",
    "\n",
    "template = '''\n",
    "<xarray.Dataset>\n",
    "Dimensions:     (latitude: 5, longitude: 81, time: 1961)\n",
    "Coordinates:\n",
    "  * latitude    (latitude) float32 4.0 2.0 0.0 -2.0 -4.0\n",
    "  * longitude   (longitude) float32 120.0 122.0 124.0 ... 276.0 278.0 280.0\n",
    "  * time        (time) datetime64[ns] 1854-01-01 1854-02-01 ... 2017-05-01\n",
    "Data variables:\n",
    "    SST         (longitude, latitude, time) float64 ...\n",
    "    SST_runavg  (longitude, latitude, time) float64 ...\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:       (direction: 24, frequency: 29, string16: 16, time: 364266)\n",
      "Coordinates:\n",
      "    station       int32 ...\n",
      "  * frequency     (frequency) float32 0.035 0.0385 ... 0.45885003 0.50473505\n",
      "  * direction     (direction) float32 82.5 67.5 52.5 37.5 ... 127.5 112.5 97.5\n",
      "  * string16      (string16) int32 -2147483647 -2147483647 ... -2147483647\n",
      "  * time          (time) datetime64[ns] 1979-01-01 ... 2020-07-01\n",
      "Data variables:\n",
      "    station_name  (time) |S64 ...\n",
      "    frequency1    (time, frequency) float32 ...\n",
      "    frequency2    (time, frequency) float32 ...\n",
      "    longitude     (time) float32 ...\n",
      "    latitude      (time) float32 ...\n",
      "    Efth          (time, frequency, direction) float32 ...\n",
      "    depth         (time) float32 ...\n",
      "    u10m          (time) float32 ...\n",
      "    udir          (time) float32 ...\n",
      "    curr          (time) float32 ...\n",
      "    currdir       (time) float32 ...\n",
      "Attributes:\n",
      "    product_name:                    ww3.197901_spec.nc\n",
      "    area:                            spectral resolution for points\n",
      "    data_type:                       OCO spectra 2D\n",
      "    format_version:                  1.1\n",
      "    southernmost_latitude:           -70.0000000°\n",
      "    northernmost_latitude:           71.5999985°\n",
      "    latitude_resolution:             n/a\n",
      "    westernmost_longitude:           -178.0000000°\n",
      "    easternmost_longitude:           350.0000000°\n",
      "    longitude_resolution:            n/a\n",
      "    minimum_altitude:                n/a\n",
      "    maximum_altitude:                n/a\n",
      "    altitude_resolution:             n/a\n",
      "    start_date:                      1979-01-01T00:00:00Z\n",
      "    stop_date:                       1979-02-01T00:00:00Z\n",
      "    field_type:                      hourly\n",
      "    date_created:                    2012-09-10T21:32:00Z\n",
      "    author:                          Durrant, Hemer, Trenham and Greenslade\n",
      "    contact:                         Mark.Hemer@csiro.au,T.Durrant@bom.gov.au\n",
      "    DOI:                             http://dx.doi.org/10.4225/08/523168703DCC5\n",
      "    related_materials:               Centre for Australian Weather and Climat...\n",
      "    creation_method:                 The hindcast was performed using the WAV...\n",
      "    license:                         Please note that the licensee is require...\n",
      "    DODS.strlen:                     16\n",
      "    DODS.dimName:                    string16\n",
      "    DODS_EXTRA.Unlimited_Dimension:  time\n"
     ]
    }
   ],
   "source": [
    "# WAVES.spectra\n",
    "\n",
    "data = db.Load_WAVES_spectra() \n",
    "print(data)\n",
    "\n",
    "template = '''\n",
    "<xarray.Dataset>\n",
    "Dimensions:       (direction: 24, frequency: 29, string16: 16, time: 364266)\n",
    "Coordinates:\n",
    "    station       int32 ...\n",
    "  * frequency     (frequency) float32 0.035 0.0385 ... 0.45885003 0.50473505\n",
    "  * direction     (direction) float32 82.5 67.5 52.5 37.5 ... 127.5 112.5 97.5\n",
    "  * string16      (string16) int32 -2147483647 -2147483647 ... -2147483647\n",
    "  * time          (time) datetime64[ns] 1979-01-01 ... 2020-07-01\n",
    "Data variables:\n",
    "    station_name  (time) |S64 ...\n",
    "    frequency1    (time, frequency) float32 ...\n",
    "    frequency2    (time, frequency) float32 ...\n",
    "    longitude     (time) float32 ...\n",
    "    latitude      (time) float32 ...\n",
    "    Efth          (time, frequency, direction) float32 ...\n",
    "    depth         (time) float32 ...\n",
    "    u10m          (time) float32 ...\n",
    "    udir          (time) float32 ...\n",
    "    curr          (time) float32 ...\n",
    "    currdir       (time) float32 ...\n",
    "Attributes:\n",
    "    product_name:                    ww3.197901_spec.nc\n",
    "    area:                            spectral resolution for points\n",
    "    data_type:                       OCO spectra 2D\n",
    "    format_version:                  1.1\n",
    "    southernmost_latitude:           -70.0000000°\n",
    "    northernmost_latitude:           71.5999985°\n",
    "    latitude_resolution:             n/a\n",
    "    westernmost_longitude:           -178.0000000°\n",
    "    easternmost_longitude:           350.0000000°\n",
    "    longitude_resolution:            n/a\n",
    "    minimum_altitude:                n/a\n",
    "    maximum_altitude:                n/a\n",
    "    altitude_resolution:             n/a\n",
    "    start_date:                      1979-01-01T00:00:00Z\n",
    "    stop_date:                       1979-02-01T00:00:00Z\n",
    "    field_type:                      hourly\n",
    "    date_created:                    2012-09-10T21:32:00Z\n",
    "    author:                          Durrant, Hemer, Trenham and Greenslade\n",
    "    contact:                         Mark.Hemer@csiro.au,T.Durrant@bom.gov.au\n",
    "    DOI:                             http://dx.doi.org/10.4225/08/523168703DCC5\n",
    "    related_materials:               Centre for Australian Weather and Climat...\n",
    "    creation_method:                 The hindcast was performed using the WAV...\n",
    "    license:                         Please note that the licensee is require...\n",
    "    DODS.strlen:                     16\n",
    "    DODS.dimName:                    string16\n",
    "    DODS_EXTRA.Unlimited_Dimension:  time\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:              (latitude: 317, longitude: 720)\n",
      "Coordinates:\n",
      "  * longitude            (longitude) float64 180.0 180.5 181.0 ... 179.0 179.5\n",
      "  * latitude             (latitude) float64 -78.0 -77.5 -77.0 ... 79.0 79.5 80.0\n",
      "Data variables:\n",
      "    mask_land            (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    mask_shadow          (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    mask_e95             (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    D_DJF                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    F_DJF                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    Fthreas_DJF          (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    D_JJA                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    F_JJA                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    Fthreas_JJA          (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    D_MAM                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    F_MAM                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    Fthreas_MAM          (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    D_SON                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    F_SON                (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    Fthreas_SON          (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    D_y1993to2012        (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    F_y1993to2012        (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "    Fthreas_y1993to2012  (latitude, longitude) float64 nan nan nan ... nan nan\n",
      "Attributes:\n",
      "    pnt_longitude:  [[167.5]]\n",
      "    pnt_latitude:   [[9.5]]\n"
     ]
    }
   ],
   "source": [
    "# ESTELA.estelamat\n",
    "\n",
    "data = db.Load_ESTELA_data()  \n",
    "print(data)\n",
    "\n",
    "template = '''\n",
    "<xarray.Dataset>\n",
    "Dimensions:              (latitude: 317, longitude: 720)\n",
    "Coordinates:\n",
    "  * longitude            (longitude) float64 180.0 180.5 181.0 ... 179.0 179.5\n",
    "  * latitude             (latitude) float64 -78.0 -77.5 -77.0 ... 79.0 79.5 80.0\n",
    "Data variables:\n",
    "    mask_land            (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    mask_shadow          (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    mask_e95             (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    D_DJF                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    F_DJF                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    Fthreas_DJF          (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    D_JJA                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    F_JJA                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    Fthreas_JJA          (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    D_MAM                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    F_MAM                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    Fthreas_MAM          (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    D_SON                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    F_SON                (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    Fthreas_SON          (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    D_y1993to2012        (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    F_y1993to2012        (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "    Fthreas_y1993to2012  (latitude, longitude) float64 nan nan nan ... nan nan\n",
    "Attributes:\n",
    "    pnt_longitude:  [[167.5]]\n",
    "    pnt_latitude:   [[9.5]]'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:    (latitude: 31, longitude: 83, time: 333120)\n",
      "Coordinates:\n",
      "  * latitude   (latitude) float32 60.5 58.5 56.5 54.5 52.5 ... 6.5 4.5 2.5 0.5\n",
      "  * longitude  (longitude) float32 115.0 117.0 119.0 121.0 ... 275.0 277.0 279.0\n",
      "  * time       (time) datetime64[ns] 1979-01-01 ... 2016-12-31T23:00:00.000013056\n",
      "Data variables:\n",
      "    SLP        (time, latitude, longitude) float64 ...\n"
     ]
    }
   ],
   "source": [
    "# ESTELA.slp\n",
    "\n",
    "data = db.Load_ESTELA_SLP()  \n",
    "print(data)\n",
    "\n",
    "template='''\n",
    "<xarray.Dataset>\n",
    "Dimensions:    (latitude: 31, longitude: 83, time: 333120)\n",
    "Coordinates:\n",
    "  * latitude   (latitude) float32 60.5 58.5 56.5 54.5 52.5 ... 6.5 4.5 2.5 0.5\n",
    "  * longitude  (longitude) float32 115.0 117.0 119.0 121.0 ... 275.0 277.0 279.0\n",
    "  * time       (time) datetime64[ns] 1979-01-01 ... 2016-12-31T23:00:00.000013056\n",
    "Data variables:\n",
    "    SLP        (time, latitude, longitude) float64 ...\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<xarray.Dataset>\n",
      "Dimensions:     (time: 342357)\n",
      "Coordinates:\n",
      "  * time        (time) datetime64[ns] 1975-12-31T12:00:00 ... 2014-02-11T12:00:00\n",
      "Data variables:\n",
      "    TIDE        (time) float64 ...\n",
      "    NTR         (time) float64 ...\n",
      "    WaterLevel  (time) float64 ...\n",
      "\n",
      "<xarray.Dataset>\n",
      "Dimensions:    (time: 184104)\n",
      "Coordinates:\n",
      "  * time       (time) datetime64[ns] 1996-01-01 ... 2016-12-31T23:00:00.000002944\n",
      "Data variables:\n",
      "    observed   (time) float64 ...\n",
      "    ntr        (time) float64 ...\n",
      "    sigma      (time) float64 ...\n",
      "    predicted  (time) float64 ...\n"
     ]
    }
   ],
   "source": [
    "# TIDE.mareografo_nc and TIDE.hist_astro \n",
    "\n",
    "data1, data2 = db.Load_TIDE_hist()\n",
    "print(data1)\n",
    "print()\n",
    "print(data2)\n",
    "\n",
    "template='''\n",
    "<xarray.Dataset>\n",
    "Dimensions:     (time: 342357)\n",
    "Coordinates:\n",
    "  * time        (time) datetime64[ns] 1975-12-31T12:00:00 ... 2014-02-11T12:00:00\n",
    "Data variables:\n",
    "    TIDE        (time) float64 ...\n",
    "    NTR         (time) float64 ...\n",
    "    WaterLevel  (time) float64 ...\n",
    "\n",
    "<xarray.Dataset>\n",
    "Dimensions:    (time: 184104)\n",
    "Coordinates:\n",
    "  * time       (time) datetime64[ns] 1996-01-01 ... 2016-12-31T23:00:00.000002944\n",
    "Data variables:\n",
    "    observed   (time) float64 ...\n",
    "    ntr        (time) float64 ...\n",
    "    sigma      (time) float64 ...\n",
    "    predicted  (time) float64 ...\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}