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

Hi all, I figured I'd post it here as well as a new thread was opened earlier: See: http://osgeo-org.1560.x6.nabble.com/Re-Mapserver-shows-all-nodes-on-a-GeometryCollection-td5138525.html Hi Andreas, I took your layer filter and tried that. Yours gave me an error, so I adjusted it to this: FILT

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

Hi Andreas, I took your layer filter and tried that. Yours gave me an error, so I adjusted it to this: FILTER (GeometryType( geom ) = 'POINT' AND "element_type" = 'Voorziening') This fixed the problem! The layer is only showing the points now that are supposed to be shown and no longer shows the

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

gliche Nachricht- > Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- > boun...@lists.osgeo.org] Im Auftrag von drobins > Gesendet: Dienstag, 13. Mai 2014 15:52 > An: mapserver-users@lists.osgeo.org > Betreff: Re: [mapserver-users] Mapserver shows all nodes on a

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

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

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 an

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

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

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

I'll look a bit deeper into it when I have a bit more time available and try it the way you suggest by building the WMS from scratch. I'm not sure if I can use the shape file as source, because the geometry is linked to a variety of postgres tables to supply the geometry with administrative data.

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

moin, I don't see anything, that could cause the problem. Your architecture is hard to understand without knowing the whole structure, viewing the reuslts and access to the database. In my mapserver and postgis trainings I'm always telling the participants you *can* mix geometry-types and in in mo

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

Hi Jörg, I have lines, points and polygons stored in my table. The table has various columns, one which I filter the elements on (element_type). One of those elements is a "Voorziening", but Voorziening has points, lines and polygon objects. My LINE layer works fine. It only displays the lines on

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

hm.. - lines and points are stored in the same table you said? - do you get the correct result if you do the data-query in postgis / pgadmin? - what happens if you use your point-shape-file as data-source in mapserver? - if you only request the line-layer the points don't appear? - could you post

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

Let my add a screenshot from my problem I have 2 layers enabled in my map: a point layer and a line layer. The line layer works correct. The point layer shows points that are not in my source data (shape file which I inserted into post

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

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

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

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 the

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

-- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapserver-shows-all-nodes-on-a-GeometryCollection-tp5135064p5135112.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserve

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

Hello, correct. MapServer does not check the geometry-type, you can visualize a polygon-layer as points showing the vertices for example. If you only want to show the points of your geometry-colletcion, you have to select the points of your geometry only: select ST_CollectionExtract(geom, 1) as

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

Hello, I am loading a point LAYER in mapserver which requests data from a geometrycollection table from my PostGIS database. The table has point, line and polygon objects. Whenever I enable my point layer, it also displays all nodes from the lines and polygons. When loading the same table into QG