Hi,

Could you possibly show us the whole LAYER from your mapfile and one 
GeometryCollection as WKT? Perhaps someone gets interested in making some 
trials.

Do you feel that there is something odd with your sample SQL? For me it looks 
like your GeometryCollection has one point, one linestring and one polygon and 
your query correctly finds them all one by one.

-Jukka Rahkonen-

drobins wrote:
> 
> Hi Jörg,
> I did some research:
> the query
> select st_astext (ST_CollectionExtract ('POINT (0 0)', 3)); returns "Polygon
> empty"
> select st_astext (ST_CollectionExtract ('POINT (0 0)', 2)) returns "Empty 
> String
> Line"
> select st_astext (ST_CollectionExtract ('POINT (0 0)', 1)) returns "POINT 
> (0,0)
> 
> So far so good
> 
> However, the query's
> select ST_AsText (geom), ST_CollectionExtract (geom, 1) select ST_AsText
> (geom), ST_CollectionExtract (geom, 2) select ST_AsText (geom),
> ST_CollectionExtract (geom, 3) returns all the same results "POINT 
> (137237.8268
> 431571.3851)"
> "LINE STRING (136944.606800001 431208.568799999,136987.418099999
> 431205.513900001)"
> "POLYGON ((138960.872299999 438028.947000001,138954.046100002
> 438015.9692,138951.5854 438017.2392,138953.609499998
> 438022.398600001,138962.5392 438042.0042,138973.612100001
> 438066.173999999,138977.8189 438064.507100001,138970.0799
> 438048.711399999,138960.872 (...)"
> 
> Any of this rings a bell perhaps?
> 
> 
> 
> --
> View this message in context: http://osgeo-
> org.1560.x6.nabble.com/Mapserver-shows-all-nodes-on-a-GeometryCollection-
> tp5135064p5138520.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to