I have a set of over 20,000 villages in xls that only have a ward assigned to them - no coordinate. I do have a ward shapefile. Now I have created a data set of random points (shp) and spatially joined the ward information. So all my random points within the ward state the name of the ward they are in.
Now I want to match each of the 20,000 villages (xls) to one random point (shp), based on the ward value, so that at least the villages are within the right ward.
Since the village data has no coordinates I cannot do a spatial join. So I am left doing a regular join. When I add the table (xls) to the randomized points (shp) and use the ward as the common id it writes the same (first) village with the ward to all random points within that ward. So all random points in that ward have the same village name.
But What I need is that each random point receives a different village name from my table. I hope this makes sense. I basically need a one to one join for each village in my table so that each village falls within the correct ward.
Any ideas on how this could work? Can use either QGIS or ArcGIS 10.3
أكثر...
Now I want to match each of the 20,000 villages (xls) to one random point (shp), based on the ward value, so that at least the villages are within the right ward.
Since the village data has no coordinates I cannot do a spatial join. So I am left doing a regular join. When I add the table (xls) to the randomized points (shp) and use the ward as the common id it writes the same (first) village with the ward to all random points within that ward. So all random points in that ward have the same village name.
But What I need is that each random point receives a different village name from my table. I hope this makes sense. I basically need a one to one join for each village in my table so that each village falls within the correct ward.
Any ideas on how this could work? Can use either QGIS or ArcGIS 10.3
أكثر...