[Mapserver-users] join oracle

Fri Jun 4 11:08:10 EDT 2004

This is a multi-part message in MIME format.

--Boundary_(ID_IfUBv0HaYr8Tt1rpEI1BJA)
Content-type: multipart/alternative;
 boundary="Boundary_(ID_qaITqRF8WwB38ct287t95g)"

--Boundary_(ID_qaITqRF8WwB38ct287t95g)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT

Hi,

i'd like to know of it's possible to join some shapes (in a shape file) to Oracle. i explain:

i have one Oracle database.
i have a mapserver running, and reading some SHP files with shapes inside. These SHP files come with a DBF file of course, but with only an ID attribute. Others are in the Oracle database. And then, when i query the map i'd like to be able to retreive data from Oracle and not only from the DBF. Also, i'd like to classify my shapes with classes by taking a field filter in Oracle, not in the shape file.

Is it possible ?
Thanks.

Sylvain.
Le mans - France.

--Boundary_(ID_qaITqRF8WwB38ct287t95g)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>i'd like to know of it's possible to join some 
shapes (in a shape file) to Oracle. i explain:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>i have one Oracle database.</FONT></DIV>
<DIV><FONT face=Arial size=2>i have a mapserver running, and reading some SHP 
files with shapes inside. These SHP files come with a DBF file of course, but 
with only an ID attribute. Others are in the Oracle database. And then, when i 
query the map i'd like to be able to retreive data from Oracle and not only from 
the DBF. Also, i'd like to classify my shapes with classes by taking a field 
filter in Oracle, not in the shape file.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Is it possible ?</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Sylvain.</FONT></DIV>
<DIV><FONT face=Arial size=2>Le mans - 
France.</FONT></DIV></FONT></DIV></BODY></HTML>

--Boundary_(ID_qaITqRF8WwB38ct287t95g)--

--Boundary_(ID_IfUBv0HaYr8Tt1rpEI1BJA)--