Use the Google Maps API (geocode) to create a daily process to add new address data and coordinates to a database using MySQL and PHP.

Closed

I got a big list of “reference addresses” (addresses without street number, intersections, subway stations, etc.). This list receives every day new addresses automatically. I need to complete this “reference addresses” information and the coordinates with the data that is returned by Google. Here is an example:

I got this address: Hernando de Magallanes, Las Condes, Santiago, Chile.

(In this example, “Hernando de Magallanes” is a street name and also a subway station in the city of Santiago, country of Chile)

Using this URL: [url removed, login to view]+de+Magallanes%2C+Las+Condes%2C+Santiago%2C+Chile&sensor=true

I would need to add to the database this:

subway_station: Hernando de Magallanes

route: Hernando de Magallanes

administrative_area_level_3: Las Condes

administrative_area_level_1: Región Metropolitana de Santiago de Chile

formatted_address: Hernando de Magallanes, Las Condes, Región Metropolitana de Santiago de Chile, Chile

location: [url removed, login to view],[url removed, login to view]

etc.

So the job consists in:

- Create the necessary table structure in the database to store the geodata values returned by Google

- Create a process to automatically query new street addresses and store the values in the database

- Keep track of witch street addresses have successfully retrieve the values and witch need to be ask again

Skills: MySQL, PHP

See more: google data api, google maps php mysql geocode, use of data structure, the street com, table data structure, process data structure, new data structure, list of data structure, list in data structure, list data structure, data structure list, data structure example, create the php geocode, create mysql database using php, google geocode api, the de, structure sensor, santiago, php json, json php, json and mysql, coordinates , City Maps, chile

Project ID: #4072570

Awarded to:

trotinarius

I already have the solution. Please check pm.

$100 USD in 1 day
(4 Reviews)
3.0

28 freelancers are bidding on average $156 for this job

kabirchy

Hi, I can help you get this done using Google Maps Geo API. best quality assured. Thanks

$125 USD in 2 days
(733 Reviews)
8.1
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$225 USD in 5 days
(224 Reviews)
7.7
RockStone435

How you create a formatted address, out of the information you have in the list? the list is in which format, CSV, XML?

$100 USD in 10 days
(260 Reviews)
7.5
rinsadsl

Please see my private message

$100 USD in 2 days
(193 Reviews)
6.7
keiespro

Hello. I can make it within 2 days at most. Give me the job please.

$150 USD in 2 days
(121 Reviews)
6.3
Chtioui86

Hi, Please see your private msg TY

$100 USD in 2 days
(61 Reviews)
5.9
TheInnoVibes

Please check private message

$100 USD in 2 days
(38 Reviews)
5.8
Mezh

Hello, I can help you with it, have rich experience with required tools. Thanks, Alex

$149 USD in 3 days
(32 Reviews)
5.8
MustafaSR

Hello Sir, Please check the PMB

$140 USD in 4 days
(65 Reviews)
5.5
SRajpurohit

I am ready to do this php,mysql and google map api work.Thanks

$99 USD in 3 days
(32 Reviews)
5.4
surajddk

Hi, I can do this perfectly, already completed same kind of php project. Please check pMB for more details,

$100 USD in 3 days
(27 Reviews)
5.4
Jeyes323

I can help you sir! Let's start right now. Regards

$150 USD in 1 day
(36 Reviews)
5.1
phpthebest

I have made your project , check PM.

$70 USD in 0 days
(30 Reviews)
4.7
arickbro

Dear Sir, Please check PMB for more detail.

$99 USD in 3 days
(9 Reviews)
4.6
corpotec1993

ready to assist. Thank you

$800 USD in 10 days
(28 Reviews)
4.5
Creativeartbd

Well, I got it your functionality. I can do this.

$100 USD in 2 days
(19 Reviews)
4.4
byrasoft

Will be delivered accordingly. Please check PMB. Thanks.

$90 USD in 7 days
(43 Reviews)
4.4
readyfacts

Expert in Google maps api. Already has code for all the these features... Please refer my PM for further details.

$150 USD in 2 days
(28 Reviews)
4.2
webstechno

Please check our Pm for more details.

$67 USD in 2 days
(9 Reviews)
3.9
sapewady

Let's do this. Please check PMB.

$60 USD in 3 days
(3 Reviews)
3.8