MapInfo Pro Developers User Group

 View Only
  • 1.  Overlapped polylines finding in mapinfo tables

    Posted 01-18-2022 02:21
      |   view attached
    Hi There,

    Thanks in advance for your response.

    I have two tables in mapinfo.1) PVC pipes 2) Power lines. Both are polylines and overlapping each other.
    Now I want to find out how many power lines id's are overlapped with each PVC pipes or each powerline overlapped with how many PVC pipes id's in a new table.

    I have attached screen for reference. for reference and how output needs to be like.

    Thank you.

    ------------------------------
    Venu I
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Overlapped polylines finding in mapinfo tables

    Posted 01-18-2022 21:36
    Hi Venu,
    I am assuming that all spatial information in both datasets are coincident.
    I would use a simple SQL spatial query as shown below:
    The only difference to the structure of the output you have specified is that Power6ab is above Power8ab.

    Cheers,

    ------------------------------
    David Murphy
    SWAN HILL RURAL CITY COUNCIL
    Swan Hill VIC
    ------------------------------



  • 3.  RE: Overlapped polylines finding in mapinfo tables

    Posted 01-20-2022 03:00
    Hi David,

    Thanks a lot for your reply. with the above SQL query my issue is resolved to find required output.

    Regards
    Venu

    ------------------------------
    Venu I
    Knowledge Community Shared Account
    ------------------------------