
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 29, 2020 12:46 PM
I have a list of addresses and I already represented them through Map block using google Map API on the map.
The queseion is how to get the coresponding geocode (latitude and longitude) for each address.
eventhough I noteced that Map Block created text code for each address called Geocode cache is that may help or converted to coordinates.
“Geocode cache
This block stores additional information for each address. Create a new text field in your table and pick it below. Other map blocks can use the same field.”
Thank you so much for your help in advance.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 07, 2023 10:53 PM
I realize this is a few years old, but in case anyone is searching for this in the future: it looks like those fields are base-64-encoded JSON. I think you'll need to do the decoding in an Automation, but that should get you the latitude and longitude.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2024 09:41 PM
based on work done by @apg314 and @Yourapp from this post, https://community.airtable.com/t5/development-apis/base64-conversion/td-p/103578
I was able to modify the code for Base64 decoding rather than encoding.
Just copy past into a script block and execute to give you a long string which contains lat & long
It's a big JSON bundle so you need extra formula fields to strip out lat & long
eg Lat:
not 100% as decimals vary, but 2000 records had about 10 errors needing manual adjustment
-----
