Find Jobs
Hire Freelancers

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

€30-250 EUR

Completed
Posted almost 6 years ago

€30-250 EUR

Paid on delivery
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.
Project ID: 16862446

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 plenty of keys). Would love to chat! Regards, Joseph Cardwell
€111 EUR in 1 day
4.8 (37 reviews)
5.8
5.8
18 freelancers are bidding on average €187 EUR for this job
User Avatar
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 all in your time limit so please give us chance to serve you thanks in advance :)
€300 EUR in 3 days
5.0 (161 reviews)
6.8
6.8
User Avatar
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 not attach table structure sql, can you please send it to me. 2) you did not note what kind of mode to use. Usually mode=driving used but perhaps you are interesting in mode=walking. 3) is it correct: you want to calculate disteances from 11080 addresses to the same 1 concrete adress? Can you please show this concrete address and to show 1-2 real addreses. I want to check if adresses will be recognized by API well. I will use php and curl to perform requests to API. All requests sent and all responses received will be stored in log file (ordinar text file). All queries to insert data in the table will be provided as well.
€200 EUR in 5 days
4.9 (48 reviews)
5.6
5.6
User Avatar
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
5.0 (43 reviews)
5.4
5.4
User Avatar
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
5.0 (25 reviews)
4.7
4.7
User Avatar
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 thoughts on the project through PM. ---- I always look carefully at the task and bid only personally, not just copy-pasting whatever promotional text If you see this sentence - you can be sure that I'm interested in your job and ready to go
€222 EUR in 4 days
4.4 (8 reviews)
4.2
4.2
User Avatar
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 development. I am providing services in below areas. 1) Web development 2) WordPress and woocommerce 3) front end develolment using angular js and react js, core jacascript, jquery 4) database management and database security. mysql and monogodb 5) responsive Web design using bootstrap and css3 6) page speed increase and Web site seo using Google page speed. 7) core php solutions and development. I have experience of code optimization and algorithm design. I have knowledge of tree, graph and link list algorithm. I know how to make code better and fast. I am following all coding guide lines to make code better and fast. My company objective to make our client satisfied and happy . I take care the every requirement of client and deadline. i have done 150 projects in 5 years. I am dedicated and honest freelancer. I have work experience for top MNC companies as software engineer. I have worked for HCL technology pvt ltd and tcs. I have done internship under Google pvt ltd. I have done one project for BRLCAD USA army research lab. If you like to hire me then just put me a message
€200 EUR in 3 days
3.6 (16 reviews)
5.1
5.1
User Avatar
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 to provide you my best estimations. Looking forward to hear from you soon. Thanks Gourav
€111 EUR in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
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 P.S There is nothing attached in the job description . Thanks
€150 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Gerolzhofen, Germany
4.8
13
Payment method verified
Member since Apr 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.