Prepare for Hurricane Elsa 20210706-1700

# pip install -U pandas

GOOGLE_KEY = 'AIzaSyDqR8ePmVqzh-wF3R89tsZyhCZjaTI_mFI'

from geopy.geocoders import GoogleV3
geocode = GoogleV3(api_key=GOOGLE_KEY).geocode
address = '4210 S Grandmarch Avenue, Homosassa, FL 34446'
location = geocode(address)

normalized_address = location.address
latitude = location.latitude
longitude = location.longitude

from pandas import read_csv
table_path = 'locations-20210706-1630.csv'
table = read_csv(table_path)

table[:3]

geocode('7500 W. Gulf to Lake Highway, Crystal River, FL 34429')

def pinpoint_location(row):
    address = row['Location Address']
    location = geocode(address)
    longitude = location.longitude
    latitude = location.latitude
    row['Normalized Address'] = address
    row['Longitude'] = longitude
    row['Latitude'] = latitude
    return row

located_table = table.apply(pinpoint_location, axis=1)

located_table[:3]

ls

normalized_table = located_table[[
    'Location Name',
    'Normalized Address',
    'Location County',
    'Open',
    'Close',
    'Resources',
    'Type',
    'Source',
    'Organization Name',
    'Longitude',
    'Latitude',
]]
normalized_table.to_csv('normalized-locations-20210706-1630.csv', index=False)

my_address = '5709 12th Ave S, Gulfport, FL 33707'
my_location = geocode(address)
my_longitude = my_location.longitude
my_latitude = my_location.latitude
my_lat_lon = my_latitude, my_longitude

from geopy.distance import distance

def get_distance(row):
    my_distance = distance((my_latitude, my_longitude), (row['Latitude'], row['Longitude']))
    row['Distance in Miles'] = my_distance.miles
    row['Distance in Meters'] = my_distance.m
    return row

distance_table = normalized_table.apply(get_distance, axis=1)

distance_table.iloc[0]

sorted_table = distance_table.sort_values('Distance in Meters')

filtered_table = sorted_table[sorted_table['Resources'] == 'Sandbags']
filtered_table

filtered_table = filtered_table[[
    'Distance in Miles',
    'Distance in Meters',
    'Location Name',
    'Normalized Address',
    'Open',
    'Close',
    'Resources',
    'Type',
    'Location County',
    'Organization Name',
    'Source',
]]
filtered_table