In QGIS 3, I have two layers:
Polygon layer representing properties including an attribute on the type of property: residential, commercial, industrial, open space etc.
point layer representing connections to watermains
I have used the NNJoin plugin to determine the closest point for each of the properties, and this reference is now in the property layer.
For each point, I now want to sum the number of properties of each type and add this to point layer.
Point Residential Commercial Industrial etc 1 3 0 4 2 7 2 5 ... 5000 5 5 15
I was going to export it to Excel to undertake a series of "Sum Ifs", but didn't want to take it out of GIS unless I had to.
Is there a method to achieve this in QGIS?