My task is to work with bird observation data in an area, that is divided into zones as different polygons (A1, A2, etc.).
I have the hand-written lists of observations and want to bring all entries into a database. My idea was to create a point feature somewhere in the corresponding zone for each line, and then enter all data that is provided (Species, number, begin of observation, end of observation, etc ...) with a custom form.
I also need to have the polygon ID in the data, which I of course could enter manually, but I would rather prefer to learn how to include it automagically by querying to position of the point over the polygon and extract the polygon ID somehow.
As I want to work with a spatialite database, i thought about creating a trigger that queries the polygon the new point is created above and include the ID in my point data.
My problem: I have no idea how to start and can't find examples on that.
Anyone some ideas?