Build custom travel time/distance matrix tool for large batches of distance-pairs, using the Google Maps/Google Earth services (Distance Matrix API)

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

We are looking to build a custom travel time/distance matrix tool that will collect, error-check and process large batches of distance-pairs using the Google Maps/Google Earth services (Distance Matrix API), and returning/populating the data in a user-friendly format such as an Excel file.

Our batch sizes can be large - perhaps up to one hundred thousand pairs in a batch. We understand this would require us to have a Google Premium Plan, which will charge for each location pair request. Accordingly, we need to ensure that functionality is robust, so we don’t have mid-process failures, erroneous data loads, etc. that would trigger unnecessary requests and charges.

The location pairs may be lat/lon coordinates or place names. If possible, we need to a check on international place names actually used as the Google “guess” sometimes is not accurate for unknown places.

Ideally the tool would operate in and draw the necessary location pair information from a spreadsheet in MS Excel for Mac (2011 or 2016), and either update cells in that sheet or generate a new Excel sheet with the returned data. A sample setup spreadsheet is provided for illustrative purposes.

As an option, we would also entertain a user interface in Google Maps or Google Earth that allows a user to load a large database of locations, select an origin, then select a group (e.g. radius or polygon) of destination points and process all the distance pairs, exporting to an Excel friendly format.

We are open to your thoughts and suggestions about the best approach to meet our needs.

Cartography & Maps Google Earth Google Maps API Microsoft Office Visual Basic

Project ID: #13638541

About the project

11 proposals Remote project Active 6 years ago

Awarded to:

diorisaguilar

I already have worked with similar projects using Google Matrix API to get distance between 2 points. You can send me some testing points to apply the logic and check if the outcome fits your needs.

$490 USD in 4 days
(55 Reviews)
6.2

11 freelancers are bidding on average $910 for this job

schoudhary1553

Bid Summary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

$750 USD in 15 days
(288 Reviews)
8.1
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and More

$2631 USD in 25 days
(24 Reviews)
7.2
ifriends710

Hello. I am a GIS expert and Web&Mobile(iOS&Android) developer. Since 10 years before I have been developing GIS applications. I graduated GIS special education course and I have rich experiences for development More

$700 USD in 10 days
(13 Reviews)
6.2
king18yat

I can help you . In the bid amount , I can provide the website version , android application , ios application with one year support . I am available on all days to discuss and shall provide 2 work updates per week More

$1111 USD in 44 days
(1 Review)
3.0
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discuss More

$555 USD in 10 days
(0 Reviews)
0.0