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 <[EMAIL PROTECTED]>
À : GOUBET LIONEL <[EMAIL PROTECTED]>
Cc : [EMAIL PROTECTED]; [email protected]
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, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent


      
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to