Dear All, I have a problem with my GIS project at the moment.
My *.shp database stores lotnumber which is a character ranged from "00001" to "58000" (give or take a few hundred..) my SQL table links this lotnumber to a projectID, for example "00001" to "10060", "00002" to "10103" etc. What I want to do is when a user queries a polygon in my map (I am using Cartoweb3), I want the user to see the data from the *.shp database as well as the data from the SQL database. In other words, I want to join this two tables and display them in Cartoweb when the user queries them. something like this: lotnumber | landuse | projectID ------------------------------------------ 00001 | housing area | 10060 * lotnumber and landuse column is from *.shp, whilst projectID is from MySQL. Any suggestion? any help or lead is greatly appreciated. Thank you in advance. -- View this message in context: http://www.nabble.com/GIS%3A-Display-Data-from-MySQL-in-Cartoweb-tp18540317p18540317.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
