[gdal-dev] ogr option-spat

[GOUBET LIONEL]

Thanks Frank

Netherless, I can to execute a sql request (SDO_RELATE with contains, etc...) filter and it works.
I a another way for the solution.

Best regards,
Lionel


----- Message d'origine ----
De : Frank Warmerdam <warmerdam at pobox.com>
À : GOUBET LIONEL <goubetli at yahoo.fr>
Cc : guillaume.sueur at neogeo-online.net; gdal-dev at lists.osgeo.org
Envoyé le : Jeudi, 9 Octobre 2008, 21h28mn 36s
Objet : Re: Re : Re : [gdal-dev] ogr option-spat

GOUBET LIONEL wrote:
> Here are more precisions:
> 
>    1. I work with OSGEO4W with plugins oci.
>    2. My datatable is a table Oracle spatial with a column geometry.
>    3. If I launch ogr.exe with *-sql select * from myTable* or with
>      *-sql select * from myTable -spat XMIN YMIN XMAX YMAX =>* the
>      result is the same.
> 
> That's the reasons why I don't understand.

Lionel,

On review this is a bug in the Oracle driver.  It ignores spatial filters
passed to the ExecuteSQL() call.  If you file a ticket on this I should
be able to fix it fairly easily.  Some other RDBMS drivers may have similar
issues when passing in arbitrary SQL as opposed to "direct" table access.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up  | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20081009/ff769ac1/attachment.html