[postgis-users] Split multi-linestrings

Fred Lehodey lehodey at gmail.com
Wed Aug 19 03:54:00 PDT 2009


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

Fred


On Wed, Aug 19, 2009 at 11:50 AM, Andrea Peri <aperi2007 at gmail.com> wrote:

> Hi,
>
> I have some troubles try-ing to split from a MultiLineString to
> LineStrings.
>
> 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.
>
> It seem the ST_NumGeometries(geom) return the count of all segments , not
> the parts.
>
> There a function that count the num of parts ?
>
> Many thx,
>
> Andrea Peri
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090819/bc40873c/attachment.html>


More information about the postgis-users mailing list