[postgis-users] Retrieving linestring data between endpoints

[Max Pyziur]

Greetings,

I'm trying to figure out a way of constructing linestrings between 
endpoints.

Shapefile data for pipelines and railroads does not present continuous 
lines; instead they are in the form of small line segments. The 
applications are using data for roads, pipelines, or railroads.

Interstate 70 is not one complete linestring between Washington DC and the 
middle of Utah; instead it is a series of segments. The same with pipeline 
and railroad data.

The problem becomes more cumbersome (at least to me) when there is no 
knowledge of the data between two points (say Edmonton and Vancouver) and 
you want to see if there is a way to string a set of segments between two 
points (to answer a question like is there a railline between Edmonton and 
Vancouver)?

I would appreciate any advice on how to proceed.

Much thanks,

Max Pyziur
pyz at brama.com