<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
i found the error. the parallels are a less then 3 meters...<br>
<br>
thanks<br>
<br>
<br>
<br>
Em 17-05-2012 16:43, Pedro Costa escreveu:
<blockquote cite="mid:4FB51CAC.3020908@sapo.pt" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<span id="result_box" class="" lang="en"><span class="hps">I'm
already tried</span> <span class="hps">this function</span> <span
class="hps">but with no</span> good <span class="hps">results</span><span>,</span>
<span class="hps">I do not understand</span> <span class="hps">why.</span><br>
<span class="hps">You can</span> <span class="hps">see an
example</span> <span class="hps">in the</span> <span
class="hps">attached image</span><span>.</span> <span
class="hps">The streets are</span> <span class="hps">red
lines</span><span>.</span> <span class="hps">The</span> <span
class="hps">parallel</span> <span class="hps">purple </span><span
class="hps">and</span> <span class="hps">what I want to</span>
<span class="hps">clear</span> <span class="hps">yellow.</span><br>
<br>
<span class="hps">Any idea</span> <span class="hps">?</span></span><br>
<br>
<br>
I tried the st_dwithin like this:<br>
<br>
<br>
create table street8 as (SELECT paralell.geom FROM parallel,street
WHERE st_dwithin(paralell.geom, streets.the_geom, 2.99 ))<br>
<br>
<br>
The 'line erros' that i want to delete are a less than 3 meters
from streets...<br>
<br>
<br>
thanks<br>
<br>
<br>
<br>
Em 17-05-2012 16:32, Nicolas Ribot escreveu:
<blockquote
cite="mid:CAGAwT=33Wm0Pti3m2KtpC-oBnBqrtuDO7q12T7yDGkOj5SFDSg@mail.gmail.com"
type="cite">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 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">
<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
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"
target="_blank">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></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<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>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
<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>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" 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>
</blockquote>
<br>
</body>
</html>