topic Assigning census tract to lat/long coordinates? in Data Management Questions https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723718#M40991 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Wed, 12 Jun 2019 17:53:37 GMT AngieWerner 2019-06-12T17:53:37Z Assigning census tract to lat/long coordinates? https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723718#M40991 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Wed, 12 Jun 2019 17:53:37 GMT https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723718#M40991 AngieWerner 2019-06-12T17:53:37Z Re: Assigning census tract to lat/long coordinates? https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723719#M40992 <HTML><HEAD></HEAD><BODY><P>Hi Angie,</P><P></P><P>You can convert the CSV table to a point feature class using the <A href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/xy-table-to-point.htm">XY Table To Point</A> tool.&nbsp; Then execute a <A href="https://pro.arcgis.com/en/pro-app/tool-reference/analysis/spatial-join.htm">Spatial Join</A> with the Census Tract feature class.</P></BODY></HTML> Wed, 12 Jun 2019 18:12:42 GMT https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723719#M40992 JakeSkinner 2019-06-12T18:12:42Z Re: Assigning census tract to lat/long coordinates? https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723720#M40993 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.esri.com/migrated-users/8586">Jake Skinner</A>‌! 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.</P></BODY></HTML> Thu, 13 Jun 2019 23:06:27 GMT https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723720#M40993 AngieWerner 2019-06-13T23:06:27Z Re: Assigning census tract to lat/long coordinates? https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723721#M40994 <HTML><HEAD></HEAD><BODY><P>For a CSV this large, I would recommend using <A href="https://www.esri.com/en-us/arcgis/products/arcgis-geoanalytics-server">GeoAnalytics Server</A>.&nbsp; This essentially will dedicate a server to perform the <A href="https://enterprise.arcgis.com/en/portal/latest/use/perform-big-data-analysis.htm#ESRI_SECTION1_B222A3C999C74BBBA717278E05279DBF%20">analysis</A>.&nbsp; You could register the CSV directory as a <A href="https://enterprise.arcgis.com/en/portal/latest/use/what-is-a-big-data-file-share.htm">big data file share</A>.&nbsp; Then execute the <A href="https://enterprise.arcgis.com/en/portal/latest/use/geoanalytics-join-features.htm">Join Features</A> tool on the datasets.</P></BODY></HTML> Fri, 14 Jun 2019 11:48:31 GMT https://community.esri.com/t5/data-management-questions/assigning-census-tract-to-lat-long-coordinates/m-p/723721#M40994 JakeSkinner 2019-06-14T11:48:31Z