1

I have a layer of points containing the centroids of European NUTS regions at NUTS 3, with population data in the atttribute table. I want to aggregate this population data to NUTS level 1, which is contained in a polygon layer.

As such, I use the QGIS tool Merge attributes by location. The operation finishes without error, but the resulting summed population values in the created polygons are all very small float numbers. See the picture below for examples on input and output data:

Input and output tables

I have double checked that the source data is integers, and are formatted correctly. I also tried running the tool both from the vector menu as well as the processing toolbox.

Am I doing something wrong, or is this a bug in the QGIS spatial join?

2
  • Does it work correct if you convert the integer values to float values before doing the merge?
    – AndreJ
    Sep 18, 2014 at 12:22
  • It does work now, but I also removed some other duplicate attributes and now both the integer and float columns get properly summed. Thank you for this comment though, it sent me on the right track!
    – hexamon
    Sep 18, 2014 at 12:29

1 Answer 1

1

It seems like this happens when there are duplicate number (float or integer) columns in both the join and target layers. I removed the columns containing numbers in the input point layer that were also present in the target polygon layer, and now the population attribute is summed as expected. Although the output is still in float data form, the numbers are correct.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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