[Mapserver-users] Empty Map with Oracle spatial

[nicolas.fortin at ec.gc.ca]

Hi,

1- The IUSR_ should have access to the oracle directory.  You can begin your
investigation here...

2- The layers should have a projection either with PROJECTION or directly in
the DATA "GEOMETRY FROM POLYGONS USING SRID XXXX" (I use both)

3- With Windows you better use complete path for the IMAGEPATH, SHAPEPATH
and SYMBOLSET, I have no more problem since then.

Hope this will help,
Nick


-----Message d'origine-----
De : Henrik Wilsdorf [mailto:H.Wilsdorf at gmx.net] 
Envoyé : Thursday, February 26, 2004 8:23 AM
À : mapserver-users at lists.gis.umn.edu
Objet : [Mapserver-users] Empty Map with Oracle spatial


Hi, Mapserver-users!

I'm trying to get a map from Oracle Spatial 9i (9.2), but only the shape
layer 
is visible in the image but no data (no polygon, no line, no point) from
oracle. With the shape layers all works fine in different maps. No other
errors occure, but one in MS_ERRORFILE:
    Thu Feb 26 12:26:40 2004 - msBuildPath: Unable to access file.
*** What does it mean???
 This error comes also, when I get a correct map without oracle layers.

The Oracle connection is also o.k.
When I have an error in the tablename I get the following text:

msDrawMap(): Image handling error. Failed to draw layer named 'polygons'. 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. ORA-00942: Tabelle
oder View nicht vorhanden . 
SQL statement: SELECT rownum, GEOMETRY FROM POLYGONS1 
WHERE SDO_FILTER( POLYGONS1.GEOMETRY, 
MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
MDSYS.SDO_ORDINATE_ARRAY(-40,0,440,400) ),'querytype=window') = 'TRUE' 

With the corrected statement I got tho following data back in SQLplus:

ROWNUM GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
SDO_ORDINATES)
     1 SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_ARRAY(50, 260, 0, 50, 90, 0, 120, 90, 0, 120, 260, 0, 50, 260,
0))
     2 SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_ARRAY(140, 80, 0, 340, 80, 0, 340, 150, 0, 140, 80, 0))
     
This should be a rectangle and a triangle. Both are also shown in the Oracle
spatial advisor. The spatial data are created with autodesk Map 2004. I use
Windows 2000 / IIS 5 and the binaries Mapserver 4.0.1 (PNG + Oracle) from
mapserver.gis.umn.edu. The address I used in
IE6:
http://willi1/scripts/mapserv.exe?map=/data/projects/spatial1/testora1.map&m
ode=map

My Mapfile:

MAP
  NAME "testora1"
  STATUS ON
  EXTENT 0 0 400 400 
  SIZE 600 500 
  SHAPEPATH "data"
  SYMBOLSET "etc/symbols.sym"
  FONTSET "etc/fonts.txt"
  IMAGETYPE PNG
  IMAGECOLOR 255 255 200
  UNITS METERS
  WEB
    IMAGEPATH "/data/tmp/"
    IMAGEURL "/tmp/"
    LOG "/data/log/mslog.txt"
  END
  
  LAYER
      NAME "polygonshape"
      STATUS DEFAULT
      DATA "polygonshape"
      TYPE POLYGON
      CLASS
        STYLE
          COLOR 200 200 100
          OUTLINECOLOR 1 1 1
         END
      END
  END
  
  LAYER
        NAME "polygons"
        STATUS DEFAULT
        DATA "GEOMETRY FROM POLYGONS"
        TYPE POLYGON
        CONNECTIONTYPE ORACLESPATIAL
        CONNECTION "map1/abc at willi1"
        CLASS
          STYLE
            COLOR 0 128 128
            OUTLINECOLOR 1 1 1
          END
        END
    END

  LAYER
    NAME "polylines"
    STATUS DEFAULT
    DATA "GEOMETRY FROM POLYLINES"
    TYPE LINE
    CONNECTIONTYPE ORACLESPATIAL
    CONNECTION "map1/abc at willi1"
    CLASS
      STYLE
        COLOR 0 0 255
        SIZE 50
      END
    END
  END
  
  LAYER
    NAME "points"
    STATUS DEFAULT
    DATA "GEOMETRY FROM POINTS"
    TYPE POINT
    CONNECTIONTYPE ORACLESPATIAL
    CONNECTION "map1/abc at willi1"
    CLASS
      STYLE
        SYMBOL 13
        COLOR 1 1 1
        SIZE 50
      END
    END
   END
   
END
----------------
Waiting for some help.

Regards

Henrik Wilsdorf

-- 
GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...)
jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++

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