Am Mittwoch, 22. November 2006 14:25 schrieb [EMAIL PROTECTED]: > I have already asked a similar question but I really need an advice on > how to best implement connection from pmapper to Oracle. I have a > polygon shapefile holding my city buildings. Its dbf file has an column > with an building ID but the rest of attribute data that I need to > display in a query result table is held in Oracle 9i database. These > data are very dynamic so I have to dynamically connect to Oracle and get > the data when I click on a building with "Identify" or through the > attribute search. > > I don't know if anything is possible through the mapserver. If not, what > is the way to go to support it in p.mapper? > > I would appreciate any suggestion. Thanks very much.
You could OGRs virtual table[0] for the joining.
I have done this successfully with attribute-data from a mysql.table joined to
a shapefile dynamically.
But I am not sure if this also works with Oracle. I assume you need to compile
OGR with oracle-support, but I am not entirely sure.
HTH
Stephan
[0] http://ogr.maptools.org/drv_vrt.html
--
Stephan Holl : www.intevation.de/~stephan | GISpatcher: www.gispatcher.de
Intevation GmbH: www.intevation.de | GAV e.V.: www.grass-verein.de
Georgstr.4 : 49074 Osnabrück |
pgpMD6o7ZEFAv.pgp
Description: PGP signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
