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