I use GDAL's ODBC driver to join to the mdb:
CONNECTIONTYPE OGR
CONNECTION 'G:/GeoData/Parcels/Alberta/t_505033.shp'
DATA "SELECT * FROM t_505033 LEFT JOIN
'ODBC:Parcels_Rural,basic'.basic ON t_505033.PID=basic.PID"
allowing me to use values from the table "basic" in the mdb for
labeling, etc:
LABELITEM 'LINC'
CLASSITEM 'STATUS'
Best Regards,
Brent Fraser
On 11/18/2011 9:22 AM, boesiii wrote:
I have a polygon shapefile showing parcel outlines and an access database
containing owner names. I would like add a layer displaying the owner name
but after reading the MapServer documentation "You cannot use joins to
affect the look of a map", I realize this is not possible.
Is there any other way to accomplish what I am trying to do?
Is there an OGR/GDAL command line function that will export the table from
the MDB to DBF file?
I know I can join the files together using ESRI ArcGIS but was hoping to
leave the files in the original format because the data is maintained by
someone else.
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/How-to-join-to-a-MDB-database-for-display-on-my-map-tp7008818p7008818.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
