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
Employer working
Completed by:
Skills Required
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

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