[postgis-users] break lines at intersections

[Nicolas Ribot]

Hi Pedro,

select (st_dump(st_union(geom))).geom from lines;

will cut your network of lines at intersections.

Nicolas

On 17 May 2012 11:57, Pedro Costa <pedrocostaarma at sapo.pt> wrote:

> does anyone know how I can cut the lines at intersectionslike the image
> attached?
>
> I can´t install postgis 2.0 for now....
>
> I see a few examples with st_union and st_dump but i don't understand...
>
>
> Thanks
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120517/f4b2ff65/attachment.html>