Recommended method to assign values from CSV files back to population cluster shapes?

OnSSET Troubleshooting
1

Hi there,

What is the recommended method (Python and/or QGIS tool) to assign the values from the CSV files (points) back onto the cluster shapes (vectors)?
I’d like to make sure I’m doing it in the most consistent and efficient way to reduce any potential errors, both for results from OnSSET and for the inputs after extracting the spatial data for the clusters.

Thanks for any tips or experience!

Regards,
Gregory

2

Hello,

Personally I prefer Python.

Both GIS or Python works though. Just make sure to merge the clusters with the output file by matching the ids (using locations will not work). In Python do it with geopandas and in QGIS do it with the tool called “join attributes by field value”. For QGIS make sure that the field type of the cluster’s ids are the same as the field type of the ids in the CSV. After merging you should have two id columns, in order to check that everything is correct I guess you can subtract one from the other, if you only get 0’s everything should be correct.

Best,
Babak

3

For the purpose of visualization / creating maps, this process is described in Hands-On Exercise 6 in the latest version of the OpenLearn training material.