I have a database of 1000 Canadian addresses with fields for province, postal code and address.
- I want users to be able to search for all the locations within a certain distance(10km, 25km, 50km, 100km) of a postal code OR address and see the results listed on the page.
- When the results are returned a google map will zoom to the appropriate view and show all of the resulting locations. The google map icons should be letters which correspond to the letters of the text results.
- There will be a geocode and last_geocoded field for locations database. If no geocode is found for a location the script should attempt to fetch a geocode from google and save it in the database and update the last_geocoded field.