[mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource
Hi List, I'm experiencing a strange problem with WFS Intersects request on oraclespatial datasource layer. 1/The following Intersects request : http://192.168.3.24/cgi-bin/mapserv?map=/var/data/mapfiles/mymap.map&version=1.1.0&service=WFS&REQUEST=GetFeature&TYPENAME=ms:lineaire_div&Filter=Geometry772507,70056 889500,70056 889500,66553 772507,66553 772507,70056 => returns no output (missing)=msQueryByFilter(): Search returned no results. No matching record(s) found 2/While the same request with BBOX filter (the same BOX) http://192.168.3.24//cgi-bin/mapserv?map=/var/data/mapfiles/cadastre_depuis_rgd.map&version=1.1.0&service=WFS&REQUEST=GetFeature&TYPENAME=ms:lineaire_div&Filter=Name>NAME70056,66553 889500,70056 =>returns normaly all my records 3/i'm not experiencing this problem on SHPfile datasource( that i've converted from oracle ). Both requests return all my records 4/My table is quite big so i tried to reduce the numbers of features returned by Oracle when trying this Intersects filter and it has succeeded So it seems that there is a problem with WFS-Intersects Filter on oraclespatial datasource depending on the numbers of features returned by the oracle select. Thanks for your help -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-with-WFS-Intersects-filter-on-oraclespatial-datasource-tp5009604.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource
Hi list, I did several more tests and i've noticed 2 more things : - I'm experiencing this WFS-intersects "no results" response with oracle datasource containing above about 4 rows. - I noticed that "wfs_maxfeatures" wasn't passed to oracle select as bbox query do when using Interesects query. Thanks for your help, Best regards, Ludovic -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-with-WFS-Intersects-filter-on-oraclespatial-datasource-tp5009604p5009821.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource
Hi List, I always look for an explanation for my problem: Checking deeper in my logs i have found out that : - When using wfs gml:Polygon filter requests, polygon geometry is not passed to oracle SQL query. Mapserver simply send default layer extent to oracle. Which significantly increases the response time of Oracle on big tables. - In the same time i confirm that "wfs_maxfeatures" is not passed to oracle select when using Intersects query. it looks like 2 bugs, i'm not sure if i have to fill a ticket . Thanks for your help -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-with-WFS-Intersects-filter-on-oraclespatial-datasource-tp5009604p5011206.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource
Ludovic Gnemmi wrote: > > Hi List, > I always look for an explanation for my problem: > > Checking deeper in my logs i have found out that : > > - When using wfs gml:Polygon filter requests, polygon geometry is not > passed to oracle SQL query. Mapserver simply send default layer extent to > oracle. Which significantly increases the response time of Oracle on big > tables. This probably means that Mapserver has made a decision to filter the data later with some internal mechanism. It is for sure ineffective and worth making a feature request. Mapserver should use SDO_ANYINTERACT with the polygon geometry (or perhaps with the bounding box of the polygon geometry) in the SQL query. > - In the same time i confirm that "wfs_maxfeatures" is not passed to oracle > select when using Intersects query. If Mapserver does not make spatial query from Oracle it does not make sense to use AND rownum<(wfs_maxfeatures+1) alone. Otherwise Oracle would just return the first [maxfeatures] rows from the table while what you want is the first [maxfeatures] rows from the features selected by the ANYINTERACT with the polygon geometry. Rownum can be passed only if the exact filter is passed also. Notice that it means that if the WFS query contains attribute filters then they must also be converted into Oracle SQL query if the maxfeatures cutter is to be applied on the database side. -Jukka Rahkonen- > it looks like 2 bugs, i'm not sure if i have to fill a ticket . > Thanks for your help > > > > -- > View this message in context: http://osgeo- > org.1560.n6.nabble.com/Problem-with-WFS-Intersects-filter-on- > oraclespatial-datasource-tp5009604p5011206.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource
Thanks for your answer, I filed a ticket : https://github.com/mapserver/mapserver/issues/4513 Ludovic -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Re-Problem-with-WFS-Intersects-filter-on-oraclespatial-datasource-tp5011223p5011548.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users