Hi Assefa,<br><br>thanks for your reply. I'll see if we can come up with a patch at least for ArcSDE and attach it to the ticket.<br><br>One thing that came to mind is: maybe a quick win would be to set the MAP's EXTENT to the bounds of the intersection polygon, that would at least limit the result set a lot and make the operation a lot quicker probably.<br>
<br>Best regards,<br>Bart<br><br><div class="gmail_quote">On Feb 4, 2008 4:10 PM, Yewondwossen Assefa <<a href="mailto:yassefa@dmsolutions.ca">yassefa@dmsolutions.ca</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="Wj3C7c">Bart van den Eijnden wrote:<br>> Hi list,<br>><br>> we can't get a WFS Intersects filter to work against ArcSDE. It seems<br>> Mapserver retrieves all the rows and tries and let GEOS do the<br>
> intersection. Is my impression correct?<br>><br><br>> Ideally it would use FILTER to set a spatial WHERE clause, something like:<br>><br>> SHAPE intersects POLYGON ((131970.3045120624 453455.16526662686,<br>
> 131969.21075920813 453349.07123976306, 132075.30478607194<br>> 453347.9774869088, 132076.3985389262 453454.0715137726,<br>> 131970.3045120624 453455.16526662686))<br>><br>> Is anybody willing to help us to improve Mapserver in this respect? TIA.<br>
><br><br></div></div> That is correct. The layer's filter is used now when the filter<br>encoding is simple enough to be transformed into a where clause<br>(binary/logical operations with one spatial filer. The spatial filter<br>
should be a bbox and is used to set the map extents). Note also that<br>this applies on layers of type Postgis, Oracle and OGR<br> I am willing to work toward adding other spatial filters and layer<br>types into this. I have entered a bug on this<br>
<a href="http://trac.osgeo.org/mapserver/ticket/2492" target="_blank">http://trac.osgeo.org/mapserver/ticket/2492</a> .<br><br>Best Regards,<br><br><br>> Best regards,<br>> Bart<br><br><br>--<br>----------------------------------------------------------------<br>
Assefa Yewondwossen<br>Software Analyst<br><br>Email: <a href="mailto:assefa@dmsolutions.ca">assefa@dmsolutions.ca</a><br><a href="http://www.dmsolutions.ca/" target="_blank">http://www.dmsolutions.ca/</a><br><br>Phone: (613) 565-5056 (ext 14)<br>
Fax: (613) 565-0925<br>----------------------------------------------------------------<br><br></blockquote></div><br>