[Mapserver-users] Unable to display data stored in Oracle Spatial

[Jiri Potocny]

Fernando,

thank you for your hints.

I used Oracle SQL loader utility to import the data:
SQLLDR  uid/pwd at srvcname control=parcely log=parcely.log
The data were stored in comma separated value text file in the format like
this:
4|777777||"1"|1|3007|
|pt||||1|1003|1|;-554984,87|-1285550,04|0|-554998,75|-1285529,3200000001|0|-
555001,98999999999|-1285530,8100000001|0|-554984,87|-1285550,04|0|:1|02/13/2
004 00:00:00||

Anyway, I tried to execute SDO_MIGRATE.TO_CURRENT(' TABLE ','
GEOMETRY_COLUMN '), but the problem remains.

Regards,
Jirka

P.S. Your English is perfect enough for this purposes, no need to
appologize.

----- Original Message -----
From: Fernando S.
To: Jiri Potocny ; mapserver-users at lists.gis.umn.edu
Sent: Wednesday, March 17, 2004 6:12 PM
Subject: Re: [Mapserver-users] Unable to display data stored in Oracle
Spatial


Hi Jiri,
    I don't know if I can help you. But I will try.
    I need to do some questions to help you:
        How you imported the data to Oracle?
        Using shp2sdo? If yes, after you imported the data, did you execute
this function:
            SDO_MIGRATE.TO_CURRENT(' TABLE ',' GEOMETRY_COLUMN ');
         If you create a table with geometry columns, and populate it, and
try show it in the mapserv? It appeared in the image?

    I don't know if I help you, sorry my poor english.
    If you need some help, you can report me.

==================================================================
Fernando Simon - simon at cttmar.univali.br
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computaçao Aplicada
Fone: 047 - 341 7960
http://g10.cttmar.univali.br
==================================================================

Jiri Potocny wrote:
Dear MapServer experts,

could you please help me with following problem?

I'm trying to display data strored in Oracle Spatial, but I allways get a
blank map.
The map file is as follows:

MAP
  IMAGETYPE      PNG
  EXTENT -551051 -1288960 -548185 -1286773
  SIZE           800 600
  IMAGECOLOR     255 255 255

  LAYER
    NAME           parcels
    DUMP           TRUE
    STATUS         DEFAULT
    TYPE           POLYGON

    CONNECTIONTYPE oraclespatial
    CONNECTION     username/password at netservisname
    DATA           "BOUNDARY FROM PARCELS"

    CLASS
      COLOR        232 232 232
      OUTLINECOLOR 32 32 32
    END
  END

END

If I export the data from oracle into the shapefile and use following map
file, everything is O.K.

MAP
  IMAGETYPE      PNG
  EXTENT -551051 -1288960 -548185 -1286773
  SIZE           800 600
  SHAPEPATH      "data"
  IMAGECOLOR     255 255 255

  LAYER
    NAME           parcely
    DUMP           TRUE
    STATUS         DEFAULT
    TYPE           POLYGON
    DATA          PARCELS

    CLASS
      COLOR        232 232 232
      OUTLINECOLOR 32 32 32
    END
  END

END

The only difference is in the data source, the data (attributes as well as
geometries) are the same. I'm running MapServer 4.0.1 with Oracle Spatial
support (downloaded from
http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip) and
Oracle Database Server version 9.2.0.1.0 on Windows 2000 Professional SP 3.

Could anybody get throught this problem.

Much appreciated,
Jirka

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users