7
votes
Finding overlapping polygons within the same layer in QGIS
You can create a Virtual Layer with DB Manager which joins the table to itself on intersecting polygons, where the id isnt the same.
You need a unique identifier field, mine is named id. My layer is ...
- 67.1k
5
votes
Accepted
From Geodataframe to PostGIS
You shouldnt need dtype={'geom': Geometry(geometry_type='GEOMETRY', srid= 4326)}.
Try without it and use .to_postgis:
import geopandas as gpd
from sqlalchemy import create_engine
gdf = gpd.read_file(...
- 67.1k
4
votes
Finding overlapping polygons within the same layer in QGIS
You can use the expression
array_length(overlay_intersects(@layer,$id))>0
Either use it via Select by Expression or run it in Extract by Expression to create a new layer containing the overlapping ...
- 32.6k
4
votes
Finding overlapping polygons within the same layer in QGIS
I suggest you run join attributes by location, with both inputs being your polygon layer, using "overlap" as condition and discard all features which haven't been joined to something. Now ...
- 15.5k
4
votes
Finding overlapping polygons within the same layer in QGIS
You can use the Polygon Self-Intersection tool if you have SAGA installed.
Polygons: the input polygon layer
Identifier: the field name that you want to use to identify the intersected polygons.
...
- 40.3k
2
votes
Finding overlapping polygons within the same layer in QGIS
You can download the LF Tools plugin and run the Overlapping polygons tool.
I made a scratch layer with overlapping polygons (brown polygons) then ran the tool and it made a new layer of the parts ...
- 175
Only top scored, non community-wiki answers of a minimum length are eligible