sg

Cuma, Aralık 09, 2005

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


Komik Videolar   islam  şarkı sözleri  yemek tarifleri  gelibolu  huzur   sağlık