I have two layers:
- Survey Points
- Habitat Multi polygon
The Survey points contain the field sensitivity
I want to assign a number to each polygon based on the modal average sensitivity.
This thread has a similar theme
There is no way to do this inside QGIS so I've had to resort to using PostgreSQL. I've found an example to experiment with but it do not know how to incorporate the spatial aspect between datasets.
In summary I'm looking for help on how to script SQL to find the modal point value per polygon and attach it to the polygons attribute table.