<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1493211290283_5296"><span>Hi,</span></div><div id="yui_3_16_0_ym19_1_1493211290283_5393"><span><br></span></div><div id="yui_3_16_0_ym19_1_1493211290283_5325"><span>Greetings!</span></div><div id="yui_3_16_0_ym19_1_1493211290283_5330"><span><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5352"><span id="yui_3_16_0_ym19_1_1493211290283_5392">I hope this is a right platform to discuss my query regarding FILTER applied on MapServer WFS.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5547"><span id="yui_3_16_0_ym19_1_1493211290283_5392"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5354"><span id="yui_3_16_0_ym19_1_1493211290283_5384">I'm new in this area and exploring some features of MapServer. I want to use GetFeature request of WFS to get features applied on any location on map. I'm using "MapServer version 7.0.4 (MS4W 3.2.1)" and trying to apply filter "Contains" for it.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6638"><span id="yui_3_16_0_ym19_1_1493211290283_5384"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6639"><span id="yui_3_16_0_ym19_1_1493211290283_5384">I can see two problems when it applies Filter query on PostGIS:</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6845"><span id="yui_3_16_0_ym19_1_1493211290283_5384"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5522"><span id="yui_3_16_0_ym19_1_1493211290283_6861"><font id="yui_3_16_0_ym19_1_1493211290283_6862" color="#cd232c">1. </font></span><span id="yui_3_16_0_ym19_1_1493211290283_5384"><font id="yui_3_16_0_ym19_1_1493211290283_5983" color="#cd232c"><span id="yui_3_16_0_ym19_1_1493211290283_6863">It looks it adds an extra default geospatial filter in it while making a query to PostGIS. </span>This default spatial filter is not stopping to return any result from PostGIS. Is there any way to exclude this default filter?</font><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5521"><span id="yui_3_16_0_ym19_1_1493211290283_5384"><font id="yui_3_16_0_ym19_1_1493211290283_6188" color="#440062">2. It seems Contains coordinates are not transformed properly according to SRS of data in PostGIS.</font></span></div><div id="yui_3_16_0_ym19_1_1493211290283_5255"><div id="yui_3_16_0_ym19_1_1493211290283_5520"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_6689">I've tries with different projection in map file and request message with no success.<br></div><div id="yui_3_16_0_ym19_1_1493211290283_6688"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_6655">Supporting data to give your input on my queries:</div><div id="yui_3_16_0_ym19_1_1493211290283_6654"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_5911">WFS request</div><div id="yui_3_16_0_ym19_1_1493211290283_5989">*************************</div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5988">Formatted Version:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6302"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6294"><font id="yui_3_16_0_ym19_1_1493211290283_6831" size="1">http://localhost/cgi-bin/mapserv.exe?<br id="yui_3_16_0_ym19_1_1493211290283_6281">service=WFS&<br id="yui_3_16_0_ym19_1_1493211290283_6282">map=C:/Data/MapServerWFSSample.map&<br id="yui_3_16_0_ym19_1_1493211290283_6283">request=GetFeature&<br id="yui_3_16_0_ym19_1_1493211290283_6284">version=2.0.0&<br id="yui_3_16_0_ym19_1_1493211290283_6285">typeName=SampleLayer&<br id="yui_3_16_0_ym19_1_1493211290283_6286">FILTER=<Filter xmlns="http://www.opengis.net/ogc" xmlns:gml="http://www.opengis.net/gml" xmlns:ms="http://mapserver.gis.umn.edu/mapserver"><br id="yui_3_16_0_ym19_1_1493211290283_6287"> <<b>Contains</b>><br id="yui_3_16_0_ym19_1_1493211290283_6288"> <PropertyName>wkb_Geometry</PropertyName><br id="yui_3_16_0_ym19_1_1493211290283_6289"> <gml:Point srsName="urn:ogc:def:crs:EPSG::4326"><br id="yui_3_16_0_ym19_1_1493211290283_6290"> <gml:coordinates>0.112034,53.567972</gml:coordinates><br id="yui_3_16_0_ym19_1_1493211290283_6291"> </gml:Point><br id="yui_3_16_0_ym19_1_1493211290283_6292"> </<b id="yui_3_16_0_ym19_1_1493211290283_6811">Contains</b>><br id="yui_3_16_0_ym19_1_1493211290283_6293"></Filter></font><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6194">*************************</div><div id="yui_3_16_0_ym19_1_1493211290283_5987"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_5910">PostGIS query [Could see in log file]:</div><div id="yui_3_16_0_ym19_1_1493211290283_5909">*************************</div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5692"><font id="yui_3_16_0_ym19_1_1493211290283_6901" size="1">msPostGISLayerWhichShapes query: select "</font><font id="yui_3_16_0_ym19_1_1493211290283_6810" size="1"><font id="yui_3_16_0_ym19_1_1493211290283_6902" size="1">Attribute1</font>","Attribute2","Attribute3",encode(ST_AsBinary(ST_Force2D("wkb_geometry"),'NDR'),'hex') as geom from SampleGeoDataTable where <font id="yui_3_16_0_ym19_1_1493211290283_5908" color="#cd232c"><b id="yui_3_16_0_ym19_1_1493211290283_5855"><i id="yui_3_16_0_ym19_1_1493211290283_5854">wkb_geometry && ST_GeomFromText('POLYGON((-0.999462804873474 -1.00102606014116,-0.999462804873474 -1.00102606014116,-0.999462804873474 -1.00102606014116,-0.999462804873474 -1.00102606014116,-0.999462804873474 -1.00102606014116))',find_srid('','SampleGeoDataTable','wkb_geometry'))</i></b></font> and (st_contains(wkb_geometry,ST_GeomFromText('POINT (<font id="yui_3_16_0_ym19_1_1493211290283_5912" color="#440062"><b id="yui_3_16_0_ym19_1_1493211290283_5880"><i id="yui_3_16_0_ym19_1_1493211290283_5879">7853690.3631838141000000 -5506204.5232773330000000</i></b></font>)')) = TRUE)</font><br></div><div id="yui_3_16_0_ym19_1_1493211290283_5691">*************************</div><div id="yui_3_16_0_ym19_1_1493211290283_5689"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_5584">Similar WFS query to GeoServer works perfectly.<br></div><div id="yui_3_16_0_ym19_1_1493211290283_5583"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_5519">It would be very helpful if someone can help me on it. Thanks a lot in advance. <br></div><div id="yui_3_16_0_ym19_1_1493211290283_5511"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_6452">Map File looks like:</div><div id="yui_3_16_0_ym19_1_1493211290283_6453"><br></div><div id="yui_3_16_0_ym19_1_1493211290283_6698">**************************************************<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1493211290283_6595"><font id="yui_3_16_0_ym19_1_1493211290283_6788" size="1">MAP<br id="yui_3_16_0_ym19_1_1493211290283_6548"> NAME "Sample_WMS"<br id="yui_3_16_0_ym19_1_1493211290283_6549"> CONFIG "PROJ_LIB" "C:\ms4w\proj\nad"<br id="yui_3_16_0_ym19_1_1493211290283_6550"> CONFIG "MS_ERRORFILE" "C:/Data/ms_tmp/ms_error.txt"<br id="yui_3_16_0_ym19_1_1493211290283_6551"> CONFIG "CPL_DEBUG" "ON"<br id="yui_3_16_0_ym19_1_1493211290283_6552"> CONFIG "PROJ_DEBUG" "ON"<br id="yui_3_16_0_ym19_1_1493211290283_6553"> STATUS ON<br id="yui_3_16_0_ym19_1_1493211290283_6554"> PROJECTION<br id="yui_3_16_0_ym19_1_1493211290283_6555"> "init=epsg:27700"<br id="yui_3_16_0_ym19_1_1493211290283_6556"> END <br id="yui_3_16_0_ym19_1_1493211290283_6557"> <br id="yui_3_16_0_ym19_1_1493211290283_6558"> WEB<br id="yui_3_16_0_ym19_1_1493211290283_6559"> IMAGEPATH "C:/Data/ms_tmp/"<br id="yui_3_16_0_ym19_1_1493211290283_6560"> IMAGEURL "/ms_tmp/"<br id="yui_3_16_0_ym19_1_1493211290283_6561"> METADATA <br id="yui_3_16_0_ym19_1_1493211290283_6562"> "wfs_enable_request" "*"<br id="yui_3_16_0_ym19_1_1493211290283_6563"> "wfs_title" "My Global Map WFS Server"<br id="yui_3_16_0_ym19_1_1493211290283_6564"> "wfs_srs" "EPSG:4326 EPSG:900913 EPSG:27700"<br id="yui_3_16_0_ym19_1_1493211290283_6565"> "wfs_boundingbox" "EPSG:27700 749.099975585938 -90036.5 660460.875 1227306.5" <br id="yui_3_16_0_ym19_1_1493211290283_6566"> END<br id="yui_3_16_0_ym19_1_1493211290283_6567"> END<br id="yui_3_16_0_ym19_1_1493211290283_6568"> <br id="yui_3_16_0_ym19_1_1493211290283_6569"> LAYER<br id="yui_3_16_0_ym19_1_1493211290283_6570"> NAME "SampleLayer"<br id="yui_3_16_0_ym19_1_1493211290283_6571"> STATUS DEFAULT<br id="yui_3_16_0_ym19_1_1493211290283_6572"> TYPE POLYGON<br id="yui_3_16_0_ym19_1_1493211290283_6573"> PROJECTION<br id="yui_3_16_0_ym19_1_1493211290283_6574"> "init=epsg:27700"<br id="yui_3_16_0_ym19_1_1493211290283_6575"> END <br id="yui_3_16_0_ym19_1_1493211290283_6576"> CONNECTIONTYPE POSTGIS<br id="yui_3_16_0_ym19_1_1493211290283_6577"> CONNECTION "host=localhost port=5432 dbname=SampleGeoDataTable user=postgres password=hahaha"<br id="yui_3_16_0_ym19_1_1493211290283_6578"> DATA "wkb_geometry from SampleLayer"<br id="yui_3_16_0_ym19_1_1493211290283_6579"> CLASS<br id="yui_3_16_0_ym19_1_1493211290283_6580"> STYLE<br id="yui_3_16_0_ym19_1_1493211290283_6581"> COLOR 0 100 255<br id="yui_3_16_0_ym19_1_1493211290283_6582"> OUTLINECOLOR 0 0 0<br id="yui_3_16_0_ym19_1_1493211290283_6583"> END <br id="yui_3_16_0_ym19_1_1493211290283_6584"> END<br id="yui_3_16_0_ym19_1_1493211290283_6585"> <br id="yui_3_16_0_ym19_1_1493211290283_6586"> METADATA <br id="yui_3_16_0_ym19_1_1493211290283_6587"> "wfs_enable_request" "*"<br id="yui_3_16_0_ym19_1_1493211290283_6588"> "wfs_title" "Sample WFS"<br id="yui_3_16_0_ym19_1_1493211290283_6589"> "wfs_srs" "EPSG:27700 EPSG:4326 EPSG:900913"<br id="yui_3_16_0_ym19_1_1493211290283_6590"> "wfs_boundingbox" "EPSG:27700 749.099975585938 -90036.5 660460.875 1227306.5"<br id="yui_3_16_0_ym19_1_1493211290283_6591"> "gml_include_items" "all"<br id="yui_3_16_0_ym19_1_1493211290283_6592"> END <br id="yui_3_16_0_ym19_1_1493211290283_6593"> END <br id="yui_3_16_0_ym19_1_1493211290283_6594">END</font><br></div><div id="yui_3_16_0_ym19_1_1493211290283_6451" dir="ltr">**************************************************</div><div id="yui_3_16_0_ym19_1_1493211290283_5679"><br></div></div><div class="signature" id="yui_3_16_0_ym19_1_1493211290283_5310"><font id="yui_3_16_0_ym19_1_1493211290283_5566" size="2">Regards,<br>Kajod<br></font></div></div></body></html>