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

Outcomes