[Qgis-user] Check intersection of polygons and points with same value in ID field.

Philip Barlow philipb at pembrokeshirecoast.org.uk
Wed May 17 06:44:15 PDT 2017


SQL?

If you are using shapefile you can use virtual layers if you are on QGIS 2.14+ or pop the layers into a spatialite DB.

And query thus:

SELECT **columns**
FROM **tables**
WHERE ST_Intersects(geom1, geom2) AND id1=id2;


Phil


-----Original Message-----
From: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of sinorfavela
Sent: 17 May 2017 13:03
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Check intersection of polygons and points with same value in ID field.

Hi there!

I need to check if the features of a polygon shape intersect with the features of a points shape with share the same value in their ID field. In other word, if the polygon with ID "54" intersect with the point with ID "54" and so on with all the features.

¿Any idea? I guess that could probably made with the field calculator, but I cannot figure out how to build it.

Thanks in advance!



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Check-intersection-of-polygons-and-points-with-same-value-in-ID-field-tp5320809.html
Sent from the QGIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




More information about the Qgis-user mailing list