Merge polygons from two different layers in QGIS

Question

I have a layer with all buildings. Then I made a layer with buildings of interest from my part.

The problem is that a building of interest is made out of several polygons, but I want it as one polygon.

As in the picture I would like to have the entire building as one polygon. Is that possible? (I want the whole house in red)

I don't want this made for the entire layer, just the ones I find interesting.

Select the buildings of interest in the layer you created. Click the Edit icon (looks like a pencil) and then find the Merge Selected Features tool (either from the toolbar or from the Edit menu). This will merge your selected features. Or if you want it to look like a single polygon, you could run the Dissolve tool :) — Joseph, Commented Oct 12, 2017 at 9:22

Bera · Accepted Answer · 2018-05-30 08:28:08Z

2

Use:

select ST_Union (geom) as geom
From your_name_table
WHERE
id=... or id=...

(select id your sub polygons)

Bera

76.2k14 gold badges76 silver badges175 bronze badges

answered May 30, 2018 at 8:03

4,4678 gold badges15 silver badges46 bronze badges

Add a comment |

1 Answer 1