[MAPSERVER-DEV] WFS Intersects against ArcSDE

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[MAPSERVER-DEV] WFS Intersects against ArcSDE

Bart van den Eijnden-3
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.

Best regards,
Bart
Reply | Threaded
Open this post in threaded view
|

Re: [MAPSERVER-DEV] WFS Intersects against ArcSDE

Yewondwossen Assefa
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: [hidden email]
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------
Reply | Threaded
Open this post in threaded view
|

Re: [MAPSERVER-DEV] WFS Intersects against ArcSDE

Bart van den Eijnden-3
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 <[hidden email]> 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: [hidden email]
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------