[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:

(ST_Dump(geom)).geom 

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 :(


Andrea.

>Hi Andrea,
>Have a look to ST_Dump
>http://postgis.refractions.net/docs/ST_Dump.html
>
>Fred

>>/ 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