Parse parquet.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5af63f76",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "import requests\n",
    "import shutil\n",
    "import folium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "761e55bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ccefa7cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.display import display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ea6544a1",
   "metadata": {},
   "outputs": [],
   "source": [
    "SCRIPT_DIR = Path('.').resolve()\n",
    "INPUT_DIR = SCRIPT_DIR / 'input'\n",
    "OUTPUT_DIR = SCRIPT_DIR / 'output'\n",
    "OUTPUT_DIR.mkdir(exist_ok=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a9215b30",
   "metadata": {},
   "outputs": [],
   "source": [
    "INPUT_FILE = INPUT_DIR / 'wuerzburg_trees.parquet'\n",
    "INPUT_URL = \"https://opendata.wuerzburg.de/api/explore/v2.1/catalog/datasets/sls-klimabaeume/exports/parquet?lang=en&timezone=Europe%2FBerlin\"\n",
    "USER_AGENT = {'User-agent': 'Mozilla/5.0'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "763799d4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "C:\\Users\\eric.duminil\\git\\circulargreensimcity\\python_scripts\\parse_wurzburg_open_data\\input\\wuerzburg_trees.parquet already here.\n"
     ]
    }
   ],
   "source": [
    "def download_file(download_url, download_path):\n",
    "    with requests.get(download_url, stream=True, headers=USER_AGENT) as r:\n",
    "        with open(download_path, 'wb') as f:\n",
    "            shutil.copyfileobj(r.raw, f)\n",
    "\n",
    "\n",
    "if INPUT_FILE.exists() and INPUT_FILE.stat().st_size > 0:\n",
    "    print(f\"{INPUT_FILE} already here.\")\n",
    "else:\n",
    "    print(f\"Downloading {INPUT_URL}\")\n",
    "    download_file(INPUT_URL, INPUT_FILE)\n",
    "    print(\"  Done\")\n",
    "\n",
    "df = pd.read_parquet(INPUT_FILE, engine='fastparquet')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c8c647de",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_parquet('input/wuerzburg_trees.parquet', engine='fastparquet')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8ce189f0",
   "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>species_german</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>soil_composition</th>\n",
       "      <th>vol_water_content_30</th>\n",
       "      <th>vol_water_content_100</th>\n",
       "      <th>permittivity_30</th>\n",
       "      <th>permittivity_100</th>\n",
       "      <th>conductivity_30</th>\n",
       "      <th>conductivity_100</th>\n",
       "      <th>usable_field_capacity_30</th>\n",
       "      <th>usable_field_capacity_100</th>\n",
       "      <th>temperature_30</th>\n",
       "      <th>temperature_100</th>\n",
       "      <th>battery_percentage</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>koordinaten</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23631</td>\n",
       "      <td>Tilia Cordata Greenspire</td>\n",
       "      <td>Stadt-Linde</td>\n",
       "      <td>49.793440</td>\n",
       "      <td>9.940730</td>\n",
       "      <td>Boden Ringpark</td>\n",
       "      <td>37.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>22.34</td>\n",
       "      <td>15.17</td>\n",
       "      <td>19.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>117.647059</td>\n",
       "      <td>58.823529</td>\n",
       "      <td>25.06</td>\n",
       "      <td>23.19</td>\n",
       "      <td>59.0</td>\n",
       "      <td>2023-07-12 10:18:26</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00o\\xbb\\xd0\\\\\\xa7\\xe1#@K\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5463.1</td>\n",
       "      <td>Ulmus New Horizon</td>\n",
       "      <td>Ulme New Horizon</td>\n",
       "      <td>49.796000</td>\n",
       "      <td>9.932720</td>\n",
       "      <td>Eigensubstrat Gartenamt</td>\n",
       "      <td>45.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.84</td>\n",
       "      <td>18.86</td>\n",
       "      <td>20.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>176.190476</td>\n",
       "      <td>119.047619</td>\n",
       "      <td>25.26</td>\n",
       "      <td>25.12</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2023-07-12 10:04:33</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00v\\xa6\\xd0y\\x8d\\xdd#@\\xd9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>58413</td>\n",
       "      <td>Ulmus New Horizon</td>\n",
       "      <td>Ulme New Horizon</td>\n",
       "      <td>49.796580</td>\n",
       "      <td>9.941690</td>\n",
       "      <td>Boden-Sand-Lehm 4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>11.81</td>\n",
       "      <td>20.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.1</td>\n",
       "      <td>55.555556</td>\n",
       "      <td>122.222222</td>\n",
       "      <td>26.51</td>\n",
       "      <td>24.40</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2023-07-12 10:57:41</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\xc3\\xf0\\x111%\\xe2#@\\xe7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>58753</td>\n",
       "      <td>Acer Platanoides</td>\n",
       "      <td>Spitz-Ahorn</td>\n",
       "      <td>49.782000</td>\n",
       "      <td>9.956770</td>\n",
       "      <td>VulkaTree</td>\n",
       "      <td>44.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>30.32</td>\n",
       "      <td>17.33</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>139.130435</td>\n",
       "      <td>82.608696</td>\n",
       "      <td>24.94</td>\n",
       "      <td>19.20</td>\n",
       "      <td>59.0</td>\n",
       "      <td>2023-07-12 10:47:32</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00}\\x96\\xe7\\xc1\\xdd\\xe9#@j...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5540</td>\n",
       "      <td>Tilia Cordata Greenspire</td>\n",
       "      <td>Stadt-Linde</td>\n",
       "      <td>49.793180</td>\n",
       "      <td>9.933190</td>\n",
       "      <td>Boden-Sand-Lehm 4</td>\n",
       "      <td>35.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>20.65</td>\n",
       "      <td>21.61</td>\n",
       "      <td>19.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>127.777778</td>\n",
       "      <td>133.333333</td>\n",
       "      <td>23.13</td>\n",
       "      <td>19.85</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2023-07-12 10:06:59</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\x92\\xe8e\\x14\\xcb\\xdd#@\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158720</th>\n",
       "      <td>05_Ersatz_3_7023.2</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>49.791642</td>\n",
       "      <td>9.935594</td>\n",
       "      <td>VulkaTree</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137.837838</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2024-07-22 10:23:46</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\x96j*&lt;\\x06\\xdf#@.\\xd3\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158721</th>\n",
       "      <td>5463.1</td>\n",
       "      <td>Ulmus New Horizon</td>\n",
       "      <td>Ulme New Horizon</td>\n",
       "      <td>49.796000</td>\n",
       "      <td>9.932720</td>\n",
       "      <td>Eigensubstrat Gartenamt</td>\n",
       "      <td>36.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>22.05</td>\n",
       "      <td>19.29</td>\n",
       "      <td>19.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90.322581</td>\n",
       "      <td>80.645161</td>\n",
       "      <td>23.42</td>\n",
       "      <td>21.82</td>\n",
       "      <td>29.0</td>\n",
       "      <td>2024-07-22 11:25:45</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00v\\xa6\\xd0y\\x8d\\xdd#@\\xd9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158722</th>\n",
       "      <td>05_Ersatz_3_7023.2</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>49.791642</td>\n",
       "      <td>9.935594</td>\n",
       "      <td>VulkaTree</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137.837838</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2024-07-22 11:24:16</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\x96j*&lt;\\x06\\xdf#@.\\xd3\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158723</th>\n",
       "      <td>Gartenamt_Kontroll_2</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>Unbekannt</td>\n",
       "      <td>49.797012</td>\n",
       "      <td>10.001281</td>\n",
       "      <td>Eigensubstrat Gartenamt</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-25.806452</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.0</td>\n",
       "      <td>2024-07-22 11:35:41</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\x01\\x00\\x00\\xf8\\xa7\\x00...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158724</th>\n",
       "      <td>65851</td>\n",
       "      <td>Fraxinus Angustifolia Raywood</td>\n",
       "      <td>Esche Raywood</td>\n",
       "      <td>49.791200</td>\n",
       "      <td>9.927240</td>\n",
       "      <td>VulkaTree</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>37.43</td>\n",
       "      <td>22.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.8</td>\n",
       "      <td>110.810811</td>\n",
       "      <td>78.378378</td>\n",
       "      <td>25.76</td>\n",
       "      <td>21.08</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2024-07-22 11:35:44</td>\n",
       "      <td>b'\\x01\\x01\\x00\\x00\\x00\\t\\x16\\x873\\xbf\\xda#@0L\\...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158725 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 tree_number                  species_latin    species_german  \\\n",
       "0                      23631       Tilia Cordata Greenspire       Stadt-Linde   \n",
       "1                     5463.1              Ulmus New Horizon  Ulme New Horizon   \n",
       "2                      58413              Ulmus New Horizon  Ulme New Horizon   \n",
       "3                      58753               Acer Platanoides       Spitz-Ahorn   \n",
       "4                       5540       Tilia Cordata Greenspire       Stadt-Linde   \n",
       "...                      ...                            ...               ...   \n",
       "158720    05_Ersatz_3_7023.2                      Unbekannt         Unbekannt   \n",
       "158721                5463.1              Ulmus New Horizon  Ulme New Horizon   \n",
       "158722    05_Ersatz_3_7023.2                      Unbekannt         Unbekannt   \n",
       "158723  Gartenamt_Kontroll_2                      Unbekannt         Unbekannt   \n",
       "158724                 65851  Fraxinus Angustifolia Raywood     Esche Raywood   \n",
       "\n",
       "         latitude  longitude         soil_composition  vol_water_content_30  \\\n",
       "0       49.793440   9.940730           Boden Ringpark                  37.0   \n",
       "1       49.796000   9.932720  Eigensubstrat Gartenamt                  45.0   \n",
       "2       49.796580   9.941690        Boden-Sand-Lehm 4                  22.0   \n",
       "3       49.782000   9.956770                VulkaTree                  44.0   \n",
       "4       49.793180   9.933190        Boden-Sand-Lehm 4                  35.0   \n",
       "...           ...        ...                      ...                   ...   \n",
       "158720  49.791642   9.935594                VulkaTree                  59.0   \n",
       "158721  49.796000   9.932720  Eigensubstrat Gartenamt                  36.0   \n",
       "158722  49.791642   9.935594                VulkaTree                  59.0   \n",
       "158723  49.797012  10.001281  Eigensubstrat Gartenamt                   0.0   \n",
       "158724  49.791200   9.927240                VulkaTree                  49.0   \n",
       "\n",
       "        vol_water_content_100  permittivity_30  permittivity_100  \\\n",
       "0                        27.0            22.34             15.17   \n",
       "1                        33.0            30.84             18.86   \n",
       "2                        34.0            11.81             20.14   \n",
       "3                        31.0            30.32             17.33   \n",
       "4                        36.0            20.65             21.61   \n",
       "...                       ...              ...               ...   \n",
       "158720                    NaN            53.11               NaN   \n",
       "158721                   33.0            22.05             19.29   \n",
       "158722                    NaN            53.06               NaN   \n",
       "158723                    NaN             0.00               NaN   \n",
       "158724                   37.0            37.43             22.84   \n",
       "\n",
       "        conductivity_30  conductivity_100  usable_field_capacity_30  \\\n",
       "0                  19.3              21.8                117.647059   \n",
       "1                  20.9               0.0                176.190476   \n",
       "2                   0.0              19.1                 55.555556   \n",
       "3                   0.0               0.0                139.130435   \n",
       "4                  19.2               0.0                127.777778   \n",
       "...                 ...               ...                       ...   \n",
       "158720             38.1               NaN                137.837838   \n",
       "158721             19.5               0.0                 90.322581   \n",
       "158722             38.2               NaN                137.837838   \n",
       "158723              0.0               NaN                -25.806452   \n",
       "158724              0.0              19.8                110.810811   \n",
       "\n",
       "        usable_field_capacity_100  temperature_30  temperature_100  \\\n",
       "0                       58.823529           25.06            23.19   \n",
       "1                      119.047619           25.26            25.12   \n",
       "2                      122.222222           26.51            24.40   \n",
       "3                       82.608696           24.94            19.20   \n",
       "4                      133.333333           23.13            19.85   \n",
       "...                           ...             ...              ...   \n",
       "158720                        NaN           24.10              NaN   \n",
       "158721                  80.645161           23.42            21.82   \n",
       "158722                        NaN           24.10              NaN   \n",
       "158723                        NaN            0.00              NaN   \n",
       "158724                  78.378378           25.76            21.08   \n",
       "\n",
       "        battery_percentage           timestamp  \\\n",
       "0                     59.0 2023-07-12 10:18:26   \n",
       "1                     56.0 2023-07-12 10:04:33   \n",
       "2                     58.0 2023-07-12 10:57:41   \n",
       "3                     59.0 2023-07-12 10:47:32   \n",
       "4                     60.0 2023-07-12 10:06:59   \n",
       "...                    ...                 ...   \n",
       "158720                57.0 2024-07-22 10:23:46   \n",
       "158721                29.0 2024-07-22 11:25:45   \n",
       "158722                57.0 2024-07-22 11:24:16   \n",
       "158723                77.0 2024-07-22 11:35:41   \n",
       "158724                31.0 2024-07-22 11:35:44   \n",
       "\n",
       "                                              koordinaten  \n",
       "0       b'\\x01\\x01\\x00\\x00\\x00o\\xbb\\xd0\\\\\\xa7\\xe1#@K\\x...  \n",
       "1       b'\\x01\\x01\\x00\\x00\\x00v\\xa6\\xd0y\\x8d\\xdd#@\\xd9...  \n",
       "2       b'\\x01\\x01\\x00\\x00\\x00\\xc3\\xf0\\x111%\\xe2#@\\xe7...  \n",
       "3       b'\\x01\\x01\\x00\\x00\\x00}\\x96\\xe7\\xc1\\xdd\\xe9#@j...  \n",
       "4       b'\\x01\\x01\\x00\\x00\\x00\\x92\\xe8e\\x14\\xcb\\xdd#@\\...  \n",
       "...                                                   ...  \n",
       "158720  b'\\x01\\x01\\x00\\x00\\x00\\x96j*<\\x06\\xdf#@.\\xd3\\x...  \n",
       "158721  b'\\x01\\x01\\x00\\x00\\x00v\\xa6\\xd0y\\x8d\\xdd#@\\xd9...  \n",
       "158722  b'\\x01\\x01\\x00\\x00\\x00\\x96j*<\\x06\\xdf#@.\\xd3\\x...  \n",
       "158723  b'\\x01\\x01\\x00\\x00\\x00\\x01\\x00\\x00\\xf8\\xa7\\x00...  \n",
       "158724  b'\\x01\\x01\\x00\\x00\\x00\\t\\x16\\x873\\xbf\\xda#@0L\\...  \n",
       "\n",
       "[158725 rows x 19 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "57133341",
   "metadata": {},
   "outputs": [],
   "source": [
    "interesting_columns = ['tree_number', 'species_latin', 'latitude', 'longitude']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "4850e91c",
   "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>58753</td>\n",
       "      <td>Acer Platanoides</td>\n",
       "      <td>49.782000</td>\n",
       "      <td>9.956770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>06_Ersatz_01_58753</td>\n",
       "      <td>Acer Platanoides</td>\n",
       "      <td>49.781994</td>\n",
       "      <td>9.959306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10702</th>\n",
       "      <td>06_Ersatz_01_58753</td>\n",
       "      <td>Acer Platanoides</td>\n",
       "      <td>49.781994</td>\n",
       "      <td>9.959306</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              tree_number     species_latin   latitude  longitude\n",
       "3                   58753  Acer Platanoides  49.782000   9.956770\n",
       "425    06_Ersatz_01_58753  Acer Platanoides  49.781994   9.959306\n",
       "10702  06_Ersatz_01_58753  Acer Platanoides  49.781994   9.959306"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>65851</td>\n",
       "      <td>Fraxinus Angustifolia Raywood</td>\n",
       "      <td>49.7912</td>\n",
       "      <td>9.92724</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tree_number                  species_latin  latitude  longitude\n",
       "7       65851  Fraxinus Angustifolia Raywood   49.7912    9.92724"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28816</th>\n",
       "      <td>54838</td>\n",
       "      <td>Fraxinus Ornus</td>\n",
       "      <td>49.77794</td>\n",
       "      <td>9.93879</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tree_number   species_latin  latitude  longitude\n",
       "28816       54838  Fraxinus Ornus  49.77794    9.93879"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11925</th>\n",
       "      <td>8971.1</td>\n",
       "      <td>Gleditsia Triacanthos Inermis</td>\n",
       "      <td>49.79037</td>\n",
       "      <td>9.92953</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tree_number                  species_latin  latitude  longitude\n",
       "11925      8971.1  Gleditsia Triacanthos Inermis  49.79037    9.92953"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>36312</td>\n",
       "      <td>Robinia Pseudoacacia</td>\n",
       "      <td>49.7913</td>\n",
       "      <td>9.96101</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tree_number         species_latin  latitude  longitude\n",
       "9       36312  Robinia Pseudoacacia   49.7913    9.96101"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>54976</td>\n",
       "      <td>Sophora Japonica</td>\n",
       "      <td>49.78955</td>\n",
       "      <td>9.93318</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tree_number     species_latin  latitude  longitude\n",
       "5       54976  Sophora Japonica  49.78955    9.93318"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23631</td>\n",
       "      <td>Tilia Cordata Greenspire</td>\n",
       "      <td>49.79344</td>\n",
       "      <td>9.94073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5540</td>\n",
       "      <td>Tilia Cordata Greenspire</td>\n",
       "      <td>49.79318</td>\n",
       "      <td>9.93319</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tree_number             species_latin  latitude  longitude\n",
       "0       23631  Tilia Cordata Greenspire  49.79344    9.94073\n",
       "4        5540  Tilia Cordata Greenspire  49.79318    9.93319"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>58762</td>\n",
       "      <td>Tilia Tomentosa Brabant</td>\n",
       "      <td>49.78558</td>\n",
       "      <td>9.959380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>01_Ersatz_2_58762</td>\n",
       "      <td>Tilia Tomentosa Brabant</td>\n",
       "      <td>49.78550</td>\n",
       "      <td>9.959306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10455</th>\n",
       "      <td>01_Ersatz_2_58762</td>\n",
       "      <td>Tilia Tomentosa Brabant</td>\n",
       "      <td>49.78550</td>\n",
       "      <td>9.959306</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             tree_number            species_latin  latitude  longitude\n",
       "30                 58762  Tilia Tomentosa Brabant  49.78558   9.959380\n",
       "424    01_Ersatz_2_58762  Tilia Tomentosa Brabant  49.78550   9.959306\n",
       "10455  01_Ersatz_2_58762  Tilia Tomentosa Brabant  49.78550   9.959306"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>tree_number</th>\n",
       "      <th>species_latin</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5445</td>\n",
       "      <td>Tilia Vulgaris Pallida</td>\n",
       "      <td>49.79619</td>\n",
       "      <td>9.93103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9075</th>\n",
       "      <td>42374</td>\n",
       "      <td>Tilia Vulgaris Pallida</td>\n",
       "      <td>49.79761</td>\n",
       "      <td>9.93270</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     tree_number           species_latin  latitude  longitude\n",
       "8           5445  Tilia Vulgaris Pallida  49.79619    9.93103\n",
       "9075       42374  Tilia Vulgaris Pallida  49.79761    9.93270"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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",