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

Wed Feb 13 20:32:27 EST 2002

First, make sure you are using syntax 2 for the DATA statement (previous
email). Secondly, I'll let our friend Hughes Parvillers to help you optimize
your access to SDO data. He has plenty more of experience than I have in
this Oracle stuff, so you are in good hands =) Any comments H/P?

Rod.

ps: I have a mapfile that gets static data from shapefiles, and the dynamic
data comes from an SDO database. It's a PII 933Mhz w/ 512mb (Linux), and the
performance is less than 2 secs. Perhaps you could split your info like I
did to improve performance.

----- Original Message -----
From: "Bart van den Eijnden" <bart at geodan.nl>
To: <mapserver-users at lists.gis.umn.edu>; "Rodrigo Cabral"
<cabral at yadata.net>
Sent: Wednesday, February 13, 2002 10:18 AM
Subject: Re: [mapserver-users] problem with oracle spatial layer not showing
up

Hi Rodrigo,

thanks, indeed it was the omission of a class which caused the problem.
I have the map now showing, but performance is really poor (22 seconds for
one map).
Do you have an indication of how performance should be and how to increase
performance?

Thanks in advance,
Bart

2/13/2002 3:05:38 PM, "Rodrigo Cabral" <cabral at yadata.net> wrote:

>Dear Bart (and other Oracle Spatial - SDO - users),
>
>The syntax for the mapfile DATA statement has been updated in order to
>support SRID definitions (looks like you're using a workaround I posted in
>the list sometime ago). Check your maporaclespatial.c for revision 1.8. The
>syntax is:
>
>DATA "shape FROM table" (as before)
>DATA "shape FROM table USING SRID srid_number" (new)
>DATA "shape FROM (SELECT stmt)" (as before)
>
>Syntax 2 accepts a SDO SRID number, which must be exactly the same number
>used in the SDO_SRID attribute for 'shape' in 'table'. Old code assumed the
>srid to be NULL, causing a SDO SRID mismatch error when using syntax 1 -
the
>workaround was to use syntax 3. However, syntax 3 is not recommended
because
>it returns ALL shapes from the SELECT stmt, regardless of the current image
>extent (therefore, making mapserver to draw/work-with non-visible
elements).
>Thus, Syntax 2 solves the mismatch error problem (performance-wise, syntax
1
>& 2 are equal except that syntax 1 uses a NULL srid for the query
statement,
>while syntax 2 has a defined srid).
>
>However, I don't think that is what is causing your problem.
>
>First of all, I believe I read somewhere that you must have a CLASS to be
>defined. Apparently you commented out the only class you had. So, try
>using simply (for polygons):
>
>CLASS
>  COLOR 128 128 128 # gray-filled
>  OUTLINECOLOR 0 0 0 # black contour
>END
>
>Secondly, there's the STATUS, which I believe should be DEFAULT to work.
Not
>sure on that, but you should try anyway...
>
>STATUS DEFAULT
>
>Finally, check EXTENT to see if it conforms to the data stored in your
>shapefile column (POLYGOON). Run this select statement to count how many
>shapes you should see in the default view.
>
>SELECT count(A.polygoon) FROM GGA_GEMEENTE_EFEMERIDEN A
>WHERE SDO_FILTER( A.polygoon, MDSYS.SDO_GEOMETRY(
>2003, <srid>, NULL,
>MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
>MDSYS.SDO_ORDINATE_ARRAY( <x1>, <y1>, <x2>, <y2> )),
>'querytype=window') = 'TRUE'
>
>where:
>- <srid> should be your srid (or A.SDO_SRID);
>- <xi> and <yi> come from your EXTENTS (i.e. with your extents it would be
>x1=0; y1=275000; x2=365000; y2=700000)
>
>Cheers,
>Rod.
>
>----- Original Message -----
>From: "Bart van den Eijnden" <bart at geodan.nl>
>To: <mapserver-users at lists.gis.umn.edu>
>Cc: <bart at geodan.nl>
>Sent: Tuesday, February 12, 2002 2:50 PM
>Subject: [mapserver-users] problem with oracle spatial layer not showing up
>
>
>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