[Mapserver-dev] virtualising attribute data

[Daniel Morissette]

Attila Csipa wrote:
> I was thinking about the possibilities of virtualising attribute data for my 
> needs, meaning that for example a layer that has spatial data in a shapefile 
> has the attribute data in plain mysql (this is how it works in my prototype 
> test and happens to be the most requested feature that I got). Note that this 
> is _not_ the same as doing a join and not like using virtualspatialogr. 

Have you thought about using an OGR SQL join? I think that would do 
exactly what you need. Look for JOIN in http://ogr.maptools.org/ogr_sql.html

I don't think OGR supports MySQL directly (maybe it does?), but you 
could connect to MySQL or most other databases through OGR's ODBC driver.

Daniel
-- 
------------------------------------------------------------
  Daniel Morissette               dmorissette at dmsolutions.ca
  DM Solutions Group              http://www.dmsolutions.ca/
------------------------------------------------------------