<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Stanley<br>
<br>
Thank you<br>
But your query merge two contiguous lines but not 3 or more contiguous
lines...<br>
<br>
Martin<br>
<br>
Sufficool, Stanley a écrit :
<blockquote
cite="mid:C2F174F99918D54CA2A96E57C5079B6F01827674@sbc-exmsg2.sbcounty.gov"
type="cite">
<pre wrap="">Does this look correct?
select st_linemerge(st_collect(cs1.the_geom))
from (
select the_geom, st_startpoint(cs_s.the_geom) as linepoint
from mylinetable cs_s
UNION ALL
select the_geom, st_endpoint(cs_e.the_geom) as linepoint
from mylinetable cs_e
) as cs1
group by linepoint
having count(*) = 2
</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On
Behalf Of Martin Fafard
Sent: Tuesday, October 06, 2009 11:21 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Merge lines
Hi
Is there a way to merge lines that are contiguous but stop
merging at an
intersection?
I have join an image.
Thank you
Martin F
</pre>
<pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
Version: 8.5.420 / Virus Database: 270.14.4/2417 - Release Date: 10/06/09 06:50:00
</pre>
</blockquote>
</blockquote>
</body>
</html>