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