Assigning census tract to lat/long coordinates?

642
3
06-12-2019 10:53 AM
AngieWerner
New Contributor

I have CSV files that are massive (daily records for each census tract for all states). I need a way to quickly assign census tract to each lat/long coordinate. Thank you!

0 Kudos
3 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Angie,

You can convert the CSV table to a point feature class using the XY Table To Point tool.  Then execute a Spatial Join with the Census Tract feature class.

AngieWerner
New Contributor

Thanks Jake Skinner‌! I did start doing that, but I ended up getting stuck on the spatial join. The CSV file has ~20 million records, so I don't know if there's a more efficient way of doing it. I left it running the join for a long time and the progress bar only moved a teeny bit.

0 Kudos
JakeSkinner
Esri Esteemed Contributor

For a CSV this large, I would recommend using GeoAnalytics Server.  This essentially will dedicate a server to perform the analysis.  You could register the CSV directory as a big data file share.  Then execute the Join Features tool on the datasets.

0 Kudos