There are some detailed formulae and instructions on inter-point distances,
including distance to nearest neighbour, neighbours within a given distance,
and weighted distance to neighbours in Ian Johnson's book Understanding
MapInfo p 268-272. Published by Archaeological Computing Laboratory,
University of Sydney. ISBN 1 86451 016 1
BH
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 July 2001 23:47
Subject: MI-L Finding the two nearest neighbors in two tables of points
> Dear Listers,
>
> Are there some SQL wizards out there who knows how to do this:
>
> I have two tables containing points. Lets say table X and table Y.
>
> All points in Table X are in country X and all points in table Y are on
> the other side of the country border in the neighboring country Y.
>
> For each and every point in table X I want to select the to nearest
> points in table Y and vice versa.
> And then again select points and neighboring points in the first
> selection/query that are not more than for example 10 kilometers away
> from each other.
>
> Any suggestions?
>
>
>
>
> TIA
> Alf
>
> ______________________________________________
> Alf R. Austrheim
> Network engineer
>
> NetCom GSM as
> Norway
>
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
