Stéphane Brunner wrote: > Hello,
2011/8/29 Rahkonen Jukka <jukka.rahko...@mmmtike.fi>: > Hi, > > Ok, understood. Do you have enough material now for filing a bug report? I just done it: http://trac.osgeo.org/mapserver/ticket/4005 > 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]? > Effectively it's not the best but it's good enough, the best is to > done the geometry filtering in postgis ;-). Then why not to use TinyOWS http://tinyows.org ? -Jukka- Sincerely Stéphane > > -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 >> -- camptocamp.com mapfish.org _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users