<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Verdana; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=998305618-11102009><FONT color=#0000ff
face=Arial>Oops didn't see this question. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=998305618-11102009><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=998305618-11102009><FONT color=#0000ff
face=Arial>If you have multipolygons use ST_Dump instead. So something
like</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=998305618-11102009><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=998305618-11102009><SPAN lang=EN>
<P><FONT color=#0000ff face=Arial>SELECT <SPAN class=998305618-11102009>gid
As poly_id, path[1] As ring_num, </SPAN>n As <SPAN
class=998305618-11102009>point_</SPAN>id, ST_PointN(<SPAN
class=998305618-11102009>geom</SPAN>,n) As the_geom </FONT></P>
<P><FONT color=#0000ff face=Arial></FONT> </P>
<P><FONT face=Arial><FONT color=#0000ff>FROM (SELECT <SPAN
class=998305618-11102009>gid, </SPAN><SPAN
class=998305618-11102009>(</SPAN><SPAN class=998305618-11102009>ST_Dump(
</SPAN><SPAN class=998305618-11102009>ST_Boundary(the_geom)
) ).*</SPAN></FONT></FONT></P>
<P><SPAN class=998305618-11102009> FROM sometable) </SPAN></P>
<P><SPAN class=998305618-11102009></SPAN> As foo</P>
<P><FONT color=#0000ff face=Arial>CROSS JOIN generate_series(1, 10000) As n
WHERE n < ST_NPoints(geom)</FONT></P>
<P><FONT color=#0000ff face=Arial></FONT> </P>
<P><FONT color=#0000ff face=Arial></FONT> </P>
<P><SPAN class=998305618-11102009><FONT color=#0000ff face=Arial>NOTE: the
ST_Dump will give you 2 fields geom, and path which is an
array</FONT></SPAN></P></SPAN></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Randall, Eric<BR><B>Sent:</B> Sunday, October 11, 2009 10:53
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B> Re:
[postgis-users] what if my table contain multipolygon<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT color=#0000ff face=Arial> </FONT>
<DIV><SPAN class=214203414-11102009><FONT color=#0000ff face=Arial>Then maybe
use ST_geometryn to get a single polygon such as</FONT></SPAN></DIV>
<DIV><FONT color=#0000ff face=Arial></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial>select generate_series(1,
ST_npoints(geom)-1) as point_id , ST_pointn(ST_exteriorring(<SPAN
class=214203414-11102009>ST_geometryn(</SPAN>geom<SPAN
class=214203414-11102009>,1</SPAN>)<SPAN
class=214203414-11102009>)</SPAN>,generate_series(1, ST_npoints(geom)-1)) as
geom from polygontable</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial></FONT> </DIV>
<DIV><SPAN class=910105114-11102009><FONT color=#0000ff
face=Arial>-Eric</FONT></SPAN></DIV>
<DIV><FONT color=#0000ff face=Arial></FONT> </DIV></DIV>
<DIV> </DIV>
<P><FONT face=Tahoma>-----<BR><B>From:</B> eehab hamzeh
[mailto:eehab40@hotmail.com]<BR><B>Sent:</B> Sunday, October 11, 2009 9:33
AM<BR><B>To:</B> Randall, Eric<BR><B>Subject:</B> what if my table contain
multipolygon<BR><BR></FONT></P>
<BLOCKQUOTE>thanks eric for your replay<BR><BR>What if my table contain
multipolygon <BR>how can i adjust the sql statement<BR><BR>select
generate_series(1, ST_npoints(geom)-1) as point_id ,
ST_pointn(ST_exteriorring(geom),generate_series(1, ST_npoints(geom)-1)) as
geom from polygontable .<BR><BR>Kind regards<BR><BR><BR><BR><IMG alt=""
NOSEND="1"><IMG alt="" NOSEND="1"><IMG alt="" NOSEND="1"><BR><BR><BR>
<HR>
Windows Live: <A
href="http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010"
target=_new>Friends get your Flickr, Yelp, and Digg updates when they e-mail
you.</A> </BLOCKQUOTE></BODY></HTML>