Google Maps Driving Distance and Duration API with Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I've been trying to get actual driving distances and duration by wrapping in my personal API key.
I've been following this amazing guide: https://jdunkerley.co.uk/2016/07/21/geocoding-and-finding-nearest-station-with-google-web-services/
This is exactly what I need but I keep getting errors when inputting the API key URL in the Formula tool.
Also, do I need to use the Distance tool (since I only have the general license it doesn't come with TomTom capabilities) at any point or can I just add the results onto the data I already have? (I used the Append Tool to get multiple addresses listed)?
Thanks!
Solved! Go to Solution.
- Labels:
- API
- Datasets
- Expression
- Spatial Analysis
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi James,
I'm not quite sure what I'm doing wrong but I've attached what I just did (with some of your help on a different issue!).
I think I need to add another join in order for the original results to query Google services in just the way I want it.
What do you think?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry James!
Sample data should be attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
James,
When replacing your data with mine I get the accurate results I want. You're amazing :)
Thank you so much for your help! (My thesis will go a bit better now!)
Martha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Always happy to help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nearly a year later this really helped me - thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I've tried running this and it works great so far in short bursts!
However, I'm running into the issue where I have 10 origin points and thousands of destination points and when I simply list all points as equal, I get multiple millions of records trying to go through the API. Is there a way to specifically set which points are origin points and which ones are destination points to be able to scale the workflow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @robshiffer - I use the Google API a bit and this is how I do it.
I keep the Origin and Destination lat/lons as separate fields in my data stream and then I make a callout to the Google Distance Matrix API like this:
https://maps.googleapis.com/maps/api/distancematrix/json?origins=[Origin Lat/Lon]&destinations=[Destination Lat/Lon]&units=[Unit Type]&key=[key]
