interactive_map.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "94a41a10",
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import pandas as pd\n",
    "import geopandas as gpd\n",
    "from shapely.geometry import Point"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "285cc2c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "my_map = folium.Map()\n",
    "my_map.save('test.html')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3e4a9971",
   "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>Name</th>\n",
       "      <th>Type</th>\n",
       "      <th>Inhabitant</th>\n",
       "      <th>English</th>\n",
       "      <th>Westron</th>\n",
       "      <th>Quenya</th>\n",
       "      <th>Sindarin</th>\n",
       "      <th>Khuzdul</th>\n",
       "      <th>Rohirric</th>\n",
       "      <th>Other</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Field of Celebrant</td>\n",
       "      <td>Field</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Field of Celebrant; Field of \"Silverlode\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[field of] Celebrant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.727657e+05</td>\n",
       "      <td>2.598167e+09</td>\n",
       "      <td>48.686831</td>\n",
       "      <td>6.712481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Firienfeld</td>\n",
       "      <td>Flat upland</td>\n",
       "      <td>Rohirrim</td>\n",
       "      <td>Dunharrow</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Firienfeld</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.367542e+03</td>\n",
       "      <td>1.376384e+06</td>\n",
       "      <td>45.530912</td>\n",
       "      <td>4.431309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Plateau of Gorgoroth</td>\n",
       "      <td>Plain</td>\n",
       "      <td>Sauron, Orcs, Men allied to Sauron</td>\n",
       "      <td>Plateau of \"horror/dread\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[plateau of] Gorgoroth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.635612e+06</td>\n",
       "      <td>3.640515e+10</td>\n",
       "      <td>43.736524</td>\n",
       "      <td>12.934796</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name         Type                          Inhabitant  \\\n",
       "0    Field of Celebrant        Field                                 NaN   \n",
       "1            Firienfeld  Flat upland                            Rohirrim   \n",
       "2  Plateau of Gorgoroth        Plain  Sauron, Orcs, Men allied to Sauron   \n",
       "\n",
       "                                     English Westron Quenya  \\\n",
       "0  Field of Celebrant; Field of \"Silverlode\"     NaN    NaN   \n",
       "1                                  Dunharrow     NaN    NaN   \n",
       "2                  Plateau of \"horror/dread\"     NaN    NaN   \n",
       "\n",
       "                 Sindarin Khuzdul    Rohirric Other    SHAPE_Leng  \\\n",
       "0    [field of] Celebrant     NaN         NaN   NaN  3.727657e+05   \n",
       "1                     NaN     NaN  Firienfeld   NaN  4.367542e+03   \n",
       "2  [plateau of] Gorgoroth     NaN         NaN   NaN  5.635612e+06   \n",
       "\n",
       "     SHAPE_Area          x          y  \n",
       "0  2.598167e+09  48.686831   6.712481  \n",
       "1  1.376384e+06  45.530912   4.431309  \n",
       "2  3.640515e+10  43.736524  12.934796  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "poi = pd.read_csv('final_geo_data/csv/poi_wgs84_xy_cleared.csv')\n",
    "poi.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0b29bb9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "folium.Marker(\n",
    "    location=[49.4945077089,8.1286725884]\n",
    ").add_to(my_map)\n",
    "my_map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2f0e9e49",
   "metadata": {},
   "outputs": [],
   "source": [
    "test_poi = pd.read_excel('final_geo_data/csv/obvious_poi.xlsx')\n",
    "\n",
    "df_ov_test_poi = test_poi.iloc[:, 0:10]\n",
    "\n",
    "df_ov_test_poi.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2b512f22",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(df_ov_test_poi)):\n",
    "    folium.Marker(\n",
    "        location=[df_ov_test_poi.loc[i,'x'],df_ov_test_poi.loc[i,'y']],\n",
    "        popup='album: ' + df_ov_test_poi.loc[i,'album'],\n",
    "        tooltip='location: ' + df_ov_test_poi.loc[i,'referred_place']\n",
    "    ).add_to(my_map)\n",
    "\n",
    "my_map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "cdb4b8a8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
       "&lt;head&gt;    \n",
       "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
       "    \n",
       "        &lt;script&gt;\n",
       "            L_NO_TOUCH = false;\n",
       "            L_DISABLE_3D = false;\n",
       "        &lt;/script&gt;\n",
       "    \n",
       "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
       "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
       "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
       "    \n",
       "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
       "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
       "            &lt;style&gt;\n",
       "                #map_1797aab526bdf5c9236b9965b701fffd {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "    \n",
       "                    &lt;style&gt;\n",
       "                        .foliumtooltip {\n",
       "                            \n",
       "                        }\n",
       "                       .foliumtooltip table{\n",
       "                            margin: auto;\n",
       "                        }\n",
       "                        .foliumtooltip tr{\n",
       "                            text-align: left;\n",
       "                        }\n",
       "                        .foliumtooltip th{\n",
       "                            padding: 2px; padding-right: 8px;\n",
       "                        }\n",
       "                    &lt;/style&gt;\n",
       "            \n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_1797aab526bdf5c9236b9965b701fffd&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;    \n",
       "    \n",
       "            var map_1797aab526bdf5c9236b9965b701fffd = L.map(\n",
       "                &quot;map_1797aab526bdf5c9236b9965b701fffd&quot;,\n",
       "                {\n",
       "                    center: [47.88054701585, 5.15102710925],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 10,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "            L.control.scale().addTo(map_1797aab526bdf5c9236b9965b701fffd);\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_95a9afa8f9e41ade361db726f6a638bc = L.tileLayer(\n",
       "                &quot;https://stamen-tiles-a.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.jpg&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Map tiles by \\u003ca href=\\&quot;http://stamen.com\\&quot;\\u003eStamen Design\\u003c/a\\u003e, \\u003ca href=\\&quot;http://creativecommons.org/licenses/by/3.0\\&quot;\\u003eCC BY 3.0\\u003c/a\\u003e \\u0026mdash; Map data \\u0026copy; \\u003ca href=\\&quot;https://www.openstreetmap.org/copyright\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e contributors&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 16, &quot;maxZoom&quot;: 16, &quot;minZoom&quot;: 1, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
       "            ).addTo(map_1797aab526bdf5c9236b9965b701fffd);\n",
       "        \n",
       "    \n",
       "            map_1797aab526bdf5c9236b9965b701fffd.fitBounds(\n",
       "                [[42.7715974269, -0.4898657755], [52.9894966048, 10.791919994]],\n",
       "                {}\n",
       "            );\n",
       "        \n",
       "    \n",
       "        function geo_json_bf2a7eaca04093b4bf468624e0cec2e9_styler(feature) {\n",
       "            switch(feature.id) {\n",
       "                default:\n",
       "                    return {&quot;fillOpacity&quot;: 0.5, &quot;weight&quot;: 2};\n",
       "            }\n",
       "        }\n",
       "        function geo_json_bf2a7eaca04093b4bf468624e0cec2e9_highlighter(feature) {\n",
       "            switch(feature.id) {\n",
       "                default:\n",
       "                    return {&quot;fillOpacity&quot;: 0.3};\n",
       "            }\n",
       "        }\n",
       "        function geo_json_bf2a7eaca04093b4bf468624e0cec2e9_pointToLayer(feature, latlng) {\n",
       "            var opts = {};\n",
       "            \n",
       "            let style = geo_json_bf2a7eaca04093b4bf468624e0cec2e9_styler(feature)\n",
       "            Object.assign(opts, style)\n",
       "            \n",
       "            return new L.Marker(latlng, opts)\n",
       "        }\n",
       "\n",
       "        function geo_json_bf2a7eaca04093b4bf468624e0cec2e9_onEachFeature(feature, layer) {\n",
       "            layer.on({\n",
       "                mouseout: function(e) {\n",
       "                    if(typeof e.target.setStyle === &quot;function&quot;){\n",
       "                        geo_json_bf2a7eaca04093b4bf468624e0cec2e9.resetStyle(e.target);\n",
       "                    }\n",
       "                },\n",
       "                mouseover: function(e) {\n",
       "                    if(typeof e.target.setStyle === &quot;function&quot;){\n",
       "                        const highlightStyle = geo_json_bf2a7eaca04093b4bf468624e0cec2e9_highlighter(e.target.feature)\n",
       "                        e.target.setStyle(highlightStyle);\n",
       "                    }\n",
       "                },\n",
       "            });\n",
       "        };\n",
       "        var geo_json_bf2a7eaca04093b4bf468624e0cec2e9 = L.geoJson(null, {\n",
       "                onEachFeature: geo_json_bf2a7eaca04093b4bf468624e0cec2e9_onEachFeature,\n",
       "            \n",
       "                style: geo_json_bf2a7eaca04093b4bf468624e0cec2e9_styler,\n",
       "                pointToLayer: geo_json_bf2a7eaca04093b4bf468624e0cec2e9_pointToLayer\n",
       "        });\n",
       "\n",
       "        function geo_json_bf2a7eaca04093b4bf468624e0cec2e9_add (data) {\n",
       "            geo_json_bf2a7eaca04093b4bf468624e0cec2e9\n",
       "                .addData(data)\n",
       "                .addTo(map_1797aab526bdf5c9236b9965b701fffd);\n",
       "        }\n",
       "            geo_json_bf2a7eaca04093b4bf468624e0cec2e9_add({&quot;bbox&quot;: [-0.4898657755, 42.7715974269, 10.791919994, 52.9894966048], &quot;features&quot;: [{&quot;bbox&quot;: [8.1286726, 49.4945077, 8.1286726, 49.4945077], &quot;geometry&quot;: {&quot;coordinates&quot;: [8.1286726, 49.4945077], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;0&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Lugburz&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Southern Mirkwood&quot;, &quot;other name&quot;: &quot;Hill of Dark Sorcery, Amon Lanc, the dungeons of the Necromancer&quot;, &quot;referred_place&quot;: &quot;Dol Guldur&quot;, &quot;related lyrics&quot;: &quot;Nazgul&quot;, &quot;song title&quot;: &quot;Flight of the Nazgul&quot;, &quot;type&quot;: &quot;hill&quot;, &quot;x&quot;: 49.4945077, &quot;y&quot;: 8.1286726}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [9.436243953, 44.1253076399, 9.436243953, 44.1253076399], &quot;geometry&quot;: {&quot;coordinates&quot;: [9.436243953, 44.1253076399], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;1&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Minas Morgul&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Easternmost point of the White Mountains, close to Anduin&quot;, &quot;other name&quot;: &quot;Tower of the Guard, Minas Anor, Mundburg, The Guarded City, Tower of Arnor&quot;, &quot;referred_place&quot;: &quot;Minas Tirith&quot;, &quot;related lyrics&quot;: &quot;To Minas Tirith White they\\u2019ve passed road&quot;, &quot;song title&quot;: &quot;The Passing of the Grey Company&quot;, &quot;type&quot;: &quot;city&quot;, &quot;x&quot;: 44.1253076399, &quot;y&quot;: 9.436243953}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [4.7387549269, 44.8289080134, 4.7387549269, 44.8289080134], &quot;geometry&quot;: {&quot;coordinates&quot;: [4.7387549269, 44.8289080134], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;2&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Minas Morgul&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Gondor, Northern Lamedon, south of the White Mountains and Edoras, near to the southern entrance to the Paths of the Dead.&quot;, &quot;other name&quot;: &quot;Northern Lamedon, south of the White Mountains and Edoras&quot;, &quot;referred_place&quot;: &quot;Erech&quot;, &quot;related lyrics&quot;: &quot;At the stone of Erech they shall hear a horn in the hills&quot;, &quot;song title&quot;: &quot;The Passing of the Grey Company&quot;, &quot;type&quot;: &quot;hill&quot;, &quot;x&quot;: 44.8289080134, &quot;y&quot;: 4.7387549269}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [-0.4898657755, 42.7715974269, -0.4898657755, 42.7715974269], &quot;geometry&quot;: {&quot;coordinates&quot;: [-0.4898657755, 42.7715974269], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;3&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Minas Morgul&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Between Gondor and Rohan&quot;, &quot;other name&quot;: &quot;Ered Nimrais&quot;, &quot;referred_place&quot;: &quot;White Mountains&quot;, &quot;related lyrics&quot;: &quot;Far away, covered by shadows, White Mountains,&quot;, &quot;song title&quot;: &quot;The Passing of the Grey Company&quot;, &quot;type&quot;: &quot;mountain&quot;, &quot;x&quot;: 42.7715974269, &quot;y&quot;: -0.4898657755}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [4.3109901639, 44.3080843633, 4.3109901639, 44.3080843633], &quot;geometry&quot;: {&quot;coordinates&quot;: [4.3109901639, 44.3080843633], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;4&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Minas Morgul&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Gondor, in the province of Lamedon near the Stone of Erech.&quot;, &quot;other name&quot;: &quot;Blackroot&quot;, &quot;referred_place&quot;: &quot;Morthond&quot;, &quot;related lyrics&quot;: &quot;Morthond&quot;, &quot;song title&quot;: &quot;Morthond&quot;, &quot;type&quot;: &quot;river&quot;, &quot;x&quot;: 44.3080843633, &quot;y&quot;: 4.3109901639}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [8.1286725884, 49.4945077089, 8.1286725884, 49.4945077089], &quot;geometry&quot;: {&quot;coordinates&quot;: [8.1286725884, 49.4945077089], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;5&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Minas Morgul&quot;, &quot;album year&quot;: 1995, &quot;location&quot;: &quot;Southern Mirkwood&quot;, &quot;other name&quot;: &quot;Hill of Dark Sorcery, Amon Lanc, the dungeons of the Necromancer&quot;, &quot;referred_place&quot;: &quot;Dol Guldur&quot;, &quot;related lyrics&quot;: &quot;Dol Enshrined in silence and runes will keep\\nthe secrets of Dol Guldur&quot;, &quot;song title&quot;: &quot;Through the Forest of Dol Guldur&quot;, &quot;type&quot;: &quot;hill&quot;, &quot;x&quot;: 49.4945077089, &quot;y&quot;: 8.1286725884}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [4.7387549269, 44.8289080134, 4.7387549269, 44.8289080134], &quot;geometry&quot;: {&quot;coordinates&quot;: [4.7387549269, 44.8289080134], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;6&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Dol Guldur&quot;, &quot;album year&quot;: 1997, &quot;location&quot;: &quot;\\tNorthern Lamedon, south of the White Mountains and Edoras&quot;, &quot;other name&quot;: &quot;Northern Lamedon, south of the White Mountains and Edoras&quot;, &quot;referred_place&quot;: &quot;Erech&quot;, &quot;related lyrics&quot;: &quot;At the stone of Erech they shall stand again&quot;, &quot;song title&quot;: &quot;Unto a Long Glory...&quot;, &quot;type&quot;: &quot;hill&quot;, &quot;x&quot;: 44.8289080134, &quot;y&quot;: 4.7387549269}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [4.5080671036, 45.2264937717, 4.5080671036, 45.2264937717], &quot;geometry&quot;: {&quot;coordinates&quot;: [4.5080671036, 45.2264937717], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;7&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Dol Guldur&quot;, &quot;album year&quot;: 1998, &quot;location&quot;: &quot;White Mountains, Dwimorberg&quot;, &quot;other name&quot;: &quot;Dwimorberg pass&quot;, &quot;referred_place&quot;: &quot;Paths of the Dead&quot;, &quot;related lyrics&quot;: &quot;To the Paths of the Dead&quot;, &quot;song title&quot;: &quot;Unto a Long Glory...&quot;, &quot;type&quot;: &quot;pass&quot;, &quot;x&quot;: 45.2264937717, &quot;y&quot;: 4.5080671036}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [10.791919994, 52.9894966048, 10.791919994, 52.9894966048], &quot;geometry&quot;: {&quot;coordinates&quot;: [10.791919994, 52.9894966048], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;8&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Let Mortal Heroes Sing Your Fame&quot;, &quot;album year&quot;: 2001, &quot;location&quot;: &quot;\\tNorth-east of Rhovanion&quot;, &quot;other name&quot;: &quot;Erebor&quot;, &quot;referred_place&quot;: &quot;Lonely Mountain&quot;, &quot;related lyrics&quot;: &quot;Mountain King(Thorin II Oakenshield)&quot;, &quot;song title&quot;: &quot;The Mountain King\\u0027s Return&quot;, &quot;type&quot;: &quot;mountain&quot;, &quot;x&quot;: 52.9894966048, &quot;y&quot;: 10.791919994}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [9.436243953, 44.1253076399, 9.436243953, 44.1253076399], &quot;geometry&quot;: {&quot;coordinates&quot;: [9.436243953, 44.1253076399], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;9&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Old Mornings Dawn&quot;, &quot;album year&quot;: 2013, &quot;location&quot;: &quot;Easternmost point of the White Mountains, close to Anduin&quot;, &quot;other name&quot;: &quot;Tower of the Guard, Minas Anor, Mundburg, The Guarded City, Tower of Arnor&quot;, &quot;referred_place&quot;: &quot;Minas Tirith&quot;, &quot;related lyrics&quot;: &quot;The White Tower&quot;, &quot;song title&quot;: &quot;The White Tower&quot;, &quot;type&quot;: &quot;city&quot;, &quot;x&quot;: 44.1253076399, &quot;y&quot;: 9.436243953}, &quot;type&quot;: &quot;Feature&quot;}, {&quot;bbox&quot;: [4.127051038, 50.0970279889, 4.127051038, 50.0970279889], &quot;geometry&quot;: {&quot;coordinates&quot;: [4.127051038, 50.0970279889], &quot;type&quot;: &quot;Point&quot;}, &quot;id&quot;: &quot;10&quot;, &quot;properties&quot;: {&quot;album&quot;: &quot;Old Mornings Dawn&quot;, &quot;album year&quot;: 2013, &quot;location&quot;: &quot;\\tabove Khazad-d\\u00fbm, between Celebdil and Fanuidhol, on the border between Eriador and Rhovanion&quot;, &quot;other name&quot;: &quot;Redhorn, Barazinbar&quot;, &quot;referred_place&quot;: &quot;Caradhras&quot;, &quot;related lyrics&quot;: &quot;Caradhras&quot;, &quot;song title&quot;: &quot;Caradhras&quot;, &quot;type&quot;: &quot;mountain&quot;, &quot;x&quot;: 50.0970279889, &quot;y&quot;: 4.127051038}, &quot;type&quot;: &quot;Feature&quot;}], &quot;type&quot;: &quot;FeatureCollection&quot;});\n",
       "\n",
       "        \n",
       "    \n",
       "    geo_json_bf2a7eaca04093b4bf468624e0cec2e9.bindTooltip(\n",
       "    function(layer){\n",
       "    let div = L.DomUtil.create(&#x27;div&#x27;);\n",
       "    \n",
       "    let handleObject = feature=&gt;typeof(feature)==&#x27;object&#x27; ? JSON.stringify(feature) : feature;\n",
       "    let fields = [&quot;referred_place&quot;, &quot;type&quot;, &quot;album&quot;, &quot;album year&quot;, &quot;song title&quot;, &quot;related lyrics&quot;, &quot;other name&quot;, &quot;location&quot;, &quot;x&quot;, &quot;y&quot;];\n",
       "    let aliases = [&quot;referred_place&quot;, &quot;type&quot;, &quot;album&quot;, &quot;album year&quot;, &quot;song title&quot;, &quot;related lyrics&quot;, &quot;other name&quot;, &quot;location&quot;, &quot;x&quot;, &quot;y&quot;];\n",
       "    let table = &#x27;&lt;table&gt;&#x27; +\n",
       "        String(\n",
       "        fields.map(\n",
       "        (v,i)=&gt;\n",
       "        `&lt;tr&gt;\n",
       "            &lt;th&gt;${aliases[i]}&lt;/th&gt;\n",
       "            \n",
       "            &lt;td&gt;${handleObject(layer.feature.properties[v])}&lt;/td&gt;\n",
       "        &lt;/tr&gt;`).join(&#x27;&#x27;))\n",
       "    +&#x27;&lt;/table&gt;&#x27;;\n",
       "    div.innerHTML=table;\n",
       "    \n",
       "    return div\n",
       "    }\n",
       "    ,{&quot;className&quot;: &quot;foliumtooltip&quot;, &quot;sticky&quot;: true});\n",
       "                     \n",
       "&lt;/script&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x1b18a3d00>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# try to use geopandas to save time\n",
    "\n",
    "# csv to geodf\n",
    "from fileinput import filename\n",
    "from socket import create_server\n",
    "\n",
    "geome = gpd.points_from_xy(df_ov_test_poi['y'],df_ov_test_poi['x'])\n",
    "gdf = gpd.GeoDataFrame(df_ov_test_poi, geometry = geome, crs=4326)\n",
    "type(gdf)\n",
    "\n",
    "# gdf.to_file(filename='test_poi_for_ite_map', driver='ESRI Shapefile', crs=4326)\n",
    "\n",
    "# geodf to interactive map\n",
    "ite_map = gdf.explore(tiles='Stamen Watercolor', popup=False, marker_type='marker', highlight_kwds= {\"fillOpacity\": 0.3})\n",
    "ite_map\n",
    "\n",
    "#ite_map.save('interactive_map_4_obvious_poi.html')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.5 ('geo_env')",
   "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.10.5"
  },
  "vscode": {
   "interpreter": {
    "hash": "65e2cb842e6cf65c161604f06566be98a06353bd64fb7cf6b38736cc31aa9aa7"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}