[postgis-users] polygon points

Guido Lemoine guido.lemoine at jrc.it
Tue Oct 18 00:27:54 PDT 2005


Try:

  select pointn(ExteriorRing(polygon_geom), n) from poly_table

and loop through n (1 .. npoints(ExteriorRing(polygon_geom))

Extend to interiorrings, if relevant. Use the X() function to get at the
X-coordinate to check.

GL

Frances Collier wrote:

> Hello all,
>
>  
>
> Is there a function that can get the individual points from a polygon 
> geometry? I am trying to find all the points in the wkb_geometry that 
> matches with a particular X value.
>
>  
>
> Thank you for any help.
>
> -Frances Collier
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>



More information about the postgis-users mailing list