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 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!
24 freelancers are bidding on average €186 for this job
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