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