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]

Reply via email to