[postgis] Nearest To Searching

[John Grange]

Hi,

Is there any way to easily find the nearest n points to another point.  I
have tables with many many (millions) of records and I need to locate
nearest neighbours.

Any ideas?


John Grange
BSc. (Hons) Dunelm
LocaVista Ltd.
Orchard House
Castle Garth
Kendal, Cumbria
LA9 7ATTel +441539 739554
Fax +44 1539 729995
Mobile +44 7876 038 058



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get your FREE VeriSign guide to security solutions for your web site: encrypting transactions, securing intranets, and more!
http://us.click.yahoo.com/UnN2wB/m5_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/