Hello, Maybe you could simply try to merge every segment and make a dump of this unique multiline to keep only the ones which are simple lines.
Select st_dump(st_union(geom)) from mytable Hugues. -----Message d'origine----- De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Max Pyziur Envoyé : mercredi 5 septembre 2012 19:16 À : postgis-users@postgis.refractions.net Objet : [postgis-users] Retrieving linestring data between endpoints 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 p...@brama.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
