This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
gis:postgresql-postgis-notes [2024/01/23 11:50] Ilias Iliopoulos [Locate the points of a Point layer that are outside polygons of a Polygon layer] |
gis:postgresql-postgis-notes [2024/02/02 21:49] (current) Ilias Iliopoulos |
||
---|---|---|---|
Line 95: | Line 95: | ||
</code> | </code> | ||
- | ===== Locate the points of a Point layer that are outside polygons of a Polygon layer ===== | + | ===== Identify the points of a Point layer that are outside polygons of a Polygon layer ===== |
There are multiple queries that you can use to solve this problem. You can find an interesting discussion in [[https://gis.stackexchange.com/questions/376234/find-polygons-that-has-no-points-in-postgis|Find polygons that has no points in PostGIS]]. For big data sets, I have found that the query that executes in the shortest time is: | There are multiple queries that you can use to solve this problem. You can find an interesting discussion in [[https://gis.stackexchange.com/questions/376234/find-polygons-that-has-no-points-in-postgis|Find polygons that has no points in PostGIS]]. For big data sets, I have found that the query that executes in the shortest time is: | ||
Line 136: | Line 136: | ||
</code> | </code> | ||
+ | |||
+ | ~~DISQUS~~ |