<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] Possibility to join PostGIS withnon spatialdbstored attribute data</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText10164 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Oh okay then I guess I misunderstood altogether. So Access was just an example datasource. I sadly must agree with Paul on this. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>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. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>If you wanted to visualize both Oracle and PostGIS data in mapserver and didn't want to move geometry into Oracle - <SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Trebuchet MS'">OGR OVF connection</SPAN> might be an option.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regina</FONT></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Paul Ramsey<BR><B>Sent:</B> Tue 5/8/2007 2:49 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Possibility to join PostGIS withnon spatialdbstored attribute data<BR></FONT><BR></DIV></DIV>
<DIV>
<P><FONT size=2>Steven De Vriendt wrote:<BR><BR>> The purpose is not focused on the PostGIS spatial functions, my main<BR>> interest is to be able to visualise both PostGIS (spatial) and Oracle<BR>> (attribute) data in MapServer.<BR><BR>At the risk of losing a PostGIS user, if your attributes are permanently<BR>inside Oracle, the most effective solution would be to move your shapes<BR>to Oracle too. That way you could join them on-the-fly in SQL inside<BR>Oracle quite efficiently. Mapserver will let you do this, as well as<BR>other tools. And for those tools that don't, you can create a view that<BR>materializes the join.<BR><BR>P<BR><BR>--<BR><BR> Paul Ramsey<BR> Refractions Research<BR> <A href="http://www.refractions.net/">http://www.refractions.net</A><BR> pramsey@refractions.net<BR> Phone: 250-383-3022<BR> Cell: 250-885-0632<BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>