[mapserver-users] Mapserver Layer Filter

[Hawk AA]

Hi there, Mailing List,

 

We have a customer that wants their maps to be published online, but some of
the features is confidential and should not be displayed.

 

We have added following to the layer definition:

FILTER ('[type]' != "GRØFT ")

It works, the features with type GRØFT are not showed in the map.

 

However, we have a window that let the user browse the data, and it will be
possible to access the features of type GRØFT. When you press “show in map”,
the JavaScript clients triggers a WFS request with a filter asking for
elements with the current ID. By doing this, WFS omits the LAYER FILTER
definition, so the element can be showed in the map, even if it is of type
GRØFT. I need a way to make sure the WFS can’t deliver any data of type
GRØFT.

 

I’ve seen three possible solutions:

1.       We have a service that automatically converts uploaded MapInfo
*.TAB-files to SHP. If I am correct, I could use the “-where”-argument on
the ogr2ogr to filter data and only get features which does not have type
GRØFT. I hope I do not have to do this, since debugging and developing a
windows service is quite tricky.

2.       Add additional filter values to the WFS query. I could also define
the types not to show in the JavaScript, and let the application
automatically add <PropertyIsNotEqualTo>-tags to the AJAX query. This would
be less secure, and I need to define types not to show at two places.

3.       The best solution in my eyes is to let the magic happen in the
MAP-file, and that is mostly why I am posting here. Is there a way to add a
query to the Layer Data definition, like you do if you are querying a MSSQL
database? I can imagine a syntax like this:
CONNECTIONTYPE OGR
CONNECTION "TM_Nett/TM_Points"
DATA "SELECT * FROM tm_points WHERE type!=’GRØFT’”
It does not seem to work.

 

Any suggestions, especially regarding the third solution?

 

Best regards,

Håkon Åmdal

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120112/01b86ad6/attachment.htm>