[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

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