MapInfo Pro

Is there a function I can use that can help me merge these smaller polygons to the polygon they contain within? 

I've used something like Union in ArcGIS, but I'm trying to find a solution on MapInfo that would do the same? Since there are many of these scattered throughout the tab file, I don't want want to manually combine selected objects. 

Also, theres no similar ID I can use to merge them either, so it would have to be something like a spatial join.



------------------------------
Fanny Chan

------------------------------

Hi Fanny

Are the smaller polygons fully contained in the bigger polygons?
Do you need to combine them or could you just delete them?

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

Original Message:
Sent: 09-28-2022 15:52
From: Fanny Chan
Subject: Smaller polygons within polygon

Is there a function I can use that can help me merge these smaller polygons to the polygon they contain within?

I've used something like Union in ArcGIS, but I'm trying to find a solution on MapInfo that would do the same? Since there are many of these scattered throughout the tab file, I don't want want to manually combine selected objects.

Also, theres no similar ID I can use to merge them either, so it would have to be something like a spatial join.



------------------------------
Fanny Chan

------------------------------

I would like to delete them since they are empty.

------------------------------
Fanny Chan
Knowledge Community Shared Account
------------------------------

Original Message:
Sent: 09-29-2022 03:08
From: Peter Møller
Subject: Smaller polygons within polygon

Hi Fanny

Are the smaller polygons fully contained in the bigger polygons?
Do you need to combine them or could you just delete them?

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

Original Message:
Sent: 09-28-2022 15:52
From: Fanny Chan
Subject: Smaller polygons within polygon

Is there a function I can use that can help me merge these smaller polygons to the polygon they contain within?

I've used something like Union in ArcGIS, but I'm trying to find a solution on MapInfo that would do the same? Since there are many of these scattered throughout the tab file, I don't want want to manually combine selected objects.

Also, theres no similar ID I can use to merge them either, so it would have to be something like a spatial join.



------------------------------
Fanny Chan

------------------------------

I wonder if you can select them all by size. They all look way smaller than the polygons they lie inside.

Can you try to run a query like this from the Simple Select dialog

Select your table from the Select Records from Table list and paste this condition into the that Satisfy: field: Area(obj, "sq m") < 1000

You might have to change the size (1000) to a value that matches the sizes of your small polygons.

You can also use the SQL Window if you prefer:
Select *
From Polygons
Where Area(Obj, "sq m") < 1000
Into Selection

Replace Polygons with the name of your table


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

Original Message:
Sent: 09-29-2022 10:23
From: Fanny Chan
Subject: Smaller polygons within polygon

I would like to delete them since they are empty.

------------------------------
Fanny Chan
Knowledge Community Shared Account

Original Message:
Sent: 09-29-2022 03:08
From: Peter Møller
Subject: Smaller polygons within polygon

Hi Fanny

Are the smaller polygons fully contained in the bigger polygons?
Do you need to combine them or could you just delete them?

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

Original Message:
Sent: 09-28-2022 15:52
From: Fanny Chan
Subject: Smaller polygons within polygon

Is there a function I can use that can help me merge these smaller polygons to the polygon they contain within?

I've used something like Union in ArcGIS, but I'm trying to find a solution on MapInfo that would do the same? Since there are many of these scattered throughout the tab file, I don't want want to manually combine selected objects.

Also, theres no similar ID I can use to merge them either, so it would have to be something like a spatial join.



------------------------------
Fanny Chan

------------------------------

Hi Fanny and Peter,

If they are "empty", perhaps they can be selected by attribute?

However, they look like text object to me.  In that case, they can be selected via the following SQL (using the MapBasic or SQL Window):

Select *
From Polygons
Where str$(obj)="text"
Into Selection

Then delete the selection.

If they are not text objects they might be labels?  Try turning labels off for that layer.

------------------------------
James Nolet
Dooley Mitchell & Morrison Pty Ltd
Mentone, VIC, Australia
------------------------------

Original Message:
Sent: 09-30-2022 03:43
From: Peter Møller
Subject: Smaller polygons within polygon

I wonder if you can select them all by size. They all look way smaller than the polygons they lie inside.

Can you try to run a query like this from the Simple Select dialog

Select your table from the Select Records from Table list and paste this condition into the that Satisfy: field: Area(obj, "sq m") < 1000

You might have to change the size (1000) to a value that matches the sizes of your small polygons.

You can also use the SQL Window if you prefer:
Select *
From Polygons
Where Area(Obj, "sq m") < 1000
Into Selection

Replace Polygons with the name of your table

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

Original Message:
Sent: 09-29-2022 10:23
From: Fanny Chan
Subject: Smaller polygons within polygon

I would like to delete them since they are empty.

------------------------------
Fanny Chan
Knowledge Community Shared Account

Original Message:
Sent: 09-29-2022 03:08
From: Peter Møller
Subject: Smaller polygons within polygon

Hi Fanny

Are the smaller polygons fully contained in the bigger polygons?
Do you need to combine them or could you just delete them?

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

Original Message:
Sent: 09-28-2022 15:52
From: Fanny Chan
Subject: Smaller polygons within polygon

Is there a function I can use that can help me merge these smaller polygons to the polygon they contain within?

I've used something like Union in ArcGIS, but I'm trying to find a solution on MapInfo that would do the same? Since there are many of these scattered throughout the tab file, I don't want want to manually combine selected objects.

Also, theres no similar ID I can use to merge them either, so it would have to be something like a spatial join.



------------------------------
Fanny Chan

------------------------------