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!

Compétences : API Google Maps, MySQL, PHP

en voir plus : 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

Concernant l'employeur :
( 13 commentaires ) Gerolzhofen, Germany

Nº du projet : #16862446

Décerné à:


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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(37 Commentaires)

18 freelance font une offre moyenne de €187 pour ce travail


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). Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(207 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(161 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(40 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(48 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(28 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(65 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 6 jours
(43 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(17 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 6 jours
(25 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(13 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(8 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(16 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(1 Évaluation)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)

Hello I can do that in php , I also have no problem dealing with MariaDB "its the one I use if available " but for more than 11,000 requests from Google ... I have to take time to accommodate for the daily quota Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(0 Commentaires)