I've imported a multi-shape
shapefile with ~300.000 shapes (445MB shapefile) and a
CSV file with ~2.500.000 point coordinates into QGIS (100MB CSV file). I converted the
CSV file to
shapefile as well, resulting in a (~150MB shapefile)
My multi-shape file has a field named
CD_GEOCODI with a unique code for each shape within the file. My point data file has 3 fields:
It is easy to visually spot points within the specific shapes. I would like to add the
CD_GEOCODI variable from my multi-shape file to the export of the points
point_data, so the resulting data will now have 4 fields:
CD_GEOCODI in which the last field,
CD_GEOCODI is the
CD_GEOCODI variable from the shape which the point is within.
I've tried four methods:
Processing > Toolbox > Saga > Vector Point Tools > Add polygon attributes to points
Vector > Data Management Tools > Join by location
Install Point Sampling Tool plugin > Plugins > Analyses > Point Sampling Tool
Install MMQGIS plugin > MMQGIS > Combine > Spatial Join
All of them seem to work with small datasets but all of them freeze and make unpratical slow progress (based on the velocity of temp files growth in size, since QGIS is freezed) with my huge dataset.
My environment is: Win10 x64, qGIS 2.18.9, 6th generation i7-6700HQ, 8GB RAM, 1TB HD 5200
How can I achieve this goal with with those huge datasets in QGIS?