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
