WFS Intersects against ArcSDE

[Bart van den Eijnden]

Hi Assefa,

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.

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.

Best regards,
Bart

On Feb 4, 2008 4:10 PM, Yewondwossen Assefa <yassefa at dmsolutions.ca> wrote:

> Bart van den Eijnden wrote:
> > Hi list,
> >
> > we can't get a WFS Intersects filter to work against ArcSDE. It seems
> > Mapserver retrieves all the rows and tries and let GEOS do the
> > intersection. Is my impression correct?
> >
>
> > Ideally it would use FILTER to set a spatial WHERE clause, something
> like:
> >
> > SHAPE intersects POLYGON ((131970.3045120624 453455.16526662686,
> > 131969.21075920813 453349.07123976306, 132075.30478607194
> > 453347.9774869088, 132076.3985389262 453454.0715137726,
> > 131970.3045120624 453455.16526662686))
> >
> > Is anybody willing to help us to improve Mapserver in this respect? TIA.
> >
>
>  That is correct. The layer's filter is used now when the filter
> encoding is simple enough to be transformed into a where clause
> (binary/logical operations with one spatial filer. The spatial filter
> should be a bbox and is used to set the map extents). Note also that
> this applies on layers of type Postgis, Oracle and OGR
>  I am willing to work toward adding other spatial filters and layer
> types into this. I have entered a bug on this
> http://trac.osgeo.org/mapserver/ticket/2492 .
>
> Best Regards,
>
>
> > Best regards,
> > Bart
>
>
> --
> ----------------------------------------------------------------
> Assefa Yewondwossen
> Software Analyst
>
> Email: assefa at dmsolutions.ca
> http://www.dmsolutions.ca/
>
> Phone: (613) 565-5056 (ext 14)
> Fax:   (613) 565-0925
> ----------------------------------------------------------------
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20080204/9466dded/attachment.html