Go Back   Forums @ The Digital Fix > Gadgets and Gizmos > Computing Forum

Reply
 
Thread Tools Display Modes
Old 27-01-2020, 15:21   #1
pigpicker
Too Orangey for Crows!
 
pigpicker's Avatar
 
Join Date: Nov 2002
Location: South Holland
Posts: 1,658
Thanks: 71
Thanked 29 Times in 18 Posts
Quick Way to Get Driving Distances Between Multi Postcodes?

Not sure if there's quick a way of doing this but thought I'd check here ...

I need a quick way of finding out distances (by road) between many postcodes around the UK.

For example:

Postcode 1 to Postcode 2
Postcode 3 to Postcode 2
Postcode 4 to Postcode 2
...
Postcode 326 to Postcode 2


Obviously I could spend 3 hours typing postcodes into Google Maps and logging the answer but surely there must be a better way ..?

- Could I upload a CSV with all postcodes to Google/Bing maps or similar?
- Is there a Power BI function that uses a Google/Bing App?
- Etc?

Thanks in advance & fingers crossed
pigpicker is offline   Reply With Quote
Old 27-01-2020, 17:00   #2
Wooglie
Rurouni
 
Wooglie's Avatar
 
Join Date: May 2001
Location: Farnborough
Posts: 5,883
Thanks: 1,304
Thanked 941 Times in 408 Posts
http://letmegooglethat.com/?q=distan...+postcodes&l=1
Wooglie is offline   Reply With Quote
Thanked once by:
pigpicker (27-01-2020)
Old 27-01-2020, 17:55   #3
pigpicker
Too Orangey for Crows!
 
pigpicker's Avatar
 
Join Date: Nov 2002
Location: South Holland
Posts: 1,658
Thanks: 71
Thanked 29 Times in 18 Posts
Thanks Wooglie - That is nearly perfect but I need the 'by road' option for the bulk upload version ... not 'as the crow flies'.

I don't suppose anyone else knows a way around this?
pigpicker is offline   Reply With Quote
Old 27-01-2020, 19:24   #4
douglasb
Suedehead.
 
douglasb's Avatar
 
Join Date: Feb 2001
Location: Exiled in England
Posts: 11,073
Thanks: 148
Thanked 895 Times in 545 Posts
Pay somebody in the 3rd world a few cents via Amazon Turk.
douglasb is offline   Reply With Quote
Old 03-02-2020, 16:05   #5
AdamBrunt
Trusted User
 
Join Date: Sep 2000
Location: UK
Posts: 24,841
Thanks: 136
Thanked 285 Times in 199 Posts
Depending on what coding language you are using you might be able to use Google's Distance Matrix API. This lets you pass in start and end post code as well as mode of travel ( car, bike, walking, etc ). This will return the distance and the time it will take.
AdamBrunt is offline   Reply With Quote
Old 03-02-2020, 17:04   #6
allan
Trusted User
 
Join Date: Mar 2001
Location: England
Posts: 13,672
Thanks: 275
Thanked 293 Times in 232 Posts
I've used Google API, it's relatively easy and will do exactly what you're asking. Their documentation is pretty comprehensive.
allan is offline   Reply With Quote
Thanked once by:
pigpicker (12-02-2020)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DECT phone over long distances smiffy Computing Forum 1 11-09-2015 10:51

All times are GMT. The time now is 18:59.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Copyright ©2000 - 2018 Poisonous Monkey Ltd. Part of The Digital Fix Network