I need to prepare a GIS for a customer. They insist to use a MySQL-Database (not the best option, I know). They need to digitize some geometries (areas) and add some attributes. The geometries and attributes will be stored in one table in the database. They have some third-party shapefiles they want to display, such as parcels or natural parks. No problem so far.
My issue: Each digitized geometry needs to have the id and other attributes of the parcels or parks wich intersect the geometry. I prefer an all automatic solution wich adds these attributes as soon as I digitize a new geometry. But as far as I know I can do only a static intersection-analysis with sextante.
How can I add the attributes from the analysis to mySQL? (maybe in a action?)
I'm new to QGIS.