<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>Thanks Frank</DIV>
<DIV> </DIV>
<DIV>Netherless, I can to execute a sql request (SDO_RELATE with contains, etc...) filter and it works.</DIV>
<DIV>I a another way for the solution.</DIV>
<DIV> </DIV>
<DIV>Best regards,</DIV>
<DIV>Lionel</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif">----- Message d'origine ----<BR>De : Frank Warmerdam <warmerdam@pobox.com><BR>À : GOUBET LIONEL <goubetli@yahoo.fr><BR>Cc : guillaume.sueur@neogeo-online.net; gdal-dev@lists.osgeo.org<BR>Envoyé le : Jeudi, 9 Octobre 2008, 21h28mn 36s<BR>Objet : Re: Re : Re : [gdal-dev] ogr option-spat<BR><BR>GOUBET LIONEL wrote:<BR>> Here are more precisions:<BR>> <BR>> 1. I work with OSGEO4W with plugins oci.<BR>> 2. My datatable is a table Oracle spatial with a column geometry.<BR>> 3. If I launch ogr.exe with *-sql select * from myTable* or with<BR>> *-sql select * from myTable -spat XMIN YMIN XMAX YMAX =>* the<BR>> result is the same.<BR>> <BR>> That's the reasons why I don't understand.<BR><BR>Lionel,<BR><BR>On review this is a bug in the Oracle driver. It ignores
spatial filters<BR>passed to the ExecuteSQL() call. If you file a ticket on this I should<BR>be able to fix it fairly easily. Some other RDBMS drivers may have similar<BR>issues when passing in arbitrary SQL as opposed to "direct" table access.<BR><BR>Best regards,<BR>-- <BR>---------------------------------------+--------------------------------------<BR>I set the clouds in motion - turn up | Frank Warmerdam, <A href="mailto:warmerdam@pobox.com" ymailto="mailto:warmerdam@pobox.com">warmerdam@pobox.com</A><BR>light and sound - activate the windows | <A href="http://pobox.com/~warmerdam" target=_blank>http://pobox.com/~warmerdam</A><BR>and watch the world go round - Rush | Geospatial Programmer for Rent<BR><BR></DIV></DIV></div><br>
</body></html>