In QGIS I'm trying to dissolve an intersection and keep only the features with the bigger area [blue arrow] (compared with other features with same id [red box]). I'm interested in keeping other information (in my example picture marked in yellow)

Example of the table

The intersection resolutes from a buffer of a polyline (coastline) with 1 km segments and a polygon. I want to transfer information from the polygon to the coastline for each segment of the polyline. But I want to transfer the information of the polygon sharing the biggest intersected area with the buffer.

Would be amazing if there is a way to do this using the graphical modeller.


1 Answer 1


You can use a Virtual Layer:

(Change islands to the name of your layer)

select islands.*
from islands
inner join
    (select id, max(area) as maxarea from islands group by id) as maxarea
on islands.id = maxarea.id
and islands.area=maxarea.maxarea

enter image description here


  • Hey, thanks a lot for replying. Just by replacing islands by the name of my layer i get a invalid layer.
    – Jarrid
    Commented Apr 4, 2022 at 13:52

Your Answer

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

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