[mapserver-users] Mapserver shows all nodes on a GeometryCollection

[Rahkonen Jukka (Tike)]

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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users