Filtering on oracle layers using mapserver 4.6

[Bart van den Eijnden]

Hi Robert,

AFAIK the OGR Oracle Spatial driver does not allow a FILTER to be set. This has to do with that it has no extra logic to build a combined SQL WHERE CLAUSE, ie the one it applies normally by itself, and the one you or a program would specify using a FILTER.

You could talk to Frank Warmerdam about having this added to the OGR OCI driver on a contract. I heard he is on holiday right now.

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl

>>> Robert oude Lohuis <oudelohuisr at VERTIS.NL> 09/05/05 2:34 pm >>>
Hi list,

Does anybody have any idea about this problem ?
I would very much like to use combined filters with oracle spatial
connections through ogr.

thanks in advance.


On Fri, 2 Sep 2005 01:36:00 -0500, Robert oude Lohuis
<oudelohuisr at VERTIS.NL> wrote:

>Fernando,
>
>thanks for the reply, but we would use native support if could, because it
>is faster (and according to you, we should not have a problem).
>But alas, we also need administrative data from the database, so we must use
>OGR ;-(
>
>I very much like to use the extent filter, but the trouble is dat with every
>dataset added to the database, the performance drops. So if there are 10
>datasets in the table, and you need only one to display, all ten datasets
>are retrieved from the database.
>And if you use the query to restrict the dataset, even if zoomed in on a
>very small area, the whole dataset is retrieved from the database.
>
>Is this a problem with OGR, is it not capable of merging the two
>filter-parts, of is the problem within mapserver ?
>
>greetz,
>
>Robert.