Completed

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:

[url removed, login to view][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: [url removed, login to view]

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:
( 0 reviews ) Gerolzhofen, Germany

Project ID: #16862446

Awarded to:

joomsavvy

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
(33 Reviews)
5.7

24 freelancers are bidding on average €186 for this job

karimmughal1

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
(158 Reviews)
7.1
mekiho

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
(36 Reviews)
5.9
smallpig

Hello Thanks for the opportunity to bid on your project. I'm a master in GIS fields. I've rich experience in developing interactive webMap based on google Maps API, Leaflet, ArcGIS. I would like to discuss about yo More

€250 EUR in 3 days
(17 Reviews)
5.8
ajoy3freelancer

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)
5.4
forumizer

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
(42 Reviews)
5.5
AndrejStastny

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
(20 Reviews)
5.2
thusitcp

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)
5.3
bjrupani

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
(48 Reviews)
5.1
mike25

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)
4.7
hiteshkumar2

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
(14 Reviews)
4.3
javedaasim

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
(6 Reviews)
3.8
€155 EUR in 3 days
(16 Reviews)
3.8
redincorpindia

Dear client I saw your requirement regarding Google map all work. I can develop and deliver within a day maximum. I'm a professional developer for developing custom applications from scratch in both web and deskto More

€180 EUR in 1 day
(8 Reviews)
3.7
leeandnee

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)
3.4
rohit554ITHUB

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
(7 Reviews)
3.3
tjcg

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)
2.6
€155 EUR in 3 days
(1 Review)
1.8
maestrogarry

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)
0.8
BlackStarGazer

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 More

€150 EUR in 10 days
(0 Reviews)
0.0
vnezapno

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
(0 Reviews)
0.0