[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