FW: Mapserver for Oracle spatial 10G
Ruiter E. de (Erik)
E.Ruiter at ARCADIS.NL
Tue Jan 10 08:42:17 EST 2006
Hi Bart,
Thanks for your help. I solved the problem by dropping the 'USING SRID
etc...' altogether. I'm not sure whether or not this will lead to
problems in the future but for the 'time-being' it works.
Thanks again!
Greetings,
Erik.
-----Original Message-----
From: Bart van den Eijnden (OSGIS) [mailto:bartvde at xs4all.nl]
Sent: dinsdag 10 januari 2006 14:09
To: Ruiter E. de (Erik)
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] FW: Mapserver for Oracle spatial 10G
Does your Oracle table have SRID 90112? Or does it have a NULL SRID?
Otherwise try USING SRID NULL in your DATA statement.
Best regards,
Bart
Ruiter E. de (Erik) wrote:
>Hi list,
>
>Now that I've tried several things, I got this error in my browser
>window.
>
>msDrawMap(): Image handling error. Failed to draw layer named
>'Gebouwen'.
>msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
>ORA-29902: error in executing ODCIIndexStart() routine ORA-13208:
>internal error while evaluating [window SRID does not match layer SRID]
>operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391
ORA-06512:
>at line 1 . Query statement: SELECT rownum, N0320 FROM GEBOUW WHERE
>SDO_FILTER( N0320, MDSYS.SDO_GEOMETRY(2003, 90112,
>NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(12222
>2
>.305,425974.862,131384.151,430555.785) ),'querytype=window') = 'TRUE' .
>Check your data statement.
>
>Does someone know how to solve this?
>
>Greets,
>Erik.
>
>
>-----Original Message-----
>From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]
>On Behalf Of Ruiter E. de (Erik)
>Sent: dinsdag 10 januari 2006 13:12
>To: MAPSERVER-USERS at LISTS.UMN.EDU
>Subject: Re: [UMN_MAPSERVER-USERS] FW: Mapserver for Oracle spatial 10G
>
>Hi Fernando,
>
>I just see a blank image, no more error messages, the error produced by
>the debug mode in the error.log file is:
>[Tue Jan 10 12:48:48 2006] [error] [client 127.0.0.1] msDrawMap():
>Drawing Label Cache, 0.000s\r
>[Tue Jan 10 12:48:48 2006] [error] [client 127.0.0.1] msDrawMap() total
>time: 0.000s\r
>
>I've made an export from a oracle 9.2 database and imported it into our
>oracle 10g database.
>Also I've already tried several variations of the mapfile, with and
>without projection definitions.
>
>Greetings,
>Erik.
>
>
>
>-----Original Message-----
>From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]
>On Behalf Of Fernando Simon
>Sent: dinsdag 10 januari 2006 13:02
>To: MAPSERVER-USERS at LISTS.UMN.EDU
>Subject: Re: [UMN_MAPSERVER-USERS] FW: Mapserver for Oracle spatial 10G
>
>Hi folks,
> Sorry for the delay to reply your message, about the Oracle Spatial
>support in Mapserver you can use since 8i, 9i and 10G versions without
>problems.
> About the debug, you need to add "DEBUG ON" in your layer and in
>your Map. The Mapserver how to for Oracle Spatial connection you can
>see in this link:
>"http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto".
> About your problem, what's happen, any error message or just a
>blank image? How you imported your data in the database? Using shp2sdo?
>Are already tried to draw without projection definitions?
> Last year I did a page that contains some examples of Oracle
>Spatial connection using Mapserver in CGI mode. This page contains the
>MAP and QUERY modes. Link:
>"http://siaiacad09.univali.br/removidos/G10NOVO/htdocs/maporaclespatial
>/
>".
> Best regards.
>
>------------------------------------------
>Fernando Simon
>Mapserver and Oracle Spatial developer
>UNIVALI - CTTMar - Brazil
>------------------------------------------
>
>
>Citando "Ruiter E. de (Erik)" <E.Ruiter at ARCADIS.NL>:
>
>
>
>>Hi Bart and other users,
>>
>>I switched on debugging by placing : DEBUG ON at map level and at
>>layer level in my mapfile.
>>
>>These are the error.log and access.log files. I can't make any sense
>>of it.
>>
>>Greetings,
>>Erik.
>>
>>
>>-----Original Message-----
>>From: Bart van den Eijnden [mailto:bartvde at xs4all.nl]
>>Sent: maandag 9 januari 2006 15:30
>>To: Ruiter E. de (Erik)
>>Subject: RE: FW: Mapserver for Oracle spatial 10G
>>
>>Hoi Erik,
>>
>>Probeer eens debuggen aan te zetten.
>>
>>Zet DEBUG ON op je LAYER object en evt op je MAP object.
>>
>>Als je IIS gebruikt, zet environment variabele MS_ERRORFILE op stderr
>>en herstart server.
>>
>>Als je Apache gebruikt, zet MS_ERRORFILE dan via SetEnv in de
>>httpd.conf en herstart Apache.
>>
>>In de error log van je webserver komt dan debug info.
>>
>>Groeten,
>>Bart
>>
>>
>>
>>>Hi Bart,
>>>
>>>many thanks for the files and the quick response.
>>>However my problem still exists, I've overwritten the mapserv.exe
>>>
>>>
>>and
>>
>>
>>>the others with your files, but I still don't see anything.
>>>
>>>I can't seem to find what I'm doing wrong.
>>>
>>>My mapfile looks like:
>>>
>>>
>>>
>>>
>#---------------------------------------------------------------------
>
>
>>>--
>>>----------
>>># MAPFILE Spinoffice
>>>
>>>
>>>
>#---------------------------------------------------------------------
>
>
>>>--
>>>----------
>>>
>>>#============ MAIN MAP
>>>===========================================================
>>>
>>>MAP
>>> NAME "Spinoffice"
>>> SIZE 400 200
>>> EXTENT 123161.184000 425974.862000 130445.273000 430555.785000
>>>
>>>
>>>IMAGECOLOR 255 255 0 IMAGETYPE png SHAPEPATH "shapes"
>>> SYMBOLSET "../symbols/symbols35.sym"
>>>WEB
>>> TEMPLATE "../html/mapserver.html"
>>> IMAGEPATH '/ms4w/tmp/ms_tmp/'
>>> IMAGEURL '/ms_tmp/'
>>>END
>>>
>>>PROJECTION
>>> "init=epsg:28992"
>>>END
>>>
>>>#============ LAYERS
>>>=======================================================
>>>
>>>LAYER
>>> NAME Gebouwen
>>> TYPE POLYGON
>>> STATUS ON
>>> CONNECTIONTYPE oraclespatial
>>> CONNECTION "bag/bag at maatwerk"
>>> DATA "N0320 FROM GEBOUW USING SRID 90112"
>>> PROCESSING "CLOSE_CONNECTION=DEFER"
>>> PROJECTION
>>> "init=epsg:28992"
>>> END
>>> CLASS
>>> NAME "gebouw"
>>> SIZE 1
>>> STYLE
>>> COLOR 0 255 255
>>> OUTLINECOLOR 32 32 32
>>> END
>>> END
>>>END
>>>END
>>>
>>>The url :
>>>
>>>
>>>
>http://localhost:80/cgi-bin/mapserv.exe?map=C:/Mapfiles/spinoffice.map
>
>
>>>&l
>>>ayer=gebouwen&mode=map
>>>
>>>Any help would be greatly appreciated.
>>>
>>>greetings,
>>>Erik.
>>>
>>>
>>>________________________________
>>>
>>>From: Bart van den Eijnden (OSGIS) [mailto:bartvde at xs4all.nl]
>>>Sent: zaterdag 7 januari 2006 12:22
>>>To: Ruiter E. de (Erik)
>>>Cc: hobu at iastate.edu; pnaciona at gis.umn.edu
>>>Subject: Re: FW: Mapserver for Oracle spatial 10G
>>>
>>>
>>>Hi Erik,
>>>
>>>I just built a mapserv.exe for you against the Oracle 10.2.0.1
>>>
>>>
>>libs.
>>
>>
>>>You can download from (as you probably know I can't provide you
>>>
>>>
>>with
>>
>>
>>>the oci.dll because of Oracle's license, but I am sure you have
>>>
>>>
>>that
>>
>>
>>>already on your system):
>>>
>>>http://www.osgis.nl/arcadis.zip
>>>
>>>The build info is:
>>>
>>>MapServer version 4.8.0-rc1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
>>>OUTPUT=WBMP OUTPUT =SVG SUPPORTS=PROJ SUPPORTS=FREETYPE
>>>SUPPORTS=WMS_SERVER SUPPORTS=WFS_SERVER SUP PORTS=WCS_SERVER
>>>INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=
>>>MSDEBUG
>>>
>>>Best regards,
>>>Bart
>>>
>>>Ruiter E. de (Erik) wrote:
>>>
>>> Dear Howard and Bart,
>>>
>>> Please see the mail below from me to Perry?
>>>
>>> I'm looking for mapserver binaries which support oracle 10g.
>>>
>>> Thank in advance.
>>>
>>> Greetings,
>>> Erik.
>>>
>>>
>>> -----Oorspronkelijk bericht-----
>>> Van: Pericles S. Nacionales [mailto:pnaciona at gis.umn.edu]
>>> Verzonden: vrijdag 6 januari 2006 20:06
>>> Aan: Ruiter E. de (Erik)
>>> Onderwerp: Re: Mapserver for Oracle spatial 10G
>>>
>>> Hi Erik,
>>> You might want to send Howard Butler <hobu at iastate.edu>
>>><mailto:hobu at iastate.edu> or Bart van den
>>> Eijnden <bartvde at xs4all.nl> <mailto:bartvde at xs4all.nl> as they
>>>
>>>
>>are
>>
>>
>>>the two I know who use Oracle
>>> and Windows. Howard's Windows binaries are available at
>>> http://hobu.stat.iastate.edu/mapserver/
>>>
>>> Is there a known incompatibility between Oracle 9i client and
>>>
>>>
>>an
>>
>>
>>
>>>Oracle
>>> 10g server? Give it a test and see if it does what you want.
>>>If it
>>> doesn't send Howard or Bart an e-mail.
>>>
>>> Good luck with the demo!
>>> -Perry
>>>
>>>
>>> On Friday 06 January 2006 06:34, you wrote:
>>>
>>>
>>> Hi Perry,
>>>
>>> A very happy new year to you!
>>>
>>> Please excuse me that I post this directly to you but
>>>
>>>
>>the UMN site
>>
>>
>>> seems to be down and I can't find a way to access the
>>>
>>>
>>user-list as
>>
>>
>>> someone with posting-rights. Also, we have a demo coming
>>>
>>>
>>up so we're
>>
>>
>>> in a bit of a hurry.
>>>
>>> As you can see (and maybe remember) in the mail below,
>>>
>>>
>>we use ms4w
>>
>>
>>>for
>>>
>>>
>>>
>>>
>>>
>>> our web-application. We have oracle spatial data that we
>>>
>>>
>>would like
>>
>>
>>>to
>>>
>>>
>>>
>>>
>>>
>>> visualise, however we don't have experience compiling
>>>
>>>
>>mapserver (and
>>
>>
>>> we don't want to, to be honest). I've managed to find a
>>>
>>>
>>version of
>>
>>
>>> mapserv.exe which supports Oracle spatial natively. Now
>>>
>>>
>>we want to
>>
>>
>>> upgrade to Oracle 10g but my version of mapserv.exe
>>>
>>>
>>seems to only
>>
>>
>>> support oracle 9i.
>>> Do you have or happen to know someone who has a
>>>
>>>
>>mapserver binary for
>>
>>
>>> windows with Oracle 10G support?
>>>
>>> Greetings and thanks in advance,
>>>
>>> Erik de Ruiter.
>>> Arcadis Spatial Information.
>>> The Netherlands.
>>>
>>> -----Original Message-----
>>> From: Pericles S. Nacionales
>>>[mailto:pnaciona at gis.umn.edu]
>>> Sent: dinsdag 27 september 2005 18:24
>>> To: Ruiter E. de (Erik)
>>> Subject: Re: mapserver tutorial
>>>
>>> Erik,
>>>
>>> Thanks for your interest in MapServer, the tutorial is
>>>
>>>
>>still in
>>
>>
>>>draft
>>> form but should be working. You can download it at
>>> http://hypnos.cbs.umn.edu/tutorial/tutorial.zip. You
>>>
>>>
>>will also need
>>
>>
>>> to download and install MS4W which is downloadable at
>>> http://www.maptools.org/dl/.
>>>
>>> Good luck!
>>> -Perry N.
>>>
>>> On Tuesday 27 September 2005 05:06, you wrote:
>>>
>>>
>>> Dear Perry,
>>>
>>> currently we are busy investigating different
>>>
>>>
>>webmapping
>>
>>
>>> technologies and choose one to use within our
>>>
>>>
>>web-application. To
>>
>>
>>> get acquainted with mapserver for this purpose I
>>>
>>>
>>would like to
>>
>>
>>> obtain a copy of the mapserver fro windows
>>>
>>>
>>tutorial.
>>
>>
>>> Of course I'm willing to to give you or the
>>>
>>>
>>forum feedback on my
>>
>>
>>> findings such to contribute to the further
>>>
>>>
>>development.
>>
>>
>>> thanks in advance.
>>>
>>> greetings,
>>>
>>> Erik de Ruiter.
>>> Arcadis Spatial Information (KLM Aerocarto).
>>> The Netherlands.
>>>
>>>
>>> --
>>> Pericles S. Nacionales
>>>
>>> Conservation Biology Program
>>> University of Minnesota
>>> 1530 Cleveland Ave. N., 115GrnH
>>> St. Paul, MN 55108
>>>
>>>
>>> [DISCLAIMER]
>>>
>>> Dit e-mail bericht is vertrouwelijk. Het is uitsluitend
>>>
>>>
>>bestemd voor
>>
>>
>>> de geadresseerde. Indien u niet de geadresseerde bent,
>>>
>>>
>>verzoeken we
>>
>>
>>>u
>>> dringend ons direct te informeren en om dit bericht en
>>>
>>>
>>eventuele
>>
>>
>>> bijlage(n) te verwijderen, zonder het te kopieren, door
>>>
>>>
>>te zenden of
>>
>>
>>> op enige andere wijze te openbaren of te gebruiken.
>>>ARCADIS is niet
>>> aansprakelijk voor welke schade dan ook als gevolg van
>>>
>>>
>>communicatie
>>
>>
>>> per e-mail en verzending van documenten en gegevens.
>>>
>>> This e-mail is confidential and may also be privileged.
>>>It is intended
>>>
>>>
>>>
>>>
>>>
>>> for use by the addressee only. If you are not the
>>>
>>>
>>intended
>>
>>
>>>addressee,
>>> we request that you notify us immediately and delete
>>>
>>>
>>this e-mail,
>>
>>
>>>and
>>> any attachment(s), without copying, forwarding,
>>>
>>>
>>disclosing or using
>>
>>
>>>it
>>>
>>>
>>>
>>>
>>>
>>> in any other way. ARCADIS will not be liable for damage
>>>
>>>
>>relating to
>>
>>
>>> the communication by e-mail of data or documents.
>>>
>>>
>>>
>>> --
>>> Pericles S. Nacionales
>>>
>>> Conservation Biology Program
>>> University of Minnesota
>>> 1530 Cleveland Ave. N., 115GrnH
>>> St. Paul, MN 55108
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>--
>>>Bart van den Eijnden
>>>OSGIS, Open Source GIS
>>>http://www.osgis.nl
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>-------------------------------------------------
> Univali - Webmail - http://webmail.univali.br
>
>
>
>
>
--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl
More information about the mapserver-users
mailing list