I have already built a desktop application for the management of archaeological settlements. Currently the data are stored in shapefiles (spatial data) and MYSQL (descriptive information). The application is based on MapWindow and MapWindow plugins. In the database there are some relationships between tables (one-to-many, many-to-many).
I need to convert my application to a web mapping application. I intend to share my spatial data with GeoServer. The web application should have forms to search the descriptive data of mysql and tools to select and zoom to the corresponding spatial data. Almost all the existed web mapping solutions have query capabilites but only on the spatial data (i.e. fields of a shapefile). Unfortunately my data are stored separately in mysql.
What's the best solution to implement my web mapping application? Do I have to make custom tools? I intend to use Geomoose and some special plugins or Mapbender. Are they the appropriate platforms?
I need a platform to join the spatial data and my mysql data in a easy and usefull way. I try to avoid extra programming for the forms and the connection between spatial and descriptive data.