I have two layers. One point layer and a Polygon layer. It is simple to count the points in the polygon layer by the "points in polygon" function. But I also need some more information of the point layer in the polygon layer.

For example:

The point layer includes information of the company name (and some more) of every point.

--> I need the number of Points in the polygon layer but also some information about how many stores of company XYZ are in the polygon

I tried my luck with the "select by location" function but this works just the other way round (I can create a point layer with all necessary information but not a polygon layer because the function only uses the "attributes of the first exact object".

The other possibility of chosing a summarization is not in my interest because I need to keep all information - anyway it does not work because my column names will be to long after creating it.

I will add a screenshot to better explain my problems (it is the german version and I am actually working in France so please try to overlook my faults ;)

point and polygone attribute tables

  • Have a look at: this post for summing a value from a points layer for each polygon in a polygon layer.
    – Micha
    Aug 13 '13 at 9:45
  • Install the MMQGIS plugin and use the 'spatial join' tool
    – Rob Lodge
    Nov 13 '13 at 16:14

One approach would be to add to each point the information about which region it is in, eg. using the Add polygon attributes to points tool. Then you can use Group Stats' pivot table functionality to count the number of points per company per region. You would have region IDs in the rows, company names in the columns, and the count function in value:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.