Skip to main content
6 of 7
Tiny adjustments
Taras
  • 34k
  • 4
  • 73
  • 148

Tested on QGIS 2.18

I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...

Let's assume we have two layers, namely "lines_test" and "polygons"

Input

With using this query you may achieve the result you are looking for.

SELECT *
FROM polygons
WHERE polygons.id NOT IN (
    SELECT polygons.id
    FROM polygons, lines_test
    WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
)

Output


References:

Taras
  • 34k
  • 4
  • 73
  • 148