MapInfo Pro

Hi,

I have MapInfo Table with a Store List that has ID as a unique identifier. I have created buffers around each store. I want to get the Overlap Regions MapInfo Table between different Buffers with Table values as ID(Buffer's Parent Store), ID2 (ID of overlapping Store). Can anyone help me on it.

Thanks

------------------------------
Navjot Kandhola
Senior Analyst
LOBLAWS INC
BRAMPTON ON
------------------------------

Hey Navjot

Try this:

1. Make a copy of your StoreBuffer table.

2. Now run this query:

Select StoreBuffer.ID, StoreBufferCopy.ID
From StoreBuffer, StoreBufferCopy
Where StoreBuffer.OBj Intersects StoreBufferCopy.OBJ
And StoreBuffer.ID <> StoreBufferCopy

3. The resulting query table shows you the overlap between stores

The join condition finds the buffers that overlap between the two tables and also ensure that the two records overlapping doesn't have the same ID.

Cheers

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------