1

I have two layers: 1. One with polygons geometry 2. CSV table with more than 600k rows

They have an atribute ID in common, so, I want to distribute randomly each row, inside the polygon as a point. I'm using QGIS 3.4

Vince
  • 20,017
  • 15
  • 45
  • 64
carolina passos
  • 151
  • 2
  • 2
    Your question is slightly confusing. Does layer 1 have just one polygon or many? If it has many, does the common ID link an attribute row to a particular polygon? – Stu Smith Aug 20 '19 at 04:44
  • Sorry about that!hehe I was tired...Yes! the layer with geometry has lots of polygons, and both layers have a common ID to link it! – carolina passos Aug 20 '19 at 22:41

1 Answers1

2

QGIS has a tool for creating random points within a polygon. You can use it to populate the number of random points you want. Then join the points layer with the CSV table on the point's id attribute with the table's row index.

Vector > Research Tools > Random Points Inside Polygons https://docs.qgis.org/3.4/en/docs/user_manual/processing_algs/qgis/vectorcreation.html#qgisrandompointsinsidepolygons

If the CSV table doesn't have a field that can be joined, try to calculate the row index. Save the CSV as a GeoPackage to make the attributes editable (reason). Then use the Field Calculator to compute the index with the expression "@row_number".

NHorner
  • 83
  • 1
  • 8
  • My problem is: the CSV layer has all the information that I need (700k rows), so, I want to join the geometry/polygon reference from the other layer (96 polygons) to that, not the contrary. I don't know if I'm explaining well. When I joined both layers, it compressed my 700k rows to the 96... – carolina passos Aug 20 '19 at 22:48