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

[Paul Ramsey]

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
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632