[Site Selection - CBGs] #mango #bigquery

site_selection_cbgs.sql

unique_venues = sites_with_foot_traffic.drop_duplicates(subset=['name'])

# initialize map
map = folium.Map(location = [30.3006387,-97.7587983],
                 zoom_start = 11,
                 tiles='Stamen Toner')

# add pins of candidate locations
for _, r in unique_venues.iterrows():
    geo_j = gpd.GeoSeries(r['geo']).to_json()
    geo_j = folium.GeoJson(data=geo_j, style_function=lambda x: {'fillColor': 'red'})
    folium.Popup(r['us_cbgs_2018_name']).add_to(geo_j)
    geo_j.add_to(map)

    map.add_child(folium.Marker(location = [r.latitude, r.longitude], popup = str(r["name"]), icon = folium.Icon(color = "red")))

# show the map
map