Yes, that's right. ST_Boundary will convert the polygon to [multi]linestrings which you can then use to extract the points.

These have examples that should help:
http://postgis.refractions.net/documentation/manual-svn/ST_PointN.html
http://postgis.refractions.net/documentation/manual-svn/ST_NPoints.html
http://postgis.refractions.net/documentation/manual-svn/ST_GeometryN.html

Mike, nice solution with your function.  Have to give that a try sometime.
-- Kevin

tommy408 wrote:
How can I extract points from all the vertex of a polygon?

I see there are ST_NPoints and ST_PointN for linestring.  But nothing for
polygons.  Maybe convert polygon to linestring then linestring to points?
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to