I'm using a mySQL Database where I store bookmarks from a map (in the table I store the latitude and longitude of these bookmarks) my question is, do I make a select by picking up all markers that are in a proximity radius of a point bookmark), I found this solution: en.stackoverflow.com/questions/55669/... however I confess I did not understand the suggested solution, so I would like help in this matter.
I'm using a mySQL Bank where I store bookmarks for a map
1
asked by anonymous 30.03.2017 / 15:10
1 answer
2
The solution would be to start from its central point to draw a range of it, which would be the radius of its circle. The Haversine formula returns in the column the distance from the surveyed point of its starting point. In SELECT the formula would be in a column and the search radius would stay in your WHERE.
SELECT (calculation) AS distance FROM table WHERE distance
30.03.2017 / 15:40