gis:postgresql-postgis-notes
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next 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/01/23 12:48] Ilias Iliopoulos [Locate the points of a Point layer that are outside polygons of a Polygon layer] |
||
|---|---|---|---|
| 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: | ||
gis/postgresql-postgis-notes.txt ยท Last modified: 2024/02/02 21:49 by Ilias Iliopoulos