[postgis-users] function from multilinestring to linestring

Markus Schaber schabi at logix-tt.com
Thu Apr 20 05:06:33 PDT 2006


Hi, Toni,

toni hernnadez wrote:

> Is there any way to convert a multilinestring object to linestring?

Not generally, as a LineString contains exactly _one_ sequence of
connected points, and a MultiLineString can contain more of them.

For some corner cases (e. G. adjacent or overlapping LineStrings) you
can try LineMerge() or GeomUnion() to connect the pieces together.

The first LineString in a MultiLineString can be fetched via
GeometryN(yourlinestring,1).


HTH,
Schabi
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org



More information about the postgis-users mailing list