generation random location on google maps

This project was successfully completed by phpwebsoft for $30 USD in 3 days.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
3 days
Total Bids
Project Description


explanation: I have members with incomplete addresses.

for example Joe, Berlin cannot be imported into a google map because street name is not there.

this is why we get the coordinates of Berlin using worldwide table with city coordinates

giving Joe, [url removed, login to view], 17367040 will put joe exactly into Berlin on the map

now we want to put joe randomly in a distance to the center of Berlin using a Random number, because there might be others in Berlin and we dont want the marker to be exactly on the same place as joe.......:)

also possible to do it on excel and then import it into mysql.

1 step: import cities coordinates into mysql database

2 step: import country coordinates into mysql database

3 step: link table members/city/country with table cities/coord and with table countries/coord

4 step: make a new table members/coordinates cities/coordinates countries

5 step: make another column with random number 0 to 1

6 step make another columns with random number 0 to 1

7 step: make a calculation to generate a new location using constant R

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