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.

  • Status Completed
  • Budget $30 - $250 USD
  • Total Bids 28

Project Description

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]


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

Get free quotes for a project like this
Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online