Spatial join with HUGE datasets

[المشرف العام]

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



أكثر...