[postgis-users] Multilinestring aggregates

Paragon Corporation lr at pcorp.us
Fri Mar 13 13:34:17 PDT 2009

ST_Dump is in general faster if you need to extract all the line strings


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of strk
Sent: Friday, March 13, 2009 3:04 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Multilinestring aggregates

On Fri, Mar 13, 2009 at 04:54:07PM +0100, Santiago Martin Alfageme wrote:

>  - Can I access to Linestrings inside a Multilinestring?

Yes, using GeometryN.

>  - If so, Can I assign attibutes (fields) to those Linestrings?

Nope, but you could work around this by adding an array column to your table
for each attribute you want to maintain, or normalizing using other tables.


 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple! 
postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list