Finding closest points to a given point
I have a database of coordinates and I am wanting to do something along
the lines of finding the top 3 closest coordinates for a given point.
Is there anyway (in mysql at least) to apply some kind of function to
select the closest points to a given point?
My other option is to fetch all of them, apply the Haversine formula
and find the top 3 smallest distances (could be unrealalistic).
Thanks,
JC
0 Comments:
Yorum Gönder
<< Home