generation random location on google maps

IN PROGRESS
Bids
1
Avg Bid (USD)
$30
Project Budget (USD)
$10 - $30

Project Description:
Projektbeschreibung:
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, 1.9.255.255, 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

Skills required:
Excel, MySQL
Hire onetwothreephp
Project posted by:
onetwothreephp Switzerland
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 3 days