Hi all,
This error can be relate with Oracle Spatial directly. After you
imported your data in database did you execute the
SDO_MIGRATE.TO_CURRENT function?
This step is important to fix some objects in database. As Jukka
wrote, you need to check the projection did you define, can you try to
draw a map without any projection defined?.
Best regards.
---------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer
Rahkonen Jukka wrote:
Hi,
I would check first if the extents of the map file and data returned from Oracle match. Oracle used to have only its own SRID system (nothing to do with epsg codes) before 10g version. Make a simple SQL request directly with SQL*Plus for one feature
only and check if the coordinates you get really fall inside your map extents.
-Jukka Rahkonen-
-----Original Message-----
From: UMN MapServer Users List on behalf of Gagan Bansal
Sent: Sat 15.9.2007 12:51
To: [email protected]
Subject: [UMN_MAPSERVER-USERS] oracle spatial connection
i am trying to dispaly the oracle spatial 10g v2 data in mapserver but my
application display the blank page, not able to get where is the mistake
following has been done:
# -load shape file in oracle using shp2sdojava
- created spatial index on 'geom'
# swapping dll as described in the readme file of the mapserver
#Setting environment variables
- ORACLE_HOME : C:\oracle\product\10.2.0\db_1
- ORACLE_SID : orcl
- TNS_ADMIN : C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
#here is the map file for oracle spatial data connection
MAP
NAME DEMO
STATUS ON
SIZE 400 300
SYMBOLSET ../etc/symbols.sym
EXTENT -1001942.225269 2155071.744446 -998438.476117 2158497.456450
UNITS METERS
SHAPEPATH "../data1"
IMAGECOLOR 255 255 255
FONTSET ../etc/fonts.txt
TRANSPARENT FALSE
# Start of web interface definition
WEB
IMAGEPATH "/ms4w/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
LOG "/tmp/bigmaps_oracle.log"
MS_ERRORFILE "/tmp/bigmaps_oracle_error.log"
METADATA
END
END
# Start of reference map
PROJECTION
"init=epsg:32643"
END
# Start of layer definitions
LAYER
GROUP "Polygon"
NAME playground
CONECTIONTYPE oraclespatial
CONNECTION "scott/[EMAIL PROTECTED]"
DATA "GEOM FROM PLAYGROUND_UTM USING UNIQUE OBJECTID USING SRID
32643"
METADATA
"DESCRIPTION" "playground"
"RESULT_FIELDS" "OBJECTID"
"GROUP" "Polygon"
"LAYER" "playground"
END
TYPE POLYGON
STATUS ON
CLASS
NAME "playground"
COLOR 200 255 0
OUTLINECOLOR 120 120 120
END
TOLERANCE 5
END # Layer
END # Map File
log file also not being creaed in the specified folder?
Thanks of any help
Gagan
