How to make a spatial join with ArcGIS with these HUGE datasets?
Target: almost 3 million squares 500x500m size (the attribute table is basically empty)
Join feature: 12000 polylines
Operation: one to many
All my attempts have failed:
From the Spatial Join tool in the Toolbox: after 15 min the output is a file where no join has been made (Join_Count field is 0 in all rows)
From the dialog box: It seems to work but my estimate is that it takes 4 days to complete - without any guarantee the output will be correct.
It works when I do a Spatial Join of a small area.
Any ideas on how to do this in a proper way?
I am using file geodatabase, ArcGIS 10.2, background processing, 23 GB RAM
(The idea is to overlap those polylines to the grid (the 500x500m squares). I will then make a dissolve to find out how many lines are in each square. Finally, I will make a density map.)