Martin,
You need to create Voronoy pologons based on your first table. These
pologons represent an area around each datapoint in which this particular
datapoint is the closed point. After you have done this you can check in
which polygon the points from your other table fall. If you know this you
also know which point from your first table is closest.....
Sorry.. but to my knowledge MapInfo doen't supply this functionality. But I
could send you a copy of our new Triangulator (beta version) that could do
the trick for you.
Regards,
Roeland
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: Mapinfo-l <[EMAIL PROTECTED]>
Sent: Tuesday, April 18, 2000 7:56 AM
Subject: MI Point in one table nearest point in another?
> Hi folks
>
> I have a table of geocoded address points and another table containing
> geocoded points 1km apart (ie a grid) with individual values attached to
> each point.
>
> I've been trying to work out a way of finding out what grid point from the
> second table (and hence its value) is closest to a geocoded address in the
> first table. I tried buffering the address points and looking for grid
> points within the buffers but that wouldn't give me an answer. Is there a
> SQL statement I can use that asks for obj in table 2 closest to obj in
> table 1?
>
> thanks for your assistance
>
> Martin Gilbert
> Commonwealth Department of Health & Aged Care
> Canberra, Australia
>
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
