[postgis-users] Split multi-linestrings

[Ben Madin]

Thanks Fred,

I have also had this problem, but I don't understand how to handle the  
'set' that is returned.

I don't seem to be able to split out each LINESTRING into its own row.  
Is there a way to do this or handle the 'set' output?

(It may just be incorrect programming on my part, but I have tried all  
the examples from the documents, and get a geometry 'set' - I just  
can't do anything with it!)

cheers

Ben




On 19/08/2009, at 6:54 PM, Fred Lehodey wrote:

> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au



							Out here, it pays to know...


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090819/db3f1fda/attachment.html>