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

[Fortin,Nicolas [SteFoy]]

Hi Jiri,

You should use a PROJECTION element in your mapfile for this layer or you should add USING SRID XXXXX at the end of your DATA request.

Example:

LAYER
  NAME "3"
  TYPE POLYGON
  CONNECTIONTYPE oraclespatial
  CONNECTION "uid/pwd at dbname"
  DATA "GEOLOC FROM USR_WATERSHED.VWTRSD_LCC USING SRID 3000000"
  STATUS OFF
  DUMP TRUE
  
  PROJECTION
    "proj=lcc"
    "ellps=GRS80"
    "lat_0=63"
    "lon_0=-91.8666"
    "lat_1=49"
    "lat_2=77"
    "x_0=6200000"
    "y_0=2958000"
    "datum=NAD83"
    "units=m"
  END
  
  CLASS
    NAME "Watershed"
    SYMBOL 'CIRCLE'
    SIZE 2
    COLOR 255 255 255
    OUTLINECOLOR 0 204 0
  END
END # Watershed

Nicolas

-----Message d'origine-----
De : Jiri Potocny [mailto:potocny at espace.cz] 
Envoyé : Wednesday, March 17, 2004 10:54 AM
À : mapserver-users at lists.gis.umn.edu
Objet : [Mapserver-users] Unable to display data stored in Oracle Spatial


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