MapInfo Pro

Expand all | Collapse all

joining tables using geographics

  • 1.  joining tables using geographics

    Posted 09-17-2020 20:58
    Hi,

    Relatively new to MapInfo and spacial joins - I need to create a join between an existing .tab file that contains road segments from Confirm(linear features) and an existing layer containing road side trees(point features).

    I need to be able to link the existing layer objects to the relevant Confirm Site(Road segment) so I can import into Confirm.

    I assume it should look something like

    Select
    A.site_code,
    B.*
    From Table A(Confirm data), Table B (SSA data)
    Where A.obj intersects B.obj

    Is it that simple.?

    Tried using Select by Location (Within a Distance - used 10 metres), but that locked up MapInfo

    Thanks

    ------------------------------
    Stephen Perger
    Asset System Administrator
    Buloke Shire Council
    Wycheproof VIC
    ------------------------------


  • 2.  RE: joining tables using geographics

    Posted 09-18-2020 10:07
    maybe Where A.obj contains B.obj ??

    I'd probably actually buffer the streets, save that as a layer then check for trees within the buffers. 


    ------------------------------
    Martin Burroughs
    Oldham Council
    ------------------------------



  • 3.  RE: joining tables using geographics

    Posted 09-18-2020 11:28
    Stephen,

    Use the distance calculator tool.  It will create a new layer of lines from each point in the point table to the closest line segment from your line layer.  The browser for the results then contains the ID for the point and the ID for the road segment.

    HTH

    Nick

    ------------------------------
    Nick Hall
    Mapchester LTD
    nick.hall@mapchester.co.uk
    ------------------------------



  • 4.  RE: joining tables using geographics

    Posted 10-01-2020 02:50
    Nick,

    Thanks for the suggestion, works exactly as I needed and with multiple layers to align will make it easier.:)


    ------------------------------
    Stephen Perger
    Buloke Shire Council
    Wycheproof VIC
    ------------------------------