MapInfo Pro

 View Only

  • 1.  Overlap Region

    Posted 07-09-2025 15:48

    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
    ------------------------------


  • 2.  RE: Overlap Region

    Employee
    Posted 07-14-2025 02:04

    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
    ------------------------------

    Original Message