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

[Bart van den Eijnden]

Hi,

no I downloaded the win32 binary from http://parvillers.homeip.net/mapserver/

Is there a way to get ORA error messages (or do they appear in the normal log file?)?
And what is default colour for polygons?
My data is in the selected window (extent).

Thanks in advance,
Bart



2/12/2002 9:56:24 PM, PARVILLERS <hugues at parvillers.com> wrote:

>Hello bart,
>
>I suppose you build your own version of mapserver to use with Oracle Spatial.
>Is it an unix one ?
>What version of the spatial adaptor do you use ?
>
>Are your data in the selected window ?
>Also it seems you don't set the output color for polygons ?
>
>Hugues
>France
>
>
>
>
>
>Bart van den Eijnden a écrit :
>
>> 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
>
>
>
--
Bart van den Eijnden            Geodan IT BV
Email: bart at geodan.nl           Buitenhaven 27-A
Telefoon: 073-6925151           5211 TP 's-Hertogenbosch