[Mapserver-dev] MySQL feature data joins
David Horowitz
dahoro at umd.edu
Wed Jun 16 15:19:21 EDT 2004
Hello all,
I'm writing an application which gets its spatial data from shapefiles but its feature data from a SQL data source (either MySQL or Oracle). I have read the Wiki topic "JoinDatasources" but did not find its explanation of how to go about this sufficient. Any help here would be appreciated.
To be more specific, I have all my data loaded into a MySQL database (using the shp2mysql tool). Supposing the source shapefile is "statemap.shp" and the feature column I wanted to access in my database was called "title" what would my mapfile entry look like? Is using a join the way to go about solving this problem?
Thanks in advance.
More information about the mapserver-dev
mailing list