Stanley
Thank you
But your query merge two contiguous lines but not 3 or more contiguous
lines...
Martin
Sufficool, Stanley a écrit :
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
-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.420 / Virus Database: 270.14.4/2417 - Release Date: 10/06/09 06:50:00
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
