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
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
