MapInfo Pro

Can you combine two tables of polygon objects (land parcels & Suburb areas) into one table. Then using SQL select extract one suburb and land parcels within the suburb and output table displays both land parcels and suburb polygons?

Hi Larry,

Yes you can do it. Open both the tables. Go to the Table ribbon and use the functions "Append Rows" to combine both these polygon tables. You can then open this mapper window and perform the sql query.

Regards,

Shweta

 

Added the snapshot for it. Hope this helps!

Hi Larry,

Not quite sure if I am interpreting your requirements correctly here, but the MapInfo Pro 'Combine' feature allows you to combine multiple objects within a table to form a single object e.g. combining a map of multiple territories or states into a single boundary (polygon) object.

 

The 'SQL Select' feature can be used to select records from two tables where an object from one contains an object from the other etc. It can produce a query table as an output table which meets the conditions such as the one described above.

 

It may be helpful if you could provide some more detailed clarification about what your exact requirements and end goal is? Some more details about your current datasets that you are working with may also help for us to visualize what you are trying to do.

Thanks

Hi @Larry Mahn? If I get your question correctly, You can use

1. Append rows
2. Combine feature
3. Within option from SQL select

to combine objects from multiple tables.

This is the right tutorial with step by step process to combine two non-spatial tables. You can do the same process using WITHIN function in SQL select for spatial tables

https://gis.stackexchange.com/questions/217104/joining-two-tables-by-selection-from-one-table-in-mapinfo

Hi Shweta, Thanks for replying. The combine and the then Append rows worked a treat. I thought you could only append rows to tables with identical structures. Thanks again for the quick response. Cheers Larry

Hi Dave, My question was a bit unclear but you got it right using the combine and then Append rows got what I needed. Thanks Larry

Hi Krishna, Thanks for your solution it was just what I needed. Cheers Larry