using oraclespatial data in map

John Cartwright John.C.Cartwright at NOAA.GOV
Tue Oct 18 12:29:35 PDT 2005


Hello All,

I'm trying to use oracle spatial table (geographic WGS84 coords)  as a 
layer in a map and seem to be having trouble w/ the projection.  The 
layer is defined as:
    LAYER
        NAME admin2
        CONNECTIONTYPE oraclespatial
        CONNECTION "dbuser/dbpass at oraclehost"
        DATA "SHAPE FROM ESRI.COUNTRY_TSQA"
        STATUS off
        TYPE polygon

         CLASS
                OUTLINECOLOR 0 0 255
         END
        PROJECTION
           "init=epsg:4326"
        END
    END


However, mapserver seems to be generating an SQL query w/ a NULL SRID:

ORA-13208: internal error  while evaluating [window SRID does not match 
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 281
ORA-06512: at line 1
 . Query statement: SELECT rownum, SHAPE FROM ESRI.COUNTRY_TSQA WHERE 
SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-179.75,-89.875,179.75,89.875) 
),'querytype=window') = 'TRUE' . Check your data statement.


Can anyone help me with the proper mapfile syntax?

Thanks!

-- john



More information about the MapServer-users mailing list