AnsweredAssumed Answered

Spatial join with HUGE datasets

Question asked by mfrias on Jul 16, 2015
Latest reply on Jul 23, 2015 by GUpchurch-esristaff

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

Match: intersect


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.)