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

Paul Ramsey pramsey at refractions.net
Tue May 8 14:20:22 PDT 2007


Having spatial and attributes separate is *VERY* common, it is just also 
very bad design. You get best leverage from your tools when they are 
together. As Regina pointed out, the OGR connection might give you some 
dynamic joining possibilities. Also check out the Mapserver JOIN 
capabilities.

P

Steven De Vriendt wrote:
> 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
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632



More information about the postgis-users mailing list