[mapserver-users] oraclespatial query issue
ychen at yorktel.com
Thu Mar 28 15:27:35 EST 2002
OK, Rod. If you need someone Beta test for you, I'll be glad to do it.
From: Rodrigo Cabral [mailto:cabral at yadata.net]
Sent: Wednesday, March 27, 2002 7:59 PM
To: Yu-Hsin Chen
Cc: mapserver-users at lists.gis.umn.edu
Subject: Re: [mapserver-users] oraclespatial query issue
Nope, I guess not. If you want to use CGI, then you'll need to wait
finish the integration between MapServer and Oracle, which I scheduled
end of April, early May (finally!). You're right though, I still prefer
using the solution I pointed in January 11, 2002:
If you can wait, it won't be long until SDO support is working 100%. On
other hand, you might still try to setup PHP with Oracle, which will
you to work this bug around plus doing lots of other cool stuff =) I'll
in the 'list in case you need some help compiling PHP with the SDO
(although this list may not be the most suitable place for the
it's a MapServer list afterall).
----- Original Message -----
From: "Yu-Hsin Chen" <ychen at yorktel.com>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Wednesday, March 27, 2002 6:25 PM
Subject: [mapserver-users] oraclespatial query issue
Most likely Rod, or anyone else has experience with what I'm about to
I'm running mapserv from cgi-bin to call a map file on Mandrake Linux
8.0 running Oracle 8.1.7. The layer from the map file related with
Oracle is at the end of this message.
In my database I have a zcta table which contains Oracle's SDO data.
Then I have a service_order table which contains my application data.
My goal is to display rooms from service_order on a map and when a room
is clicked I can display a page with more information about the room.
I displayed the rooms without any problem and I can even label them with
my room_id's. When I try to query them I received the error which Rod
explained and provided solution on his Jan 11, 2002 message using php.
Unfortunately, I'm having problems getting PHP 4.0.6 up with Oracle
option. I'm wondering since I retrieved room_id and service_no from the
database and displayed on the map, are they stored somewhere in a buffer
that I can refer to when I want to query the point on the map? I've
been successful with data querying by passing the room_id into a perl
cgi program if my layer data is from a shp file.
CONNECTION 'mdsys/pw at orcl'
DATA "geometry from (select room_id, service_no, geometry from zcta z,
service_order s where z.zipcode=s.zip)
COLOR 0 255 0
COLOR 0 51 51
OFFSET 10 10
More information about the mapserver-users