[postgis-users] Split multi-linestrings

Andrea Peri 2007 aperi2007 at gmail.com
Wed Aug 19 07:24:03 PDT 2009

Hi Frank,

thx for suggestion.

I try with ST_Dump using:


But unfortunately it give me again all segments with only 2 vertex :(

So from 1 MultiLineString with 2 parts each with 20+ vertex give me many LineStrings with only 2 vertex each :(


>Hi Andrea,
>Have a look to ST_Dump

>>/ I try this code with postgis 1.4.0:
>//>/ ST_GeometryN(geom,generate_series(1,ST_NumGeometries(geom)))
>>/// But it return all LineStrings as simple segments with 2 only vertexs.


More information about the postgis-users mailing list