Geocode, reverse geocode and route planning

[Bryan_Smith]

Anyone have any experience with geocodeing? I’m working with Airtable and Integromat to try to create a few integrations with location data that I’m collecting in airtable.

I’m looking to be able to geocode or reverse geocode any record in a table. I have a webform that will detect and capture gps coords if available, or the user can hand enter an address. When capturing the data I would like to use integromat to to geocode or rervese geocode so that the database contains both gps and physical addresses.

Another thing I’m hoping to figure out is how to do route planning, which I believe is possible through the google maps api, given a selection of addresses.

Does anyone have any examples or experience here they could share.

[Jeremy_Oglesby]

I’ve used the Google Maps API in Airtable in conjunction with the Maps Block, but only to map static addresses. That’s about as close as I’ve gotten to what you are asking about.

This sounds super interesting, and I wish I had time to dive into it and test it out, but sadly I just don’t right now :frowning:

I don’t think the Maps Block is currently capable of plotting routes - it just displays pins on the map, one for each record that has a location defined in the view that you point the Block at. So I think, at least at this time, you will have to do your route planning externally to Airtable.

As far as the Geocoding goes, that sounds like something done entirely in Integromat’s logic, and I have no experience working with Integromat. However, it sounds like it should be possible if you have sufficient access to the Google Maps API from within Integromat.

[Bryan_Smith]

I haven’t found optimized routing over at google but I did at Mapquest.

Mapquest will allow you to paste 26 locations on this page and it will make a route.
https://www.mapquest.com/routeplanner. So right now I can simply cut and paste.

But they also have it available in the api and I’ve had some success with the routing here but not getting the route to draw on my own test sample.

MapQuest API Documentation

Optimized Route - GET

Documentation for MapQuest Directions API. Find the optimized routes between locations with a simple interface.

I’m a bit in over my head here but already I have something that sort of works for my purposes but it would be really cool to create a view or filtered set of records and then push that view to an optimized route.

With regard to the Geo and Reverse Geo I am pretty sure it’s possible, i’m also thinking about connecting google places data as well as geo/reverse geo.

My goal is to create a datacollection form that a user can upload a photo and have it’s lat/lon as well as info about the place of business at that location. All this coming into airtable. Then later use airtable to create an optimized delivery route based on selection criteria.

The maps block comes close and I have that working on this as well but like you said, no routing.

[Brady_Hubbard1]

Did you ever figure out a solution for route planning? I have ~15 routes with 15 stops each and I want the routes to live within their own Views in Airtable. The Maps block doesn’t really cut it, and it’s difficult getting a Zapier integration sorted out.

[ZubairLK]

@Bryan_Smith or @Brady_Hubbard1 did you guys come up with a nice solution to a route via airtable.

We have a list of jobs in a day and would like to chart a map for that day

Thanks
ZubairLK

[samru]

Hi all, did someone figure this out? Else I can build it as an extension 

[samstackbrick]

Hey! Did you ever build anything?

[5arahlou]

Hi!  just curious if the above was anything you built as an extension?  it would save me hours if a route planner could be an extension!! Thanks 🙂

[Greg_Lang]

Anyone have luck mapping route data that has taken place.  For example I have the Cords and timestamps from a team of 5 for the day and I want to visualize the route they each took in a color on the map.  I can't seem to find anything that works with Airtable that will show this kind of data.  Thanks in advance if anyone has figured this out!