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.

enter image description here

  • 4
    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
    Oct 12, 2017 at 9:22

1 Answer 1



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

(select id your sub polygons)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.