[postgis-users] break lines at intersections

[Pedro Costa]

Great Nicolos, works...

It is possible select lines from one table a less than 3 meters from 
lines from another table?and delete them...

thanks


Em 17-05-2012 15:41, Nicolas Ribot escreveu:
> 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 
> <mailto: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
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> 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/a8732516/attachment.html>