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.
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