Perform and store ten thousand API requests on Google Maps distance-matrix API - 02/05/2018 08:49 EDT

I want to read the distance (in street-km) between addresses from the distance-matrix-API of Google Maps.

I deliver the SQL-Create code of a MySQL table with the 11080 addresses as a dropbox link (322kb as .zip file, 1983KB as .sql file, see the attached MySQL/MariaDB table create code as preview) and want as result the SQL-CREATE+INSERT code of the filled MySQL database and the used script with which the data was read out.

Your task is to read the distance on the road from the Google Maps API for each record and fill in the five fields (all returned by the Google-Maps-API):

google_api_destination_addresses = Return value of the Google API: What destination address was recognized by Google

google_api_distance_text = Return value of the Google API: elements -> distance -> text

google_api_distance_value = Return value of the Google API: elements -> distance -> value

google_api_duration_text = Return value of the Google API: elements -> duration -> text

google_api_duration_value = Return value of the Google API: elements -> duration ->value

google_api_status = Return value of the Google API: elements -> status (should allways be OK)

The API call is as follows:

[login to view URL][given_origin_addresses]&destinations=[given_destination_addresses]&language=de&units=metric&key=[your_API_key]

Important parameters are &language=en&units=metric

The API documentation can be found here: [login to view URL]

Since the API is limited to either 1000 requests per day or 2500 requests per day and you have to do 11080 API-Requests, you need several (either 12 or 5) Google API keys if you want to read all data in one day.

A duration of 3-6 days would also be acceptable, then you only need 2 Google API keys.

At the end I want to get the filled SQL file back (again as CREATE + INSERT) and your script/code that was used to read the Google API.

I don't care about the script language. I would prefer a common language like PHP or ASP.NET or C# or JavaScript.

I expect the results within a week. The task should be very simple and very quick to complete.

The database must be treated confidentially and must be deleted together with all copies upon completion of the order.

See the MySQL/MariaDB table create code attached.

Important parameters are &language=de&units=metric
language=de, not language=en!

Skills: Google Maps API, MySQL, PHP

See more: google maps distance matrix api excel, google maps distance javascript, aspnet google maps distance, google maps distance source, google maps distance php simple, google maps distance demo, google maps distance calculatorjs, google maps distance java, google maps distance linux, google maps distance vbnet, google maps distance calculator api, google maps distance, projects google maps distance calculatorjs, google maps distance calculator, google maps distance script php

About the Employer:
( 12 reviews ) Gerolzhofen, Germany

Project ID: #16862446

Awarded to:


Hello! I'm an Austin, Texas based PHP developer with 12 years of experience. I'm looking for some simple side projects to pick up a little extra cash and this sounds perfect! I can have this done today (I have pl More

€111 EUR in 1 day
(35 Reviews)

22 freelancers are bidding on average €183 for this job


I have developed number of Responsive WordPress Themes in my career from scratch from PSD to WORDPRESS, theme development/plugin development & customization, Custom Web Design (HTML/CSS/JavaScript/JQuery & Bootstrap). More

€200 EUR in 3 days
(188 Reviews)

Hello client I read your description carefully. As a professional developer I am confident in your job. If you hire me, you will get wonderful result. Looking for work with you . Thanks

€155 EUR in 3 days
(54 Reviews)

Hello hiring member i am bhavika i have 2.5 +years experience in php ,laravel ,html css and i have also used google map api and i have good experince with lots of api work and i hace good team who can complete this a More

€300 EUR in 3 days
(96 Reviews)

Hello. I already worked with Google Maps Distance Matrix API and calculates distances between different places in UK. I have API key and can register also several keys without any problem. Several notes: 1) you did More

€200 EUR in 5 days
(48 Reviews)

Hello respected client I am google map /places expert . please check my profile here is my best google map projects I have developed several taxi dispatch software and have vast knowledge Google map distance mat More

€211 EUR in 3 days
(60 Reviews)

Hi I have 13 years experience in PHP and also worked in GMAP. I can create 3 keys and run cron job to complete the task in 4 days gap. Regards Ajoy

€200 EUR in 6 days
(43 Reviews)
€155 EUR in 3 days
(22 Reviews)

Hi there - My name is Ase N from Russia. I’ve read your brief and can see that you’d like to build a Web app. My team has 6 years experience designing and developing web apps. I would approach your project by starting More

€155 EUR in 3 days
(27 Reviews)

Hi, I am an expert website designer and developer with more than six years of experience in website development. My Portfolio: [login to view URL] [login to view URL] http://rest More

€155 EUR in 3 days
(25 Reviews)

Hi, if you can share the sql - i can run some tests and give you back a demo. IF the demo is what you need then if you want you can award me the project.

€233 EUR in 6 days
(25 Reviews)
€155 EUR in 3 days
(19 Reviews)

Hello, I have 6+ years experience in PHP, WordPress & Codeigniter. I Read your job description, I'm interesting in your job. we feel that we are suitable for the job. As a senior WordPress expert, I'll be glad More

€333 EUR in 3 days
(13 Reviews)

Dear Sir, I would like to discuss few thing for better understanding of [login to view URL] share details and ping me for further discussion. Spare a moment on our previous work [login to view URL] https://profeenlinea More

€111 EUR in 3 days
(8 Reviews)

I looked through the project description and ready to help you. I propose Yii2 Framework + MySQL database as the project base(language - PHP). I got experience working with Google Maps API. Ready to share my thoug More

€222 EUR in 4 days
(6 Reviews)

Hi I understand your requirements regarding Web. I am professionals BTech IT engineer. I am providing the every kind of service related to Web sites and server management. I have 5 years experience in Web developme More

€200 EUR in 3 days
(15 Reviews)

Hi sir, Thanks for your post. We have our expert API developers , worked for various mobile app for our clients. So, please come on chat to discuss the job in details, we are ready make the job perfectly as More

€155 EUR in 10 days
(2 Reviews)

I would love to work on your project. Let's define the necessities in details. Also, if you want me to share our previous work please let me know. I will give you full service and maintenance for my work so if you n More

€200 EUR in 3 days
(1 Review)
€155 EUR in 3 days
(2 Reviews)

Hi, I'm Gourav, Full Stack Developer. I have 7+ years of experience in project development. I can handle your project as per your requirements. I would like to discuss more about the project on a quick call or chat More

€111 EUR in 1 day
(1 Review)
€155 EUR in 3 days
(0 Reviews)