[Mapserver-users] Oracle Spatial

Thu Jul 3 13:32:26 EDT 2003

Hi Zamil,

you should validate your geometries in the table. You can do this with 
Oracle Spatial. If your geometries are valid, mapserver should be able to 
draw them. Validate syntax is in the Oracle Spatial manual from Oracle.

About the logging of Oracle queries, I think it disappeared in the last 
version. In the old versions when you got an error you got the complete 
Oracle statement in the error messages. I think it is quite important for 
debugging purposes that this will get restored the way it used to be. 
Hopefully some of the developers have time to do this, but ofcourse now 
they are working very hard on the release of 4.0.

Best regards,
Bart

On Thu, 3 Jul 2003 11:21:13 -0600, Zamil Murji <Zamil.Murji at divestco.com> 
wrote:

> Thanks,
>
> That gets rid of my connection issues, however, I still get the same 
> message back from mapserver.
>
> Here is one record from the db (I got the SRID correct using shp2sdo):
> GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, 
> SDO_ORDINATES)
> -------------------------------------------------------------------------- 
>
>
> ------
> SDO_GEOMETRY(2, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), 
> SDO_ORDINATE_ARRAY(-109.75084, 51.670937, -109.75084, 51.670937))
>
> It is a point format, however, SDO_POINT is NULL. Will mapserver draw the 
> SDO_ORDINATES instead? If not, where do I go from here. Once again is 
> there any log of what queries the mapserver is running against the db?
>
> Thanks in advance,
> Zamil
>
> -----Original Message-----
> From: Smith, Michael ERDC-CRREL-NH
> [mailto:Michael.Smith at erdc.usace.army.mil]
> Sent: Thursday, July 03, 2003 4:16 AM
> To: Zamil Murji; mapserver-users at lists.gis.umn.edu
> Subject: RE: [Mapserver-users] Oracle Spatial
>
>
> Having the SDO_POINT = NULL is correct if this is a non point shapefile.
>
> If the SRID is NULL don't include it in the data statement
>
> Use DATA "GEOMETRY FROM OILWELLS"
>
> You're problem is the Connecttion statement (CONNECTION 
> "sdb/sdb at 10.0.50.30")
> The correct format is user/password at tnsname
>
> You need to define a tnsname that points to the correct host, port and 
> sid.
> There are various tools to do this (Oracle Net Manager, edit the 
> tnsnames.ora)
>
> In the tnsnames.ora file you would have
>
>
> TNSNAME.DOMAIN.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.50.30)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = your_service_name_here)
> )
> )
>
> Then you connection string would be CONNECTION "sdb/sdb at tnsname"
>
>
> Mike Smith
> email: michael.smith at erdc.usace.army.mil
> RSGISC
> ERDC - CRREL Hanover, NH  03755
> (603) 646-4765
>
>
>
> -----Original Message-----
> From: Zamil Murji [mailto:Zamil.Murji at divestco.com] Sent: Wednesday, July 
> 02, 2003 5:50 PM
> To: mapserver-users at lists.gis.umn.edu
> Subject: RE: [Mapserver-users] Oracle Spatial
>
>
> After using the oracle tools to convert my shapefile into an oracle 
> spatial format, this is what I have:
>
> SQL> select * from oilwells where gid = 1;
>
> GID
> ----------
> GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, 
> SDO_ORDINATES)
> -------------------------------------------------------------------------- 
>
>
> ------
> 1
> SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), 
> SDO_ORDINATE_ARRAY(
> -112.08855, 48.9998283, -112.08855, 48.9998283))
>
>
> SQL>
>
> Notice that the SDO_POINT(X, Y, Z) column is NULL. Can mapserver handle 
> this case. I guess the otn utilities utilize the last two columns.
> Also note that the SRID is null. When i draw my image, I get the 
> following error message:
> msDrawMap(): Image handling error. Failed to draw layer named 'oilwells'.
>
> Here is my .map definition for this layer.
> LAYER
> NAME "oilwells"
> TYPE point
> STATUS default
> CONNECTIONTYPE oraclespatial CONNECTION "sdb/sdb at 10.0.50.30" DATA 
> "GEOMETRY FROM OILWELLS USING SRID NULL" #   DUMP TRUE MAXSCALE 20
> SYMBOLSCALE 2
> CLASS
> SYMBOL 3
> SIZE 12
> MAXSIZE 28
> MINSIZE 4
> END
> END
>
> I am using mapserver 3.6.6 precompiled with oracle spatial support from 
> the mapserver downloads page.
>
> Any help would be greatly appreciated. Thanks
> Zamil
>
> -----Original Message-----
> From: Zamil Murji Sent: Wednesday, July 02, 2003 2:36 PM
> To: bartvde at xs4all.nl; mapserver-users at lists.gis.umn.edu
> Subject: RE: [Mapserver-users] Oracle Spatial
>
>
> Thanks Bart for the quick reply...
>
> I was able to convert my shapefiles into oracle spatial format using some 
> tools on otn. Using those tools they insert NULL as the SRID. Will this 
> cause grief? According to the WIKI you had to specify a SRID otherwise 
> you got a mapserver error. Is this correct?
>
> Is there any way to see what query mapserver will be running? Like a log 
> file or something of the sort.
>
> In the connection string, does service refer to the ip address?
>
> Thanks in advance,
> Zamil
>
> -----Original Message-----
> From: Bart van den Eijnden [mailto:bartvde at xs4all.nl]
> Sent: Wednesday, July 02, 2003 12:22 PM
> To: Zamil Murji; mapserver-users at lists.gis.umn.edu
> Subject: Re: [Mapserver-users] Oracle Spatial
>
>
> Hi Zamil,
>
> otn (Oracle technology network) is the best site for Oracle information. 
> Oracle itself has a tool to import shapefiles into Oracle Spatial.
>
> http://otn.oracle.com (you can register for free)
>
> The easiest to use is the built-in Oracle Spatial support. To use the 
> support through OGR, you have to compile OGR against the Oracle client 
> library.
>
> See also the mapserver wiki Oracle Spatial page:
> http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?OracleSpatial
>
> Best regards,
> Bart
>
> On Wed, 2 Jul 2003 12:03:19 -0600, Zamil Murji <Zamil.Murji at divestco.com> 
> wrote:
>
>> Hello list,
>>
>> I want to use MapServer to draw an Oracle Spatial layer, however, I have 
>> never used Oracle Spatial. I have some questions I am sure you will be 
>> able to answer.
>>
>> 1) What utilities are available to import a shapefile into an Oracle 
>> Spatial database? Where can I download them from? 2) Need to know some 
>> good sites on how to setup Oracle 8i with the Spatial component, and I 
>> need a quick tutorial on how to create a table, alter a table, insert 
>> and select from that table. Any good sites?
>> 3) I read on the newsgroup that there are two ways to go about this. One 
>> is to use the built in oracle spatial support and the other is to use 
>> ogr. I am running Apache on a windows 2000 box, what way is the best to 
>> go, easiest to setup?
>>
>> Thanks for your help
>> Zamil
>>
>> -----Original Message-----
>> From: Eduardo Patto Kanegae [mailto:eduardo at linkgeo.com.br]
>> Sent: Wednesday, June 25, 2003 8:44 AM
>> To: mapserver-users at lists.gis.umn.edu
>> Cc: niklas "wÃ¶rmann
>> Subject: Re: [Mapserver-users] running v4 beta as a command line tool
>>
>>
>> I've tested on MapServer 3.6.4 for Windows, using:
>>
>> $ mapserv "QUERY_STRING=map=c:\test\mymap.map&mode=map&foo=...." > 
>> myresult.gif
>>
>> but if you try to open "myresult.gif" it crash...
>>
>> so I opened this file with a text editor and deleted the first two 
>> lines(the headers), then it works!
>>
>> regards
>>
>> Eduardo Patto Kanegae
>> eduardo at linkgeo.com.br
>> http://www.linkgeo.com.br
>>
>> ***************************************
>> ***Fim da Mensagem / End of Message ***
>> ***************************************
>>
>>
>> On Wed, 25 Jun 2003 14:43:41 +0200, Vincent Schut <schut at sarvision.com> 
>> enscreveu:
>>
>>> De: Vincent Schut <schut at sarvision.com>
>>> Data: Wed, 25 Jun 2003 14:43:41 +0200
>>> Para: niklas wÃ¶rmann <nwoe at privat.utfors.se>,   <mapserver- 
>>> users at lists.gis.umn.edu>
>>> Assunto: Re: [Mapserver-users] running v4 beta as a command line tool
>>>
>>> On Wednesday 25 June 2003 10:06, niklas wÃ¶rmann wrote:
>>> > Hi!
>>> > i am trying to track down the reason mapserver isnÂ´t working on my 
>>> windows
>>> > 2000 server.
>>> >
>>> > i remember seeing somewhere that it was indeed possible to run 
>>> mapserver as
>>> > a command line tool, specifying a map file and an output file
>>> >
>>> > anyone know the syntax for this?
>>>
>>> On linux:
>>> ./mapserv "QUERY_STRING=map=/path/to/your/mapfile.map&mode=map"
>>> This will output headers + image data to stdout (on linux). Probably on 
>>> windows your executable is not named mapserv but something like 
>>> mapserv.exe? And use \ instead of / I think.
>>>
>>> you cannot just save the output as image file because the headers are 
>>> in the output too.
>>> But you can see if it outputs something (lots of ascii: image), or 
>>> gives an error.
>>> To see the image: type in your browser:
>>> http://localhost/cgi-bin/mapserv?map=/path/to/your/mapfile.map&mode=map
>>> change / in path to \ if on windows?
>>>
>>> Regards,
>>> -- ______________________________________
>>> Vincent Schut
>>> Sarvision B.V.
>>> Wageningen, The Netherlands
>>> www.sarvision.com
>>>
>>> _______________________________________________
>>> Mapserver-users mailing list
>>> Mapserver-users at lists.gis.umn.edu
>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>
>>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>>
>
>
>

-- 