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 <pedrocostaa...@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to