[postgis-users] Spliting polygons to lines

David William Bitner david.bitner at gmail.com
Tue Oct 24 07:48:27 PDT 2006


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 at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061024/8ac05631/attachment.html>


More information about the postgis-users mailing list