"10 Downing Street" or "Tokyo, Japan") into a "latitude,longitude" string =GoogleGeocode(address, api_key) Converts a string address (e.g.The Google Geocoding API is comprehensive, but requires an API key. =NominatimReverseGeocode(lat, lng) Converts a latitude and longitude into an address =NominatimGeocode(address) Converts a string address (e.g. The Nominatim API uses OpenStreetMap, which is not as comprehensive as Google's but is free. The MSXML2 reference we use to access the APIs is not available on Mac. It requires Excel 2013 or above (for the WorksheetFunction.EncodeURL method).It has been tested on Office 2017 and Office 365 on Windows.This works through public geocoding APIs. This is an Excel file (with a Visual Basic macro function) that converts addresses to latitudes and longitudes (geocoding), and latitude-longitudes to addresses (reverse geocoding).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2023
Categories |