[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Spliting polygons to lines
From:       "David William Bitner" <david.bitner () gmail ! com>
Date:       2006-10-24 14:48:27
Message-ID: d2f53e190610240748q532bfb11y222ddfc3d8d6febc () mail ! gmail ! com
[Download RAW message or body]

The "cheating" way to go back and forth between Multilinestring and Polygon
is to just do a string replace on the AsText form:
geomfromtext(replace(astext(the_geom),'POLYGON','MULTILINESTRING'),-1) for
poly -> multiline

I think that there's a more elegant method in newer releases perhaps.


On 10/24/06, postgis <postgis@o2.pl> wrote:
>
>
> Hi list!
>
> Is there any way to split polygon into lines collection
> in postgis just using sql functions?
>
> Thanks in advance for reply
>
> Karol
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner

[Attachment #3 (text/html)]

The &quot;cheating&quot; way to go back and forth between Multilinestring and Polygon \
is to just do a string replace on the AsText form:<br>geomfromtext(replace(astext<div \
id="mb_1">(the_geom),'POLYGON','MULTILINESTRING'),-1) for poly -&gt; multiline  \
<br><br>I think that there's a more elegant method in newer releases \
perhaps.</div><br><br><div><span class="gmail_quote">On 10/24/06, <b \
class="gmail_sendername">postgis</b> &lt;<a href="mailto:postgis@o2.pl">postgis@o2.pl \
</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid \
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>Hi \
list!<br><br>Is there any way to split polygon into lines collection <br>in postgis \
just using sql functions?<br><br>Thanks in advance for \
reply<br><br>Karol<br><br><br>_______________________________________________<br>postgis-users \
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net"> \
postgis-users@postgis.refractions.net</a><br><a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br \
clear="all"> <br>-- <br>************************************<br>David William Bitner



[prev in list] [next in list] [prev in thread] [next in thread]