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 _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users