[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

http://postgis.refractions.net/documentation/manual-svn/ST_Dump.html 

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

--strk;

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






More information about the postgis-users mailing list