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 In3 days
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online