No subject

side of things a list of candidate features are retrieved using the bbox =
of the selection
feature (basically a queryByRect)  and then MapServer handles the rest. =
PostGIS and
Oracle Spatial work the same way.

In a single pass query environment it would be optimal to let the =
underlying DB do
that work. Perhaps that's what Howard is refering to?

Steve

>>> Dave McCann <mccann.dave at GMAIL.COM> 6/22/2006 11:04:45 AM >>>
Got it working now.

It appears to be the version of MS4W we were using. We switched from =
version
1.5.4 to version 1.5.3 after getting some great advice via mapserv IRC
channel and now it's working fine.

If we need to add the query by polygon capability for sde would anyone be
interested in writing the code?

Thanks for the assistance.

=20

-----Original Message-----
From: Howard Butler [mailto:hobu at iastate.edu]=20
Sent: Wednesday, June 21, 2006 1:16 PM
To: Dave McCann; MAPSERVER-DEV at LISTS.UMN.EDU=20
Subject: Re: [UMN_MAPSERVER-DEV] ArcSDE 9.1 Support


At 11:30 AM 6/21/2006, Dave McCann wrote:
>We're looking into implementing mapserver in a production
>environment utilizing SDE connections to map data.
>
>I was looking at the current docs on SDE and saw that spatial
>selects are currently only supported by queryByAttributes and queryByRect.=

>
>Is there any activity for developing a queryByPoly (select based on
>spatial area of a polygon)?
>
>We've considered using Tomcat to poke into SDE for the spatial
>select as a workaround but would prefer to use any existing=20
>functionality in mapserver.
>
>I've been trying to conduct some local testing of performance with
>SDE layers but have been unsuccessful with a simple single layer=20
>request. Can anyone point me to a thread or any documentation that I=20
>can use in troubleshooting our current mapserver config (MS4W) with SDE?
>

There have been folks having success with the MS4W 1.5.3 binaries and=20
SDE 9.1.  You might catch me on IRC to hammer out specific issues,=20
but I think the MS4W docs explain how to swap the dlls.  Only other=20
issue should be making sure the SDE SDK binaries are on your PATH and=20
if you're using IIS that the SDE dlls have the execute bits set for=20
the internet user.  Use mapserv.exe -v on the command line to confirm=20
that SDE support is enabled.

Implementing support to allow MapServer SDE to do queryByPoly should=20
be pretty straightforward, but I haven't found time, funding, or need=20
to implement it.  I don't know if Steve has found a need for it=20
either (I think he uses the SDE stuff pretty regularly=20
also).  Patches always welcomed ;)

Howard