Yes, it should be:<div>st_dwithin will help you to find all lines from a table within a certain distance to other lines.</div><div><br></div><div>Nicolas<br><div><br><div class="gmail_quote">On 17 May 2012 17:23, Pedro Costa <span dir="ltr"><<a href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Great Nicolos, works...<br>
<br>
It is possible select lines from one table a less than 3 meters from
lines from another table?and delete them...<br>
<br>
thanks<br>
<br>
<br>
Em 17-05-2012 15:41, Nicolas Ribot escreveu:
<div><div class="h5"><blockquote type="cite">Hi Pedro,
<div><br>
</div>
<div><font face="'courier new', monospace">select
(st_dump(st_union(geom))).geom from lines;</font></div>
<div><br>
</div>
<div>will cut your network of lines at intersections.</div>
<div><br>
</div>
<div>Nicolas<br>
<br>
<div class="gmail_quote">On 17 May 2012 11:57, Pedro Costa <span dir="ltr"><<a href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
does anyone know how I can cut the lines at
intersectionslike the image attached?<br>
<br>
I canīt install postgis 2.0 for now....<br>
<br>
I see a few examples with st_union and st_dump but i don't
understand...<br>
<br>
<br>
Thanks<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div></div>