On 11/22/05, Abe Gillespie <[EMAIL PROTECTED]> wrote: > I just read the post "can this be done" and then found this: > > http://ms.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData > > This makes me think it might be possible to join a layer to an ODBC > table. Previously I thought it was only possible to join to a DBF. > Is this possible? I'd like to join an Access DB to a MapServer layer.
Abe, It should be possible to join a table from an access database to feature data using the above mechanisms as long as the feature data is already read through ODBC. You might want to read over some of the caveats with regard to OGR SQL JOINs at: http://www.gdal.org/ogr/ogr_sql.html Amoung other things, performance will often suffer using this approach unless you have few features, or the ODBC datasource is indexed well. Best regards, -- ---------------------------------------+-------------------------------------- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Programmer for Rent
