Oracle Spatial : Geodetic data : queries fail

Michael Scharber mscharber at UCSD.EDU
Thu Mar 2 08:47:55 PST 2006


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



More information about the MapServer-users mailing list