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: lat
, long
and var1
.
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: lat
,long
,var1
,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?
point_data
to *.shp. Will edit the question to clarify