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

[Jörg Thomsen]

Am 15.04.2014 13:28, schrieb drobins:
> Hello Jörg,
> 
> I have tried to get the correct # of points in my query but it keeps
> returning me more than I have.
> There are 293 points in my table, yet the query shows 779 which also appear
> on my map.
> The 293 are the ones I want, the others seem to be the nodes from the
> polygons and/or lines. Is there a way to exclude these?

I am not sure what you are doing, in
select ST_CollectionExtract(geom, 1) as geom ...
the '1' is for poin-geomtries, (2 -> lines 3 -> polygons)

Jörg