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
