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

[Steven De Vriendt]

Ok, thanks Paul and Regina for clearing this up.
I thought this was quite a common use and situation...apparantly it's not.
However seems like there are quite some options; I'll have a look
at them all before doing things I'll regret in the end.
Thanks for your expertise on this matter !

Regards,
Steven


On 5/8/07, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
>
>
>
> 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
>    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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>