[postgis-users] Help with line join

[strk at refractions.net]

On Sat, Dec 23, 2006 at 05:24:32PM -0600, Tim Keitt wrote:
> I have a coverage composed of linestrings. Because of mostly small gaps in
> the original digitizing, some of the linestrings belong together, but appear
> in separate rows of the database. It is simple to collect the geometries by
> grouping on a particular record in the table. Once I have the collection of
> linestrings, I then need to concatenate them together -- basically fill the
> gaps. Is there a function in postgis to accomplish that task? I've tried
> linemerge without success.

Linemerge will not fill the gaps. You might try adding cords between endpoints
using MakeLine, StartPoint and EndPoint. Then linemerge when the gaps are
filled. Good luck !

--strk;