#!/usr/bin/env python
# coding: utf-8

# In[1]:


get_ipython().system('pip install folium')
get_ipython().system('pip install googlemaps')


# In[2]:


import folium as fm
import pandas as pd
import numpy as np
import sys


# In[3]:


# Get buildings coordinats
df = pd.read_csv('/resources/data/Open Data Day/Bauwerke1.csv')
buildings = pd.DataFrame(df[['Art des Bauwerks', 'Seitenname', 'Koordinaten']])
buildings['Long'] = float(0)
buildings['Lat'] = float(0)
buildings.dropna(axis = 0, inplace = True)
idx = np.arange(len(buildings['Seitenname']))
buildings.index = idx

# Convert buildings coordinats into right format
for i in range(len(buildings)):
    geo = buildings.iloc[i]['Koordinaten']
    string = geo.split(" ")
    t1=48
    m1=string[1]
    m1=float(m1[:-1])
    s1=string[2]
    s1=float(s1[:-2])
    erste=t1+m1/60+s1/3600
    t2=16
    m2=string[4]
    m2=float(m2[:-1])
    s2=string[5]
    s2=float(s2[:-1])
    zweite=str(t2+m2/60+s2/3600)
    buildings.set_value(i, 'Long', erste)
    buildings.set_value(i, 'Lat', zweite)
    
buildings.head()


# In[4]:


Vienna=[48.2080555556, 16.3680555556]
map_vienna = fm.Map(location=Vienna,zoom_start=11)


# In[5]:


reload(sys)
sys.setdefaultencoding('utf8')


# In[6]:


marker_cluster_buildings = fm.MarkerCluster()
for row in range(len(buildings)):
    # Create Marker
    fm.Marker(location=[buildings.iloc[row][3], buildings.iloc[row][4]], 
              popup=(buildings.iloc[row][0] + ": " + buildings.iloc[row][1])).add_to(marker_cluster_buildings)
    
map_vienna.add_children(marker_cluster_buildings)