Counting points in polygon using weight and class simultaneously

Question

I am using QGIS 3.1. I am wondering if there is a way to count points in polygons but by using both the weight and class.

For example, I have distributions of a number of species, each with a unique 'score'. I want to count each occurrence of a unique species (class - species), then weight each occurrence by its score (weight - score) in a grid.

Doing each of these is very simple using the count points in polygon feature but I can't do both at once.

Answer 1

You can achieve this using a virtual layer.

It would join the grid layer to the point layer based on spatial intersection, then sum the weights and divide by the count for each grid polygon.

Go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the following query. Replace the layer name for yours

select g.*, sum(p.weight) / count(*)
from grid_layer g 
  join points p 
    on st_intersects(p.geometry,g.geometry)
where  p.class = 'species_abc'
group by g.id