You should take a look at the second column or rewrite the query as
SELECT
St_AsText( St_CollectionExtract( geom, 1 )) AS geom,
element_type
FROM
v_elements;
But the whole query doesn't make much sense in your case as don't have any real
geometry collections. It doesn't filter your data but return an empty geometry
and MapServer will effectively drop those lines. This isn't very efficient, so
you should probably use something like
SELECT
St_AsText( geom ) AS geom,
FROM
v_elements
WHERE
GeometryType( geom ) = 'POINT'
AND
element_type = 'Voorziening';
However, the real problem is that the rendering engine implicitly converts the
geometry to something useful for the current layer type. See
http://mapserver.org/mapfile/layer.html regarding the layer's TYPE. So setting
TYPE=point doesn't filter out lines and polygons - it converts them. But since
points cannot be converted to lines or polygons, MapServer will skip them when
TYPE=line, effectively filtering your data. Because of this implicit conversion
you usually need to define a layer for each type. A very shortened version
might look something like (assuming your primary key of the v_elements table is
'ID' and SRID -1):
LAYER
NAME "elements_voorziening_point"
TYPE POINT
STATUS ON
CONNECTIONTYPE POSTGIS
CONNECTION "host=yourhostname dbname=yourdatabasename user=yourdbusername
password=yourdbpassword port=yourpgport"
DATA "geom FROM v_elements USING UNIQUE id USING SRID -1"
FILTER "GeometryType( geom ) = 'POINT' AND element_type = 'Voorziening'"
CLASS
...
END
END
HTH
> -----Ursprüngliche Nachricht-----
> Von: [email protected] [mailto:mapserver-users-
> [email protected]] Im Auftrag von drobins
> Gesendet: Dienstag, 13. Mai 2014 15:52
> An: [email protected]
> Betreff: Re: [mapserver-users] Mapserver shows all nodes on a
> GeometryCollection
>
> Hi Jukka,
>
> the queries don't show what they're supposed to show, they show more
> information than requested.
> I'm adding a few screenshots with the 3 different queries, each showing
> lines and points
>
> <http://osgeo-org.1560.x6.nabble.com/file/n5140004/moz-screenshot-14.png>
> <http://osgeo-org.1560.x6.nabble.com/file/n5140004/moz-screenshot-15.png>
> <http://osgeo-org.1560.x6.nabble.com/file/n5140004/moz-screenshot-16.png>
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/Re-
> Mapserver-shows-all-nodes-on-a-GeometryCollection-tp5138525p5140004.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> [email protected]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
