Friday, 25 September 2015

Postgis identify points on the polygon border


I have points geom in gid,pt_geom and polygon geom in gid,pl_geom. Some of the points are inside polygon and some are outside polygon, others are on the polygon boundary.


enter image description here



Is there any way to identify those points on the polygon by using PostGIS functions (e.g. ST_contains() or ST_Distance())?


Maybe Select points.gid from points inner join polygon on st_contains(polygon.the_geom,points.the_geom).




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...