[mapserver-users] problem with oracle spatial layer not showing up

[Bart van den Eijnden]

Hi,

I have a problem with an Oracle Spatial layer not showing up. Can anybody please help? Thanks in advance!
EPSG:29112 is the Dutch system (Rijksdriehoek a.k.a RD)

In the logfile I get this:

Tue Feb 12 18:22:12 2002,2200,192.168.3.141,DEMO,0,18458.421916 323458.421916 346541.578084 651541.578084,182500.000000 
487500.000000,oracle_test ,normal execution

The mapfile looks like this

#
# Start of map file
#
NAME BART
STATUS ON
SIZE 600 600
EXTENT 0 275000 365000 700000
UNITS METERS
SHAPEPATH "data"
IMAGECOLOR 255 255 255

#
# Start of web interface definition (including WMS enabling metadata)
#
WEB
  HEADER demo_header.html
  TEMPLATE demo.html
  FOOTER demo_footer.html
  MINSCALE 1000
  MAXSCALE 1550000
  IMAGEPATH "set in demo_init.html"
  IMAGEURL "set in demo_init.html"
  LOG "demo.log"
  METADATA
    WMS_TITLE "UMN MapServer Itasca Demo"
    WMS_ABSTRACT "This is the UMN MapServer demonstration application for Itasca County located in north central Minnesota."
    WMS_ACCESSCONSTRAINTS none

    # change this value to match your setup
    WMS_ONLINERESOURCE "http://bartsdt/mapserver_demos/itasca/demo_init.html"

    WMS_SRS "EPSG:29112"
  END
END

#
# Start of layer definitions
#

LAYER
  NAME oracle_test
  TYPE POINT
  CONNECTIONTYPE oraclespatial
  CONNECTION "robert/robert at des"
  DATA "POLYGOON FROM (SELECT POLYGOON FROM GGA_GEMEENTE_EFEMERIDEN)"
  STATUS ON
  #LABELITEM "PVE_CODE"
  #CLASSITEM "PVE_CODE"
  #LABELMAXSCALE 500000
  #CLASS
  #  EXPRESSION /./
  #  COLOR -1 -1 -1
 #   LABEL
 #    COLOR 0 0 0
  #    SHADOWCOLOR 218 218 218
  #    SHADOWSIZE 2 2
  #    TYPE BITMAP
  #    SIZE MEDIUM
  #    POSITION CC
  #    PARTIALS FALSE
  #    BUFFER 2
    END
  END

  METADATA
    WMS_TITLE "Minor Civil Divisions"
    WMS_ABSTRACT "Minor civil divisions for Itasca County. (annotation only)"
    WMS_SRS "EPSG:29112"
  END
END



--
Bart van den Eijnden            Geodan IT BV
Email: bart at geodan.nl           Buitenhaven 27-A
Telefoon: 073-6925151           5211 TP 's-Hertogenbosch