[postgis-users] Retrieving linestring data between endpoints

Max Pyziur pyz at brama.com
Wed Sep 5 10:15:38 PDT 2012


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

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 

I would appreciate any advice on how to proceed.

Much thanks,

Max Pyziur
pyz at brama.com

More information about the postgis-users mailing list