Hi, Ok, understood. Do you have enough material now for filing a bug report? The desired behaviour would be to apply && filter for the first PostGIS query with the maximun extents of the geometry included in the filter of the WFS request, but without limit [maxFeatures]?
-Jukka Rahkonen- Stéphane Brunner wrote: > > Hello, > > 2011/8/24 Rahkonen Jukka <jukka.rahko...@mmmtike.fi>: > > Hi, > > > > I am not too familiar with PostGIS, but isn't this && > exactly an index based > > BBOX query which is checking if the BBOX of the feature is > intersecting with > > the BBOX of the reference geometry? > > where geom && > >> >> GeomFromText('POLYGON((620000 218000,620000 278000,690000 > >> >> 278000,690000 218000,620000 218000))',-1) > This BBox is the Extents of the mapfile than in our case it > always return true. > > > > > Then perhaps what you wrote > > "MapServer filters them correctly but as we get > >> only the 100 first results from the DB, we miss many objects and/or > >> they are not related to the area where we want to apply a > geographical > >> filter. " > > > > could better be written "as we get only the 100 first > results within the > > BBOX filtered with fast but inaccurate index search, the > result set after > > Mapserver applying a geographical filter may have less that > 100 features". > Yes, but with a so large BBOX (extent from the mapfile, not geometry > extent) in most cases it returns 0 results. > > Sincerely > Stéphane Brunner > > > > > -Jukka Rahkonen- > > > > > > _______________________________________________ > > mapserver-users mailing list > > mapserver-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > > > -- > camptocamp.com > mapfish.org > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users