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 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!
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
18 freelance font une offre moyenne de €187 pour ce travail
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
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
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
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
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
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.
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
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
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
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
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
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