Oracle Spatial : Geodetic data : queries fail

[Michael Scharber]

Fernando,

That did it.  Thanks a bunch!

Michael

*******************************************************
       	Michael Scharber
 	Scripps Institution of Oceanography
 	Institute of Geophysics and Planetary Physics
 	8785 Biological Grade
 	IGPP Room 4212
 	La Jolla, CA 92037

         mscharber at gpsmail.ucsd.edu
 	(858)534-1750
*******************************************************

On Thu, 2 Mar 2006, Fernando Simon wrote:

> Hi Michael,
>   For 9i version you can use the VERSION parameter in your layer DATA 
> definition, in your case:
>       DATA "SHAPE FROM SITE USING UNIQUE SITE_ID SRID 8307 RELATE VERSION 
> 9i"
>   Best regards.
>  ------------------------------------------------------------------------
> Fernando Simon
> Mapserver and Oracle Spatial developer
> G10 - Laboratorio de Computacao Aplicada - Brazil
> http://www.univali.br/g10 - UNIVALI/CTTMAR
> ------------------------------------------------------------------------
>
>
> Michael Scharber wrote:
>> Hi There,
>> 
>> How exactly does one get MapServer to play with Geodetic data (SRID=8307) 
>> in Oracle Spatial (9i)?  I cannot get past:
>> 
>>> "Element of type Extent is not supported for Geodetic data"
>>> msDrawMap(): Image handling error. Failed to draw layer named 'gps'.
>>> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-29902: 
>>> error in executing ODCIIndexStart() routine ORA-13373: Element of type 
>>> Extent is not supported for Geodetic data ORA-06512: at 
>>> "MDSYS.SDO_INDEX_METHOD_9I", line 368 ORA-06512: at line 1 . Query 
>>> statement: SELECT SITE_ID, SHAPE FROM SITE WHERE SDO_RELATE( SHAPE, 
>>> MDSYS.SDO_GEOMETRY(2003, 8307, 
>>> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-8.94375,36.73125,13.55625,59.23125) 
>>> ),'mask=anyinteract querytype=window') = 'TRUE' . Check your data 
>>> statement
>> 
>> For example, in other applications (Java, Perl, etc) I use the following 
>> with success:
>> 
>> select site_code,site_name from site where
>> SDO_RELATE(shape,MDSYS.SDO_GEOMETRY(2003,8307,null,
>> MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),
>> MDSYS.SDO_ORDINATE_ARRAY(-118.0,32.0,-116.0,32.0,-116.0,35.0,-118.0,35.0,-118.0,32.0)), 
>> 'mask=inside querytype=WINDOW') = 'TRUE'
>> 
>> My MapServer config parameters are:
>> 
>> CONNECTIONTYPE oraclespatial
>> DATA "SHAPE FROM SITE USING UNIQUE SITE_ID SRID 8307 RELATE"
>> 
>> Any suggestions?
>> 
>> Thanks in advance.
>> 
>> Michael
>> 
>