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