tools/load_demo_schema.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Simple tool to read the demo JSON data model file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Note: Requires Pandas version +1.0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Load the JSON file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loaded JSON file from local machine.\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    # first try to load the file from your computer\n",
    "    cwd = os.getcwd()\n",
    "    file_path = os.path.relpath(r'..\\demo_data\\iea43_wra_data_model.json', cwd)\n",
    "    with open(file_path) as json_file:\n",
    "        meta_data = json.load(json_file)\n",
    "    print(\"Loaded JSON file from local machine.\")\n",
    "except FileNotFoundError:\n",
    "    # If the file isn't found, load it from GitHub\n",
    "    url = \"https://raw.githubusercontent.com/IEA-Task-43/digital_wra_data_standard/master/demo_data/iea43_wra_data_model.json\"\n",
    "    resp = requests.get(url)\n",
    "    meta_data = json.loads(resp.text)\n",
    "    print(\"Loaded JSON file from GitHub.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Show high level Data Model information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Author name:\t\t\tStephen Holleran\n",
      "Author from:\t\t\tbrightwind\n",
      "Date produced:\t\t\t2021-12-23\n",
      "IEA Data Model version\t\t1.3.0-2024.03\n",
      "Plant name:\t\t\tA Name of the Wind Farm\n",
      "Plant type:\t\t\tonshore_wind\n"
     ]
    }
   ],
   "source": [
    "print('Author name:\\t\\t\\t{}'.format(meta_data['author']))\n",
    "print('Author from:\\t\\t\\t{}'.format(meta_data['organisation']))\n",
    "print('Date produced:\\t\\t\\t{}'.format(meta_data['date']))\n",
    "print('IEA Data Model version\\t\\t{}'.format(meta_data['version']))\n",
    "\n",
    "print('Plant name:\\t\\t\\t{}'.format(meta_data['plant_name']))\n",
    "print('Plant type:\\t\\t\\t{}'.format(meta_data['plant_type']))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Show all the measurement locations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UUID</th>\n",
       "      <th>Latitude [Decimal Degrees]</th>\n",
       "      <th>Longitude [Decimal Degrees]</th>\n",
       "      <th>Station Type</th>\n",
       "      <th>Notes</th>\n",
       "      <th>Last Updated</th>\n",
       "      <th>Mast Type</th>\n",
       "      <th>Mast Height</th>\n",
       "      <th>Mast OEM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Test_MM1</th>\n",
       "      <td>6858cf5c-24e0-40d4-955b-8aecbccba391</td>\n",
       "      <td>53.5</td>\n",
       "      <td>-8</td>\n",
       "      <td>mast</td>\n",
       "      <td>I can write anything I want here.</td>\n",
       "      <td>2020-04-18T18:13:00</td>\n",
       "      <td>lattice_triangle</td>\n",
       "      <td>78.5</td>\n",
       "      <td>A Mast Manufacturer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          UUID  Latitude [Decimal Degrees]  \\\n",
       "Name                                                                         \n",
       "Test_MM1  6858cf5c-24e0-40d4-955b-8aecbccba391                        53.5   \n",
       "\n",
       "          Longitude [Decimal Degrees] Station Type  \\\n",
       "Name                                                 \n",
       "Test_MM1                           -8         mast   \n",
       "\n",
       "                                      Notes         Last Updated  \\\n",
       "Name                                                               \n",
       "Test_MM1  I can write anything I want here.  2020-04-18T18:13:00   \n",
       "\n",
       "                 Mast Type  Mast Height             Mast OEM  \n",
       "Name                                                          \n",
       "Test_MM1  lattice_triangle         78.5  A Mast Manufacturer  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# print a table of the meas_locs parameters.\n",
    "meas_locs = []\n",
    "for meas_loc in meta_data['measurement_location']:\n",
    "    meas_locs.append({\n",
    "        'UUID': meas_loc['uuid'],\n",
    "        'Name': meas_loc['name'],\n",
    "        'Latitude [Decimal Degrees]': meas_loc['latitude_ddeg'],\n",
    "        'Longitude [Decimal Degrees]': meas_loc['longitude_ddeg'],\n",
    "        'Station Type': meas_loc['measurement_station_type_id'],\n",
    "        'Notes': meas_loc['notes'],\n",
    "        'Last Updated': meas_loc['update_at'],\n",
    "        'Mast Type': meas_loc['mast_properties']['mast_geometry_id'],\n",
    "        'Mast Height': meas_loc['mast_properties']['mast_height_m'],\n",
    "        'Mast OEM': meas_loc['mast_properties']['mast_oem']\n",
    "    })\n",
    "\n",
    "meas_locs_df = pd.DataFrame(meas_locs)\n",
    "meas_locs_df.set_index('Name', inplace=True)\n",
    "display(meas_locs_df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Logger main configurations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>logger_serial_number</th>\n",
       "      <th>logger_model_name</th>\n",
       "      <th>logger_id</th>\n",
       "      <th>logger_oem_id</th>\n",
       "      <th>logger_firmware_version</th>\n",
       "      <th>date_from</th>\n",
       "      <th>date_to</th>\n",
       "      <th>encryption_pin_or_key</th>\n",
       "      <th>enclosure_lock_details</th>\n",
       "      <th>data_transfer_details</th>\n",
       "      <th>offset_from_utc_hrs</th>\n",
       "      <th>sampling_rate_sec</th>\n",
       "      <th>averaging_period_minutes</th>\n",
       "      <th>timestamp_is_end_of_period</th>\n",
       "      <th>clock_is_auto_synced</th>\n",
       "      <th>logger_acquisition_uncertainty</th>\n",
       "      <th>uncertainty_k_factor</th>\n",
       "      <th>notes</th>\n",
       "      <th>update_at</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>logger_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AName_MM1</th>\n",
       "      <td>01002</td>\n",
       "      <td>Symphonie Plus3</td>\n",
       "      <td>4321</td>\n",
       "      <td>NRG Systems</td>\n",
       "      <td>3.2.3</td>\n",
       "      <td>2020-04-12T12:00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>9876</td>\n",
       "      <td>combination lock PIN 54321</td>\n",
       "      <td>Emails to data@developername.com</td>\n",
       "      <td>-5</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2</td>\n",
       "      <td>I can write anything I want here.</td>\n",
       "      <td>2020-04-18T18:13:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            logger_serial_number logger_model_name logger_id logger_oem_id  \\\n",
       "logger_name                                                                  \n",
       "AName_MM1                  01002   Symphonie Plus3      4321   NRG Systems   \n",
       "\n",
       "            logger_firmware_version            date_from date_to  \\\n",
       "logger_name                                                        \n",
       "AName_MM1                     3.2.3  2020-04-12T12:00:00    None   \n",
       "\n",
       "            encryption_pin_or_key      enclosure_lock_details  \\\n",
       "logger_name                                                     \n",
       "AName_MM1                    9876  combination lock PIN 54321   \n",
       "\n",
       "                        data_transfer_details  offset_from_utc_hrs  \\\n",
       "logger_name                                                          \n",
       "AName_MM1    Emails to data@developername.com                   -5   \n",
       "\n",
       "             sampling_rate_sec  averaging_period_minutes  \\\n",
       "logger_name                                                \n",
       "AName_MM1                    3                        10   \n",
       "\n",
       "             timestamp_is_end_of_period  clock_is_auto_synced  \\\n",
       "logger_name                                                     \n",
       "AName_MM1                         False                  True   \n",
       "\n",
       "             logger_acquisition_uncertainty  uncertainty_k_factor  \\\n",
       "logger_name                                                         \n",
       "AName_MM1                               0.1                     2   \n",
       "\n",
       "                                         notes            update_at  \n",
       "logger_name                                                          \n",
       "AName_MM1    I can write anything I want here.  2020-04-18T18:13:00  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "logger_main_config = []\n",
    "for meas_loc in meta_data['measurement_location']:\n",
    "    for log_config in meas_loc['logger_main_config']:\n",
    "        logger_main_config.append(log_config)\n",
    "\n",
    "logger_main_config_df = pd.DataFrame(logger_main_config)\n",
    "display(logger_main_config_df.set_index('logger_name'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Some functions to pull out and format the measurement points set ups."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def _flatten_sensor_dict(sensor):\n",
    "    \"\"\"\n",
    "        Flatten the sensor dictionary retrieved from jason\n",
    "        assigning all the sub-dictionaries to the main dictionary.\n",
    "\n",
    "        :param sensor: The sensor dictionary retrieved for a single configuration\n",
    "                           option and meas_point id.\n",
    "        :type sensor: dict\n",
    "        :return: output\n",
    "        :rtype: dict\n",
    "\n",
    "    \"\"\"\n",
    "    output = {key: value for key, value in sensor.items() if (type(value) != list) or (value == {})}\n",
    "    for key, value in zip(sensor.keys(), sensor.values()):\n",
    "        if (type(value) == list):\n",
    "            if key == 'calibration':\n",
    "                value = {key + \"_\" + k: v for k, v in value[0].items()}\n",
    "            output.update(value)\n",
    "    return output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def rename_variables(input_dict, root_name):\n",
    "    for var_to_rename in ['height_m', 'serial_number', 'update_at', 'notes']:\n",
    "        if var_to_rename in list(input_dict.keys()):\n",
    "            input_dict[ root_name + '_' + var_to_rename] = input_dict.pop(var_to_rename)\n",
    "    return input_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def replace_none_date(input_dict):\n",
    "    for date_str in ['date_from', 'date_to']:\n",
    "        if input_dict[date_str] is None:\n",
    "            input_dict[date_str] = '2100-12-31T00:00:00'\n",
    "    return input_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_meas_points(meas_points):\n",
    "    \n",
    "    meas_points_flatten = []\n",
    "    for meas_point in meas_points:\n",
    "#         meas_point = _flatten_meas_point_dict(meas_point)\n",
    "        log_meas_configs = sorted( meas_point['logger_measurement_config'], key=lambda i: i['date_from'])\n",
    "        log_meas_configs = [replace_none_date(rename_variables(log_meas_config, 'log_meas_config')) for log_meas_config in log_meas_configs]\n",
    "        sensors = [replace_none_date(rename_variables(_flatten_sensor_dict(sensor), 'sensor')) for sensor in meas_point['sensor']]\n",
    "        if meas_point['mounting_arrangement'] is not None:\n",
    "            mounting_arrangements = [replace_none_date(rename_variables(mntg_arrang, 'mounting_arrangement')) \n",
    "                                 for mntg_arrang in meas_point['mounting_arrangement']]\n",
    "        else:\n",
    "            mounting_arrangements = {}\n",
    "        \n",
    "        date_from = [log_meas_config['date_from'] for log_meas_config in log_meas_configs]\n",
    "        date_to = [log_meas_config['date_to'] for log_meas_config in log_meas_configs]\n",
    "        for sensor in sensors:\n",
    "            date_from.append(sensor['date_from'])\n",
    "            date_to.append(sensor['date_to'])\n",
    "        for mntg_arrang in mounting_arrangements:\n",
    "            date_from.append(mntg_arrang['date_from'])\n",
    "            date_to.append(mntg_arrang['date_to'])\n",
    "        \n",
    "        date_from.extend(date_to)\n",
    "        dates = np.unique(date_from)\n",
    "        for i in range(len(dates)-1): \n",
    "            good_log_meas_config = {}\n",
    "            for log_meas_config in log_meas_configs:\n",
    "                if (log_meas_config['date_from'] <= dates[i]) & (log_meas_config['date_to'] > dates[i]):\n",
    "                    good_log_meas_config = log_meas_config.copy()\n",
    "            if good_log_meas_config != {}:\n",
    "                for sensor in sensors: \n",
    "                    if (sensor['date_from'] <= dates[i]) & (sensor['date_to'] > dates[i]) :\n",
    "                        good_log_meas_config.update(sensor)\n",
    "                for mntg_arrang in mounting_arrangements:\n",
    "                    if (mntg_arrang['date_from'] <= dates[i]) & (mntg_arrang['date_to'] > dates[i]) :\n",
    "                        good_log_meas_config.update(mntg_arrang)\n",
    "                good_log_meas_config['date_to'] = dates[i+1]\n",
    "                good_log_meas_config['date_from'] = dates[i]\n",
    "                good_log_meas_config.update(meas_point)\n",
    "                del good_log_meas_config['logger_measurement_config']\n",
    "                del good_log_meas_config['sensor'] \n",
    "                meas_points_flatten.append(good_log_meas_config)\n",
    "    return meas_points_flatten "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def _format_sensor_table(meas_points, table_type='full'):\n",
    "    \n",
    "    if table_type == 'full':\n",
    "        header = ['name', 'measurement_units', 'oem',\n",
    "                  'height_m', 'boom_orientation_deg', 'vane_dead_band_orientation_deg',\n",
    "                  'date_from', 'date_to', 'connection_channel', 'log_meas_config_height_m', 'slope', 'offset', 'calibration_slope',\n",
    "                  'calibration_offset']\n",
    "        header_for_report = ['Instrument Name', 'Units', 'Sensor OEM',\n",
    "                        'Height [m]', 'Boom Orient. [deg, mag N]', 'Dead Band Orient. [deg, mag N]',\n",
    "                        'Date From', 'Date To', 'Logger Channel', 'Logger Stated Height [m]', 'Logger Slope', 'Logger Offset', 'Calibration Slope',\n",
    "                        'Calibration Offset']\n",
    "    elif table_type == 'meas_points':\n",
    "        header = ['name', 'measurement_type_id', 'height_m', 'boom_orientation_deg']\n",
    "        header_for_report = ['Instrument Name', 'Measurement Type', 'Height [m]', 'Boom Orient. [deg, mag N]']    \n",
    "    elif table_type == 'speed_info':\n",
    "        header = ['name', 'measurement_units', 'oem', 'model', 'sensor_serial_number',\n",
    "                  'height_m', 'boom_orientation_deg', \n",
    "                  'date_from', 'date_to', 'slope', 'offset', 'calibration_slope',\n",
    "                  'calibration_offset', 'measurement_type_id']\n",
    "        header_for_report = ['Instrument Name', 'Units', 'Sensor Make', 'Sensor Model', 'Serial No',\n",
    "                             'Height [m]', 'Boom Orient. [deg, mag N]',\n",
    "                             'Date From', 'Date To', 'Logger Slope', 'Logger Offset', 'Calibration Slope',\n",
    "                             'Calibration Offset', 'measurement_type_id']\n",
    "    elif table_type == 'direction_info':\n",
    "        header = ['name', 'measurement_units', 'oem', 'model', 'sensor_serial_number',\n",
    "                  'height_m', 'boom_orientation_deg', 'vane_dead_band_orientation_deg', \n",
    "                  'date_from', 'date_to', 'offset', 'measurement_type_id']\n",
    "        header_for_report = ['Instrument Name', 'Units', 'Sensor Make', 'Sensor Model', 'Serial No',\n",
    "                             'Height [m]', 'Boom Orient. [deg, mag N]', 'Dead Band Orient. [deg, mag N]',\n",
    "                             'Date From', 'Date To', 'Logger Offset', 'measurement_type_id']\n",
    "    \n",
    "    sensors_table_report = pd.DataFrame(meas_points)\n",
    "\n",
    "    if any(elem not in sensors_table_report.columns for elem in header):\n",
    "        ind_to_remove = [ind for ind, elem in enumerate(header) if elem not in sensors_table_report.columns]\n",
    "        del header[ind_to_remove[0]]\n",
    "        del header_for_report[ind_to_remove[0]]\n",
    "    \n",
    "    sensors_table_report = pd.DataFrame(sensors_table_report[header])\n",
    "    if table_type == 'speed_info':\n",
    "        sensors_table_report = sensors_table_report[sensors_table_report['measurement_type_id'] == 'wind_speed']\n",
    "        del sensors_table_report['measurement_type_id']\n",
    "    if table_type == 'direction_info':\n",
    "        sensors_table_report = sensors_table_report[sensors_table_report['measurement_type_id'] == 'wind_direction']\n",
    "        del sensors_table_report['measurement_type_id']\n",
    "    \n",
    "    if 'date_from' in sensors_table_report.columns:\n",
    "        sensors_table_report['date_from'] = pd.to_datetime(sensors_table_report['date_from'].values.astype(str), \n",
    "                                                           format='%Y-%m-%dT%H:%M:%S').strftime(\"%d-%b-%Y\")\n",
    "    if 'date_to' in sensors_table_report.columns:\n",
    "        sensors_table_report['date_to'] = pd.to_datetime(sensors_table_report['date_to'].values.astype(str), \n",
    "                                                         format='%Y-%m-%dT%H:%M:%S').strftime(\"%d-%b-%Y\")\n",
    "\n",
    "    sensors_table_report = sensors_table_report.replace({np.nan: '-', 'NaT': '-', '31-Dec-2100':'-'})\n",
    "    sensors_table_report.rename(columns={k: h for k, h in zip(header, header_for_report)}, inplace=True)\n",
    "    index_name = 'Instrument Name'\n",
    "    sensors_table_report = sensors_table_report.set_index(index_name)\n",
    "    \n",
    "    return sensors_table_report"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### The main measurment points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Measurement Type</th>\n",
       "      <th>Height [m]</th>\n",
       "      <th>Boom Orient. [deg, mag N]</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Instrument Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Spd_80.1_315</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>80.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80mSE</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>80.2</td>\n",
       "      <td>135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mNW</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>60.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mSE</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>60.2</td>\n",
       "      <td>135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mNW</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>40.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_30mNW</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>30.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mSE</th>\n",
       "      <td>wind_speed</td>\n",
       "      <td>40.2</td>\n",
       "      <td>135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_76mNW</th>\n",
       "      <td>wind_direction</td>\n",
       "      <td>76.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_56mNW</th>\n",
       "      <td>wind_direction</td>\n",
       "      <td>56.1</td>\n",
       "      <td>315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tmp_78m</th>\n",
       "      <td>air_temperature</td>\n",
       "      <td>78.0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tmp_5m</th>\n",
       "      <td>air_temperature</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RH_5m</th>\n",
       "      <td>relative_humidity</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prs_76m</th>\n",
       "      <td>air_pressure</td>\n",
       "      <td>76.0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Logger_V</th>\n",
       "      <td>voltage</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Measurement Type Height [m] Boom Orient. [deg, mag N]\n",
       "Instrument Name                                                        \n",
       "Spd_80.1_315            wind_speed       80.1                     315.0\n",
       "Spd_80mSE               wind_speed       80.2                     135.0\n",
       "Spd_60mNW               wind_speed       60.1                     315.0\n",
       "Spd_60mSE               wind_speed       60.2                     135.0\n",
       "Spd_40mNW               wind_speed       40.1                     315.0\n",
       "Spd_30mNW               wind_speed       30.1                     315.0\n",
       "Spd_40mSE               wind_speed       40.2                     135.0\n",
       "Dir_76mNW           wind_direction       76.1                     315.0\n",
       "Dir_56mNW           wind_direction       56.1                     315.0\n",
       "Tmp_78m            air_temperature       78.0                         -\n",
       "Tmp_5m             air_temperature        5.0                         -\n",
       "RH_5m            relative_humidity        5.0                         -\n",
       "Prs_76m               air_pressure       76.0                         -\n",
       "Logger_V                   voltage          -                         -"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for meas_loc in meta_data['measurement_location']:  \n",
    "    logger_meas_configs = get_meas_points(meas_loc['measurement_point'])\n",
    "    sensors_table = _format_sensor_table(logger_meas_configs, table_type='meas_points')\n",
    "    display(sensors_table.drop_duplicates())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### More details on each measurement point"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Sensor OEM</th>\n",
       "      <th>Height [m]</th>\n",
       "      <th>Boom Orient. [deg, mag N]</th>\n",
       "      <th>Dead Band Orient. [deg, mag N]</th>\n",
       "      <th>Date From</th>\n",
       "      <th>Date To</th>\n",
       "      <th>Logger Channel</th>\n",
       "      <th>Logger Stated Height [m]</th>\n",
       "      <th>Logger Slope</th>\n",
       "      <th>Logger Offset</th>\n",
       "      <th>Calibration Slope</th>\n",
       "      <th>Calibration Offset</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Instrument Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Spd_80.1_315</th>\n",
       "      <td>Thies</td>\n",
       "      <td>80.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>15-Apr-2020</td>\n",
       "      <td>CH1</td>\n",
       "      <td>80</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80.1_315</th>\n",
       "      <td>Thies</td>\n",
       "      <td>80.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>15-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH1</td>\n",
       "      <td>80</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2491</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>80.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>CH2</td>\n",
       "      <td>80</td>\n",
       "      <td>0.04568</td>\n",
       "      <td>0.2487</td>\n",
       "      <td>0.04568</td>\n",
       "      <td>0.2487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>80.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>-</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH2</td>\n",
       "      <td>80</td>\n",
       "      <td>0.04575</td>\n",
       "      <td>0.2497</td>\n",
       "      <td>0.04575</td>\n",
       "      <td>0.2497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>60.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH3</td>\n",
       "      <td>60</td>\n",
       "      <td>0.04666</td>\n",
       "      <td>0.2416</td>\n",
       "      <td>0.04666</td>\n",
       "      <td>0.2416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>60.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH4</td>\n",
       "      <td>60</td>\n",
       "      <td>0.04777</td>\n",
       "      <td>0.2417</td>\n",
       "      <td>0.04777</td>\n",
       "      <td>0.2417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>40.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>CH5</td>\n",
       "      <td>60</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>40.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH14</td>\n",
       "      <td>40</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_30mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>30.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>CH6</td>\n",
       "      <td>30</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>40.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>-</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH13</td>\n",
       "      <td>30</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_76mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>76.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH7</td>\n",
       "      <td>76</td>\n",
       "      <td>0.35100</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_56mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>56.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>CH8</td>\n",
       "      <td>56</td>\n",
       "      <td>0.35100</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_56mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>56.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH8</td>\n",
       "      <td>56</td>\n",
       "      <td>0.35100</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tmp_78m</th>\n",
       "      <td>NRG</td>\n",
       "      <td>78.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH9</td>\n",
       "      <td>76</td>\n",
       "      <td>0.13600</td>\n",
       "      <td>-86.383</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tmp_5m</th>\n",
       "      <td>Galltec + Mela</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH10</td>\n",
       "      <td>76</td>\n",
       "      <td>100.00000</td>\n",
       "      <td>-30.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RH_5m</th>\n",
       "      <td>Galltec + Mela</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH11</td>\n",
       "      <td>76</td>\n",
       "      <td>100.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prs_76m</th>\n",
       "      <td>NRG</td>\n",
       "      <td>76.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH12</td>\n",
       "      <td>76</td>\n",
       "      <td>0.42550</td>\n",
       "      <td>650.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Logger_V</th>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>CH15</td>\n",
       "      <td>5</td>\n",
       "      <td>0.02100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Sensor OEM Height [m] Boom Orient. [deg, mag N]  \\\n",
       "Instrument Name                                                        \n",
       "Spd_80.1_315              Thies       80.1                     315.0   \n",
       "Spd_80.1_315              Thies       80.1                     315.0   \n",
       "Spd_80mSE                 Thies       80.2                     135.0   \n",
       "Spd_80mSE                 Thies       80.2                     135.0   \n",
       "Spd_60mNW                 Thies       60.1                     315.0   \n",
       "Spd_60mSE                 Thies       60.2                     135.0   \n",
       "Spd_40mNW                 Thies       40.1                     315.0   \n",
       "Spd_40mNW                 Thies       40.1                     315.0   \n",
       "Spd_30mNW                 Thies       30.1                     315.0   \n",
       "Spd_40mSE                 Thies       40.2                     135.0   \n",
       "Dir_76mNW                   NRG       76.1                     315.0   \n",
       "Dir_56mNW                   NRG       56.1                     315.0   \n",
       "Dir_56mNW                   NRG       56.1                     315.0   \n",
       "Tmp_78m                     NRG       78.0                         -   \n",
       "Tmp_5m           Galltec + Mela        5.0                         -   \n",
       "RH_5m            Galltec + Mela        5.0                         -   \n",
       "Prs_76m                     NRG       76.0                         -   \n",
       "Logger_V                      -          -                         -   \n",
       "\n",
       "                Dead Band Orient. [deg, mag N]    Date From      Date To  \\\n",
       "Instrument Name                                                            \n",
       "Spd_80.1_315                                 -  12-Apr-2020  15-Apr-2020   \n",
       "Spd_80.1_315                                 -  15-Apr-2020            -   \n",
       "Spd_80mSE                                    -  12-Apr-2020  18-Apr-2020   \n",
       "Spd_80mSE                                    -  18-Apr-2020            -   \n",
       "Spd_60mNW                                    -  12-Apr-2020            -   \n",
       "Spd_60mSE                                    -  12-Apr-2020            -   \n",
       "Spd_40mNW                                    -  12-Apr-2020  18-Apr-2020   \n",
       "Spd_40mNW                                    -  18-Apr-2020            -   \n",
       "Spd_30mNW                                    -  12-Apr-2020  18-Apr-2020   \n",
       "Spd_40mSE                                    -  18-Apr-2020            -   \n",
       "Dir_76mNW                                315.0  12-Apr-2020            -   \n",
       "Dir_56mNW                                315.0  12-Apr-2020  18-Apr-2020   \n",
       "Dir_56mNW                                135.0  18-Apr-2020            -   \n",
       "Tmp_78m                                      -  12-Apr-2020            -   \n",
       "Tmp_5m                                       -  12-Apr-2020            -   \n",
       "RH_5m                                        -  12-Apr-2020            -   \n",
       "Prs_76m                                      -  12-Apr-2020            -   \n",
       "Logger_V                                     -  12-Apr-2020            -   \n",
       "\n",
       "                Logger Channel  Logger Stated Height [m]  Logger Slope  \\\n",
       "Instrument Name                                                          \n",
       "Spd_80.1_315               CH1                        80       0.04573   \n",
       "Spd_80.1_315               CH1                        80       0.04573   \n",
       "Spd_80mSE                  CH2                        80       0.04568   \n",
       "Spd_80mSE                  CH2                        80       0.04575   \n",
       "Spd_60mNW                  CH3                        60       0.04666   \n",
       "Spd_60mSE                  CH4                        60       0.04777   \n",
       "Spd_40mNW                  CH5                        60       0.04888   \n",
       "Spd_40mNW                 CH14                        40       0.04888   \n",
       "Spd_30mNW                  CH6                        30       0.04999   \n",
       "Spd_40mSE                 CH13                        30       0.04999   \n",
       "Dir_76mNW                  CH7                        76       0.35100   \n",
       "Dir_56mNW                  CH8                        56       0.35100   \n",
       "Dir_56mNW                  CH8                        56       0.35100   \n",
       "Tmp_78m                    CH9                        76       0.13600   \n",
       "Tmp_5m                    CH10                        76     100.00000   \n",
       "RH_5m                     CH11                        76     100.00000   \n",
       "Prs_76m                   CH12                        76       0.42550   \n",
       "Logger_V                  CH15                         5       0.02100   \n",
       "\n",
       "                Logger Offset Calibration Slope Calibration Offset  \n",
       "Instrument Name                                                     \n",
       "Spd_80.1_315           0.2419           0.04573             0.2419  \n",
       "Spd_80.1_315           0.2491           0.04573             0.2419  \n",
       "Spd_80mSE              0.2487           0.04568             0.2487  \n",
       "Spd_80mSE              0.2497           0.04575             0.2497  \n",
       "Spd_60mNW              0.2416           0.04666             0.2416  \n",
       "Spd_60mSE              0.2417           0.04777             0.2417  \n",
       "Spd_40mNW              0.2418           0.04888             0.2418  \n",
       "Spd_40mNW              0.2418           0.04888             0.2418  \n",
       "Spd_30mNW              0.2419           0.04999             0.2419  \n",
       "Spd_40mSE              0.2419           0.04999             0.2419  \n",
       "Dir_76mNW                   -                 -                  -  \n",
       "Dir_56mNW                   -                 -                  -  \n",
       "Dir_56mNW                   -                 -                  -  \n",
       "Tmp_78m               -86.383                 -                  -  \n",
       "Tmp_5m                  -30.0                 -                  -  \n",
       "RH_5m                     0.0                 -                  -  \n",
       "Prs_76m                 650.0                 -                  -  \n",
       "Logger_V                  0.0                 -                  -  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for meas_loc in meta_data['measurement_location']:\n",
    "    logger_meas_configs = get_meas_points(meas_loc['measurement_point'])\n",
    "    sensors_table = _format_sensor_table(logger_meas_configs)\n",
    "    display(sensors_table)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Anemometer (or wind speed) specific table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Sensor Make</th>\n",
       "      <th>Sensor Model</th>\n",
       "      <th>Serial No</th>\n",
       "      <th>Height [m]</th>\n",
       "      <th>Boom Orient. [deg, mag N]</th>\n",
       "      <th>Date From</th>\n",
       "      <th>Date To</th>\n",
       "      <th>Logger Slope</th>\n",
       "      <th>Logger Offset</th>\n",
       "      <th>Calibration Slope</th>\n",
       "      <th>Calibration Offset</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Instrument Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Spd_80.1_315</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183000</td>\n",
       "      <td>80.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>15-Apr-2020</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80.1_315</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183000</td>\n",
       "      <td>80.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>15-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2491</td>\n",
       "      <td>0.04573</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183001</td>\n",
       "      <td>80.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>0.04568</td>\n",
       "      <td>0.2487</td>\n",
       "      <td>0.04568</td>\n",
       "      <td>0.2487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_80mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183023</td>\n",
       "      <td>80.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04575</td>\n",
       "      <td>0.2497</td>\n",
       "      <td>0.04575</td>\n",
       "      <td>0.2497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183002</td>\n",
       "      <td>60.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04666</td>\n",
       "      <td>0.2416</td>\n",
       "      <td>0.04666</td>\n",
       "      <td>0.2416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_60mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183003</td>\n",
       "      <td>60.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04777</td>\n",
       "      <td>0.2417</td>\n",
       "      <td>0.04777</td>\n",
       "      <td>0.2417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183004</td>\n",
       "      <td>40.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183004</td>\n",
       "      <td>40.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "      <td>0.04888</td>\n",
       "      <td>0.2418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_30mNW</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183005</td>\n",
       "      <td>30.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spd_40mSE</th>\n",
       "      <td>Thies</td>\n",
       "      <td>4.3351.10.000</td>\n",
       "      <td>09183005</td>\n",
       "      <td>40.2</td>\n",
       "      <td>135.0</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "      <td>0.04999</td>\n",
       "      <td>0.2419</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Sensor Make   Sensor Model Serial No  Height [m]  \\\n",
       "Instrument Name                                                    \n",
       "Spd_80.1_315          Thies  4.3351.10.000  09183000        80.1   \n",
       "Spd_80.1_315          Thies  4.3351.10.000  09183000        80.1   \n",
       "Spd_80mSE             Thies  4.3351.10.000  09183001        80.2   \n",
       "Spd_80mSE             Thies  4.3351.10.000  09183023        80.2   \n",
       "Spd_60mNW             Thies  4.3351.10.000  09183002        60.1   \n",
       "Spd_60mSE             Thies  4.3351.10.000  09183003        60.2   \n",
       "Spd_40mNW             Thies  4.3351.10.000  09183004        40.1   \n",
       "Spd_40mNW             Thies  4.3351.10.000  09183004        40.1   \n",
       "Spd_30mNW             Thies  4.3351.10.000  09183005        30.1   \n",
       "Spd_40mSE             Thies  4.3351.10.000  09183005        40.2   \n",
       "\n",
       "                 Boom Orient. [deg, mag N]    Date From      Date To  \\\n",
       "Instrument Name                                                        \n",
       "Spd_80.1_315                         315.0  12-Apr-2020  15-Apr-2020   \n",
       "Spd_80.1_315                         315.0  15-Apr-2020            -   \n",
       "Spd_80mSE                            135.0  12-Apr-2020  18-Apr-2020   \n",
       "Spd_80mSE                            135.0  18-Apr-2020            -   \n",
       "Spd_60mNW                            315.0  12-Apr-2020            -   \n",
       "Spd_60mSE                            135.0  12-Apr-2020            -   \n",
       "Spd_40mNW                            315.0  12-Apr-2020  18-Apr-2020   \n",
       "Spd_40mNW                            315.0  18-Apr-2020            -   \n",
       "Spd_30mNW                            315.0  12-Apr-2020  18-Apr-2020   \n",
       "Spd_40mSE                            135.0  18-Apr-2020            -   \n",
       "\n",
       "                 Logger Slope  Logger Offset  Calibration Slope  \\\n",
       "Instrument Name                                                   \n",
       "Spd_80.1_315          0.04573         0.2419            0.04573   \n",
       "Spd_80.1_315          0.04573         0.2491            0.04573   \n",
       "Spd_80mSE             0.04568         0.2487            0.04568   \n",
       "Spd_80mSE             0.04575         0.2497            0.04575   \n",
       "Spd_60mNW             0.04666         0.2416            0.04666   \n",
       "Spd_60mSE             0.04777         0.2417            0.04777   \n",
       "Spd_40mNW             0.04888         0.2418            0.04888   \n",
       "Spd_40mNW             0.04888         0.2418            0.04888   \n",
       "Spd_30mNW             0.04999         0.2419            0.04999   \n",
       "Spd_40mSE             0.04999         0.2419            0.04999   \n",
       "\n",
       "                 Calibration Offset  \n",
       "Instrument Name                      \n",
       "Spd_80.1_315                 0.2419  \n",
       "Spd_80.1_315                 0.2419  \n",
       "Spd_80mSE                    0.2487  \n",
       "Spd_80mSE                    0.2497  \n",
       "Spd_60mNW                    0.2416  \n",
       "Spd_60mSE                    0.2417  \n",
       "Spd_40mNW                    0.2418  \n",
       "Spd_40mNW                    0.2418  \n",
       "Spd_30mNW                    0.2419  \n",
       "Spd_40mSE                    0.2419  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for meas_loc in meta_data['measurement_location']:    \n",
    "    sensors_table = _format_sensor_table(logger_meas_configs, table_type='speed_info')\n",
    "    display(sensors_table.drop_duplicates())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Wind Vane (or wind direction) specific table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Sensor Make</th>\n",
       "      <th>Sensor Model</th>\n",
       "      <th>Serial No</th>\n",
       "      <th>Height [m]</th>\n",
       "      <th>Boom Orient. [deg, mag N]</th>\n",
       "      <th>Dead Band Orient. [deg, mag N]</th>\n",
       "      <th>Date From</th>\n",
       "      <th>Date To</th>\n",
       "      <th>Logger Offset</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Instrument Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Dir_76mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>#200P</td>\n",
       "      <td>01234589</td>\n",
       "      <td>76.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_56mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>#200P</td>\n",
       "      <td>01234567</td>\n",
       "      <td>56.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>12-Apr-2020</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dir_56mNW</th>\n",
       "      <td>NRG</td>\n",
       "      <td>#200P</td>\n",
       "      <td>01234588</td>\n",
       "      <td>56.1</td>\n",
       "      <td>315.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>18-Apr-2020</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Sensor Make Sensor Model Serial No  Height [m]  \\\n",
       "Instrument Name                                                  \n",
       "Dir_76mNW               NRG        #200P  01234589        76.1   \n",
       "Dir_56mNW               NRG        #200P  01234567        56.1   \n",
       "Dir_56mNW               NRG        #200P  01234588        56.1   \n",
       "\n",
       "                 Boom Orient. [deg, mag N]  Dead Band Orient. [deg, mag N]  \\\n",
       "Instrument Name                                                              \n",
       "Dir_76mNW                            315.0                           315.0   \n",
       "Dir_56mNW                            315.0                           315.0   \n",
       "Dir_56mNW                            315.0                           135.0   \n",
       "\n",
       "                   Date From      Date To Logger Offset  \n",
       "Instrument Name                                          \n",
       "Dir_76mNW        12-Apr-2020            -             -  \n",
       "Dir_56mNW        12-Apr-2020  18-Apr-2020             -  \n",
       "Dir_56mNW        18-Apr-2020            -             -  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for meas_loc in meta_data['measurement_location']:    \n",
    "    sensors_table = _format_sensor_table(logger_meas_configs, table_type='direction_info')\n",
    "    display(sensors_table.drop_duplicates())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'slope': 0.04573,\n",
       "  'offset': 0.2419,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH1',\n",
       "  'logger_stated_boom_orientation_deg': 310,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2020-04-15T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH1Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1Ti30sec',\n",
       "    'statistic_type_id': 'ti30sec',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 80,\n",
       "  'log_meas_config_serial_number': '09183000',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_measurement_type_id': 'wind_speed',\n",
       "  'calibration_slope': 0.04573,\n",
       "  'calibration_offset': 0.2419,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_revision': 'A',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183000',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': None,\n",
       "  'mounting_type_id': 'goal_post',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_80.1_315',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 80.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': None,\n",
       "    'mounting_type_id': 'goal_post',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}],\n",
       "  'interference_structures': [{'structure_type_id': 'lightning_finial',\n",
       "    'orientation_from_mast_centre_deg': 45,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'distance_from_mast_centre_mm': 900,\n",
       "    'diameter_of_interference_structure_mm': 30,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': None,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}]},\n",
       " {'slope': 0.04573,\n",
       "  'offset': 0.2491,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH1',\n",
       "  'logger_stated_boom_orientation_deg': 310,\n",
       "  'date_from': '2020-04-15T00:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH1Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH1Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 80,\n",
       "  'log_meas_config_serial_number': '09183000',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_measurement_type_id': 'wind_speed',\n",
       "  'calibration_slope': 0.04573,\n",
       "  'calibration_offset': 0.2419,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_revision': 'A',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183000',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': None,\n",
       "  'mounting_type_id': 'goal_post',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_80.1_315',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 80.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': None,\n",
       "    'mounting_type_id': 'goal_post',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}],\n",
       "  'interference_structures': [{'structure_type_id': 'lightning_finial',\n",
       "    'orientation_from_mast_centre_deg': 45,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'distance_from_mast_centre_mm': 900,\n",
       "    'diameter_of_interference_structure_mm': 30,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': None,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}]},\n",
       " {'slope': 0.04568,\n",
       "  'offset': 0.2487,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH2',\n",
       "  'logger_stated_boom_orientation_deg': 135,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2020-04-18T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH2Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 80,\n",
       "  'log_meas_config_serial_number': '09183001',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_measurement_type_id': 'wind_speed',\n",
       "  'calibration_slope': 0.04568,\n",
       "  'calibration_offset': 0.2487,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_revision': 'A',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183001',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': None,\n",
       "  'mounting_type_id': 'goal_post',\n",
       "  'boom_orientation_deg': 135,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_80mSE',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 80.2,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': None,\n",
       "    'mounting_type_id': 'goal_post',\n",
       "    'boom_orientation_deg': 135,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}],\n",
       "  'interference_structures': [{'structure_type_id': 'lightning_finial',\n",
       "    'orientation_from_mast_centre_deg': 45,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'distance_from_mast_centre_mm': 900,\n",
       "    'diameter_of_interference_structure_mm': 30,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': None,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}]},\n",
       " {'slope': 0.04575,\n",
       "  'offset': 0.2497,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH2',\n",
       "  'logger_stated_boom_orientation_deg': 135,\n",
       "  'date_from': '2020-04-18T00:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH2Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH2Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 80,\n",
       "  'log_meas_config_serial_number': '09183023',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04575,\n",
       "  'calibration_offset': 0.2497,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183023',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': None,\n",
       "  'mounting_type_id': 'goal_post',\n",
       "  'boom_orientation_deg': 135,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_80mSE',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 80.2,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': None,\n",
       "    'mounting_type_id': 'goal_post',\n",
       "    'boom_orientation_deg': 135,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}],\n",
       "  'interference_structures': [{'structure_type_id': 'lightning_finial',\n",
       "    'orientation_from_mast_centre_deg': 45,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'distance_from_mast_centre_mm': 900,\n",
       "    'diameter_of_interference_structure_mm': 30,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': None,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}]},\n",
       " {'slope': 0.04666,\n",
       "  'offset': 0.2416,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH3',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH3Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH3SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH3Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH3Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 60,\n",
       "  'log_meas_config_serial_number': '09183002',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04666,\n",
       "  'calibration_offset': 0.2416,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183002',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_60mNW',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 60.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.04777,\n",
       "  'offset': 0.2417,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH4',\n",
       "  'logger_stated_boom_orientation_deg': 135,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH4Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH4SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH4Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH4Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 60,\n",
       "  'log_meas_config_serial_number': '09183003',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04777,\n",
       "  'calibration_offset': 0.2417,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183003',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 135,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_60mSE',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 60.2,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 135,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.04888,\n",
       "  'offset': 0.2418,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH5',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2020-04-18T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH5Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH5SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH5Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH5Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 60,\n",
       "  'log_meas_config_serial_number': '09183003',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04888,\n",
       "  'calibration_offset': 0.2418,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183004',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_40mNW',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 40.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.04888,\n",
       "  'offset': 0.2418,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH14',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-18T00:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH14Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH14SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH14Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH14Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 40,\n",
       "  'log_meas_config_serial_number': '09183004',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04888,\n",
       "  'calibration_offset': 0.2418,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183004',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_40mNW',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 40.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.04999,\n",
       "  'offset': 0.2419,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH6',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2020-04-18T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH6Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH6SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH6Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH6Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 30,\n",
       "  'log_meas_config_serial_number': '09183005',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04999,\n",
       "  'calibration_offset': 0.2419,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183005',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Spd_30mNW',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 30.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.04999,\n",
       "  'offset': 0.2419,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'm/s',\n",
       "  'connection_channel': 'CH13',\n",
       "  'logger_stated_boom_orientation_deg': 135,\n",
       "  'date_from': '2020-04-18T00:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH13Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH13SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH13Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH13Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 30,\n",
       "  'log_meas_config_serial_number': '09183005',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'Moved from 30 m to 40 m and connected to different channel.',\n",
       "  'oem': 'Thies',\n",
       "  'model': '4.3351.10.000',\n",
       "  'sensor_type_id': 'anemometer',\n",
       "  'classification': '1.2A',\n",
       "  'instrument_poi_height_mm': 250,\n",
       "  'is_heated': False,\n",
       "  'sensor_body_size_mm': 50,\n",
       "  'calibration_slope': 0.04999,\n",
       "  'calibration_offset': 0.2419,\n",
       "  'calibration_sensitivity': None,\n",
       "  'calibration_report_file_name': 'file name.pdf',\n",
       "  'calibration_report_link': None,\n",
       "  'calibration_date_of_calibration': '2019-12-06',\n",
       "  'calibration_calibration_organisation': 'Deutsche WindGuard',\n",
       "  'calibration_place_of_calibration': 'Windtunnel of Deutsche WindGuard WindTunnel Services GmbH, Varel',\n",
       "  'calibration_uncertainty_k_factor': 2,\n",
       "  'calibration_notes': 'I can write anything I want here.',\n",
       "  'calibration_update_at': '2020-04-18T18:13:00',\n",
       "  'calibration_calibration_uncertainty': [{'reference_bin': 4,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 5.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 7.93,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 9.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 11.9,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 13.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 15.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 14.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 12.88,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 10.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 8.91,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 6.92,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1},\n",
       "   {'reference_bin': 4.98,\n",
       "    'reference_unit': 'm/s',\n",
       "    'combined_uncertainty': 0.1}],\n",
       "  'sensor_serial_number': '09183005',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'First Class Advanced',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 135,\n",
       "  'vane_dead_band_orientation_deg': None,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#9334',\n",
       "  'upstand_height_mm': 224,\n",
       "  'upstand_diameter_mm': 25,\n",
       "  'boom_diameter_mm': 25,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'Moved from 40 to 30 and other side of mast.',\n",
       "  'name': 'Spd_40mSE',\n",
       "  'measurement_type_id': 'wind_speed',\n",
       "  'height_m': 40.2,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'Anemometer put in wrong place. Moved to 40m.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 135,\n",
       "    'vane_dead_band_orientation_deg': None,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#9334',\n",
       "    'upstand_height_mm': 224,\n",
       "    'upstand_diameter_mm': 25,\n",
       "    'boom_diameter_mm': 25,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'Moved from 40 to 30 and other side of mast.'}]},\n",
       " {'slope': 0.351,\n",
       "  'offset': None,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'deg',\n",
       "  'connection_channel': 'CH7',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH7Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH7SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH7Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH7Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 76,\n",
       "  'log_meas_config_serial_number': '01234589',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'NRG',\n",
       "  'model': '#200P',\n",
       "  'sensor_type_id': 'wind_vane',\n",
       "  'instrument_poi_height_mm': 120,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '01234589',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'I can write anything I want here.',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': 315,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#7372',\n",
       "  'upstand_height_mm': 190,\n",
       "  'upstand_diameter_mm': 20,\n",
       "  'boom_diameter_mm': 20,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Dir_76mNW',\n",
       "  'measurement_type_id': 'wind_direction',\n",
       "  'height_m': 76.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': 315,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#7372',\n",
       "    'upstand_height_mm': 190,\n",
       "    'upstand_diameter_mm': 20,\n",
       "    'boom_diameter_mm': 20,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'}]},\n",
       " {'slope': 0.351,\n",
       "  'offset': None,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'deg',\n",
       "  'connection_channel': 'CH8',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2020-04-18T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH8Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 56,\n",
       "  'log_meas_config_serial_number': '01234567',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'NRG',\n",
       "  'model': '#200P',\n",
       "  'sensor_type_id': 'wind_vane',\n",
       "  'instrument_poi_height_mm': 120,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '01234567',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'I can write anything I want here.',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': 315,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#7372',\n",
       "  'upstand_height_mm': 190,\n",
       "  'upstand_diameter_mm': 20,\n",
       "  'boom_diameter_mm': 20,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'I can write anything I want here.',\n",
       "  'name': 'Dir_56mNW',\n",
       "  'measurement_type_id': 'wind_direction',\n",
       "  'height_m': 56.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': 315,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#7372',\n",
       "    'upstand_height_mm': 190,\n",
       "    'upstand_diameter_mm': 20,\n",
       "    'boom_diameter_mm': 20,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2020-04-18T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'},\n",
       "   {'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': 135,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#7372',\n",
       "    'upstand_height_mm': 190,\n",
       "    'upstand_diameter_mm': 20,\n",
       "    'boom_diameter_mm': 20,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-18T00:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'Dead band pointing different direction to before.'}]},\n",
       " {'slope': 0.351,\n",
       "  'offset': None,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'deg',\n",
       "  'connection_channel': 'CH8',\n",
       "  'logger_stated_boom_orientation_deg': 315,\n",
       "  'date_from': '2020-04-18T00:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH8Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH8Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 56,\n",
       "  'log_meas_config_serial_number': '01234567',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'NRG',\n",
       "  'model': '#200P',\n",
       "  'sensor_type_id': 'wind_vane',\n",
       "  'instrument_poi_height_mm': 120,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '01234588',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': 'Vane replaced.',\n",
       "  'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "  'mounting_type_id': 'side',\n",
       "  'boom_orientation_deg': 315,\n",
       "  'vane_dead_band_orientation_deg': 135,\n",
       "  'orientation_reference_id': 'magnetic_north',\n",
       "  'tilt_angle_deg': 0,\n",
       "  'boom_oem': 'NRG',\n",
       "  'boom_model': '#7372',\n",
       "  'upstand_height_mm': 190,\n",
       "  'upstand_diameter_mm': 20,\n",
       "  'boom_diameter_mm': 20,\n",
       "  'boom_length_mm': 2470,\n",
       "  'distance_from_mast_to_sensor_mm': 2470,\n",
       "  'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement_notes': 'Dead band pointing different direction to before.',\n",
       "  'name': 'Dir_56mNW',\n",
       "  'measurement_type_id': 'wind_direction',\n",
       "  'height_m': 56.1,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': [{'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': 315,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#7372',\n",
       "    'upstand_height_mm': 190,\n",
       "    'upstand_diameter_mm': 20,\n",
       "    'boom_diameter_mm': 20,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-12T12:00:00',\n",
       "    'date_to': '2020-04-18T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'I can write anything I want here.'},\n",
       "   {'mast_section_geometry_uuid': 'bf078172-bbb6-48fe-ac1f-c6605dffb1b5',\n",
       "    'mounting_type_id': 'side',\n",
       "    'boom_orientation_deg': 315,\n",
       "    'vane_dead_band_orientation_deg': 135,\n",
       "    'orientation_reference_id': 'magnetic_north',\n",
       "    'tilt_angle_deg': 0,\n",
       "    'boom_oem': 'NRG',\n",
       "    'boom_model': '#7372',\n",
       "    'upstand_height_mm': 190,\n",
       "    'upstand_diameter_mm': 20,\n",
       "    'boom_diameter_mm': 20,\n",
       "    'boom_length_mm': 2470,\n",
       "    'distance_from_mast_to_sensor_mm': 2470,\n",
       "    'date_from': '2020-04-18T00:00:00',\n",
       "    'date_to': '2100-12-31T00:00:00',\n",
       "    'mounting_arrangement_update_at': '2020-04-18T18:13:00',\n",
       "    'mounting_arrangement_notes': 'Dead band pointing different direction to before.'}]},\n",
       " {'slope': 0.136,\n",
       "  'offset': -86.383,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'deg_C',\n",
       "  'connection_channel': 'CH9',\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH9Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH9SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH9Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH9Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 76,\n",
       "  'log_meas_config_serial_number': 'T012345',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'NRG',\n",
       "  'model': '#110S',\n",
       "  'sensor_type_id': 'thermometer',\n",
       "  'instrument_poi_height_mm': None,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': 'T012345',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': '',\n",
       "  'name': 'Tmp_78m',\n",
       "  'measurement_type_id': 'air_temperature',\n",
       "  'height_m': 78,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': None},\n",
       " {'slope': 100,\n",
       "  'offset': -30,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'deg_C',\n",
       "  'connection_channel': 'CH10',\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH10Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH10SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH10Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH10Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 76,\n",
       "  'log_meas_config_serial_number': '206122',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Galltec + Mela',\n",
       "  'model': 'KPC1.S/5-ME',\n",
       "  'sensor_type_id': 'thermometer',\n",
       "  'instrument_poi_height_mm': None,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '206122',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': '',\n",
       "  'name': 'Tmp_5m',\n",
       "  'measurement_type_id': 'air_temperature',\n",
       "  'height_m': 5,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': None},\n",
       " {'slope': 100,\n",
       "  'offset': 0,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': '%',\n",
       "  'connection_channel': 'CH11',\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH11Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH11SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH11Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH11Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 76,\n",
       "  'log_meas_config_serial_number': '206122',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'Galltec + Mela',\n",
       "  'model': 'KPC1.S/5-ME',\n",
       "  'sensor_type_id': 'hygrometer',\n",
       "  'instrument_poi_height_mm': None,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '206122',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': '',\n",
       "  'name': 'RH_5m',\n",
       "  'measurement_type_id': 'relative_humidity',\n",
       "  'height_m': 5,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': None},\n",
       " {'slope': 0.4255,\n",
       "  'offset': 650,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'mbar',\n",
       "  'connection_channel': 'CH12',\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH12Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH12SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH12Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH12Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 76,\n",
       "  'log_meas_config_serial_number': '180537427',\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': 'NRG',\n",
       "  'model': 'BP20',\n",
       "  'sensor_type_id': 'barometer',\n",
       "  'instrument_poi_height_mm': None,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': '180537427',\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': '',\n",
       "  'name': 'Prs_76m',\n",
       "  'measurement_type_id': 'air_pressure',\n",
       "  'height_m': 76,\n",
       "  'height_reference_id': 'ground_level',\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': None},\n",
       " {'slope': 0.021,\n",
       "  'offset': 0,\n",
       "  'sensitivity': None,\n",
       "  'measurement_units_id': 'V',\n",
       "  'connection_channel': 'CH15',\n",
       "  'date_from': '2020-04-12T12:00:00',\n",
       "  'date_to': '2100-12-31T00:00:00',\n",
       "  'column_name': [{'column_name': 'CH15Avg',\n",
       "    'statistic_type_id': 'avg',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH15SD',\n",
       "    'statistic_type_id': 'sd',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH15Min',\n",
       "    'statistic_type_id': 'min',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'},\n",
       "   {'column_name': 'CH15Max',\n",
       "    'statistic_type_id': 'max',\n",
       "    'is_ignored': False,\n",
       "    'notes': 'I can write anything I want here.',\n",
       "    'update_at': '2020-04-18T18:13:00'}],\n",
       "  'log_meas_config_height_m': 5,\n",
       "  'log_meas_config_serial_number': None,\n",
       "  'log_meas_config_update_at': '2020-04-18T18:13:00',\n",
       "  'log_meas_config_notes': 'I can write anything I want here.',\n",
       "  'oem': None,\n",
       "  'model': None,\n",
       "  'sensor_type_id': 'voltmeter',\n",
       "  'instrument_poi_height_mm': None,\n",
       "  'is_heated': False,\n",
       "  'calibration': None,\n",
       "  'sensor_serial_number': None,\n",
       "  'sensor_update_at': '2020-04-18T18:13:00',\n",
       "  'sensor_notes': '',\n",
       "  'name': 'Logger_V',\n",
       "  'measurement_type_id': 'voltage',\n",
       "  'height_m': None,\n",
       "  'height_reference_id': None,\n",
       "  'notes': 'I can write anything I want here.',\n",
       "  'update_at': '2020-04-18T18:13:00',\n",
       "  'mounting_arrangement': None}]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "logger_meas_configs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}