[postgis-users] Possibility to join PostGIS withnon spatialdbstored attribute data

[Obe, Regina]

Oh okay  then I guess I misunderstood altogether.  So Access was just an example datasource.  I sadly must agree with Paul on this. 
 
Depending on the version of Oracle you have - I think the Oracle Locator option comes freely packaged in which will give you basic spatial functionality - not advanced, but perhaps enough to get you by.  Not quite as detailed as PostGIS as I recall from the literature, but I've never worked with it. 
 
If you wanted to visualize both Oracle and PostGIS data in mapserver and didn't want to move geometry into Oracle  - OGR OVF connection might be an option.
 
Regina
________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Paul Ramsey
Sent: Tue 5/8/2007 2:49 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Possibility to join PostGIS withnon spatialdbstored attribute data



Steven De Vriendt wrote:

> The purpose is not focused on the PostGIS spatial functions, my main
> interest is to be able to visualise both PostGIS (spatial) and Oracle
> (attribute) data in MapServer.

At the risk of losing a PostGIS user, if your attributes are permanently
inside Oracle, the most effective solution would be to move your shapes
to Oracle too. That way you could join them on-the-fly in SQL inside
Oracle quite efficiently. Mapserver will let you do this, as well as
other tools. And for those tools that don't, you can create a view that
materializes the join.

P

--

   Paul Ramsey
   Refractions Research
   http://www.refractions.net <http://www.refractions.net/> 
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070508/438b12e9/attachment.html>