Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 29, 2020 10:31 AM
Hey guys!!
So I am doing a project, and a need an airtable with the name of a restaurant and the position of it (in coordinates), I will use an API to extract my data from my airtable, but I need it to be in GEOJSON.
Do I use the map app?
How can I do this?
Thank you guys!!
Nov 29, 2020 06:16 PM
Nope. Almost positive the Map App will encode locations in a binary format. You need a script process that given lat/lng (or plotline or polygon point collections) will generate geoJSON in a new field such that it can then be extracted via an external API call.
It might be possible to do this with a formula field, but that may also get a little complex.
Nov 30, 2020 12:10 AM
Maybe send your address data to mapbox.com, which can transform your data into geoJSON.
Nov 30, 2020 06:30 AM
@ScottWorld makes a correct assessment of this challenge.
Often, the answer requires a clearer picture of what happens after the API retrieves the location data, so we’re making some assumptions about your overall architecture and objectives in the process. Feel free to provide additional insights and I’ll bet the right approach will become more clear.
Aug 02, 2024 04:08 PM
Clockwork Micro now offers a tool that allows a user to enter their table's base and table numbers and create an endpoint that delivers the data from the table in geojson format. The table has to have a latitude and a longitude column, though they do not have to have these names. Whatever the column names, one can enter these in the Clockwork Micro UI and then they will be reformatted and relabled in correct geojson format. Have a look at the blog: https://www.clockworkmicro.com/blog/airtable-to-geojson