<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Be aware that Points have only an interior, not a boundary. So
ST_Touches(line, point) is only true if the point coincides with an
endpoint of the line. <br>
<br>
Perhaps ST_Touches(s1.geom, s2.geom) might produce some results?<br>
<br>
<div class="moz-cite-prefix">On 1/11/2013 4:20 PM, Clifford Snow
wrote:<br>
</div>
<blockquote
cite="mid:CADAoPLpSEFSQ6EGjeq4X0uan7YNudvjwVgdGF=JDp_oDfghY4Q@mail.gmail.com"
type="cite">
<div dir="ltr">First off, I'm a new at Postgis so please let me
know if the right response to my question is RTFM.
<div><br>
</div>
<div>I have the NHD streams for my state that I want to import
into OpenStreetMap. When I select just the streams that I'm
interested in I find that there are numerous short linestrings
(2 nodes) that I'd like to get rid of. These linestrings are
only connected at one end. It seems like ST_Touches() would
find them. I did a simple query of</div>
<div><br>
</div>
<div>SELECT s1.gid, s2.gid from flowlines s1, flowlines s2 WHERE
ST_Touches(s1.geom,ST_PointN(s2.geom,1) and s2.pointcount = 2;</div>
<div><br>
</div>
<div>It returns 0 rows. Changing the point on s2.geom to 0 makes
no difference. </div>
<div><br>
</div>
<div>Anyone have a suggestion of how I find 2 node streams that
connect to another stream? <br clear="all">
<div><br>
</div>
-- <br>
<div>Clifford</div>
<div><br>
</div>
<div>OpenStreetMap: Maps with a human touch</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<p class="" avgcert""="" color="#000000" align="left">No virus
found in this message.<br>
Checked by AVG - <a moz-do-not-send="true"
href="http://www.avg.com">www.avg.com</a><br>
Version: 2013.0.2805 / Virus Database: 2637/6000 - Release Date:
12/31/12<br>
Internal Virus Database is out of date.</p>
</blockquote>
<br>
</body>
</html>