<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body 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:
<blockquote
cite="mid:CAGAwT=3VijMk_-kX5=yb_JetX5hB3i3Q-3mFJf9vgWWN_TCA7A@mail.gmail.com"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>