Try the toolbox from www.routeware.dk There is the option of selecting the 2 nearest objects. That should do in your situation after filtering the "0m"'s.
Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Stephen Smith XS (MC/TKO)" <[EMAIL PROTECTED]> To: "Nabors, Steve" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Tuesday, September 13, 2005 3:21 PM Subject: RE: MI-L Nearest Neighbour MBX I have tried a hole bunch none seem to work. Problem is i have a table with 4000 GSM sites and only need to know the distance to the nearest site and the site name. If I use the tools that I have found the query is normally find the nearest site from each site in Table A with Each site in table B. The neasest site is always itself. Copy Table was no help at all. The problem with copy table is it will still look at the same point in the duplicate table on the same location as the closest thus returning "0m" closest point being itself in dup table. Tools used sofar. CalDist Pro.mbx distance.mbx findnearestobject.mbx calcdist-280.mbx Also GridAnalyser http://www.terris.sk Still no joy. Any help will be appreciated. Steve. -----Original Message----- From: Nabors, Steve [mailto:[EMAIL PROTECTED] Sent: 13 September, 2005 4:43 PM To: Stephen Smith XS (MC/TKO) Subject: RE: MI-L Nearest Neighbour MBX What tools have you found because this is something I've been wanting but it has not come up the priority list yet. Did "using a copy of the table" solve it for any of them as someone suggested? -----Original Message----- From: Stephen Smith XS (MC/TKO) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 13, 2005 2:43 AM To: [email protected] Subject: MI-L Nearest Neighbour MBX Can anyone help me out with a nearest neighbour MBX. The ones I have come across on the net all seem seem to have to work with different tables. I have a table with 4000 random points and i just need the distance from each poit to its closest neighbour. When I use the tool I found they return "0" Stephen Smith RND & TND Manager Ericsson Oman * +968 24478279 s? +968 99447639 * [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17845 ______________________________________________________________________ This e-mail has been scanned by MCI/MessageLabs Managed Email Service. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17852 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17854
