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

Abgeschlossen
Veröffentlicht vor fast 6 Jahren

€30-250 EUR

Bezahlt bei Lieferung
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.
Projekt-ID: 16862446

Über das Projekt

18 Vorschläge
Remote Projekt
Aktiv vor 6 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tag
4,8 (37 Bewertungen)
5,8
5,8
18 Freelancer bieten im Durchschnitt €187 EUR für diesen Auftrag
Avatar des Nutzers
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 Tagen
5,0 (161 Bewertungen)
6,8
6,8
Avatar des Nutzers
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 Tagen
4,9 (48 Bewertungen)
5,6
5,6
Avatar des Nutzers
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 Tagen
5,0 (43 Bewertungen)
5,4
5,4
Avatar des Nutzers
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 Tagen
5,0 (25 Bewertungen)
4,7
4,7
Avatar des Nutzers
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 Tagen
4,4 (8 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 Tagen
3,6 (16 Bewertungen)
5,1
5,1
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
0,8
0,8
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von GERMANY
Gerolzhofen, Germany
4,8
13
Zahlungsmethode verifiziert
Mitglied seit Apr. 24, 2018

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.