topic How to deal with large dataset in ArcGIS when geocode using long/lat? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/how-to-deal-with-large-dataset-in-arcgis-when/m-p/575593#M19026 <HTML><HEAD></HEAD><BODY><P>I am doing a very simple tasks: I have data with long\lat information and I am using Display X/Y data in ArcMap to display them first in ArcMap, then export it to a geodatabase as a feature class. The problem is the data is huge for me: 7 millions records with about 20 fields. It takes me about 3 days to complete the task of display X/Y data, then when I tried to export the displayed X/Y data, it crashed so far as I tried. I wonder how I should deal with big data in ArcGIS?</P></BODY></HTML> Mon, 20 May 2019 00:56:08 GMT HaoHuang 2019-05-20T00:56:08Z How to deal with large dataset in ArcGIS when geocode using long/lat? https://community.esri.com/t5/geoprocessing-questions/how-to-deal-with-large-dataset-in-arcgis-when/m-p/575593#M19026 <HTML><HEAD></HEAD><BODY><P>I am doing a very simple tasks: I have data with long\lat information and I am using Display X/Y data in ArcMap to display them first in ArcMap, then export it to a geodatabase as a feature class. The problem is the data is huge for me: 7 millions records with about 20 fields. It takes me about 3 days to complete the task of display X/Y data, then when I tried to export the displayed X/Y data, it crashed so far as I tried. I wonder how I should deal with big data in ArcGIS?</P></BODY></HTML> Mon, 20 May 2019 00:56:08 GMT https://community.esri.com/t5/geoprocessing-questions/how-to-deal-with-large-dataset-in-arcgis-when/m-p/575593#M19026 HaoHuang 2019-05-20T00:56:08Z Re: How to deal with large dataset in ArcGIS when geocode using long/lat? https://community.esri.com/t5/geoprocessing-questions/how-to-deal-with-large-dataset-in-arcgis-when/m-p/575594#M19027 <HTML><HEAD></HEAD><BODY><P>Is the data in an Esri format?</P><P>ie if you are using an Excel Spreadsheet or CSV file</P><P><BR />Use a tool like Excel to Table&nbsp; (or Table to table - if CSV) and convert the Excel Spreadsheet&nbsp;(into a Esri Geodatabase Table</P><P>Once you have done this you could (depending on your data set) use a tool like Split by attributes to make the data more manageable.</P><P></P><P style="color: #4d4d4d; background-color: #ededed; font-size: 0.875rem; margin-top: 0em; margin-bottom: 1.71429em;">Once it is in an Esri Format As an alternative, you can use the<SPAN>&nbsp;</SPAN><SPAN class="" style="font-weight: bold;">Catalog</SPAN><SPAN>&nbsp;</SPAN>window to select the table that contains the x,y columns and create a feature class.</P><P><IMG alt="Creating a feature class from x,y data in the Catalog window" src="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/GUID-37F94E7C-D3ED-4432-ADBD-99E93419C135-web.png" style="border: 0px;" title="Creating a feature class from x,y data in the Catalog window" /></P><P></P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/adding-x-y-coordinate-data-as-a-layer.htm">http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/adding-x-y-coordinate-data-as-a-layer.htm</A></P></BODY></HTML> Mon, 20 May 2019 02:51:08 GMT https://community.esri.com/t5/geoprocessing-questions/how-to-deal-with-large-dataset-in-arcgis-when/m-p/575594#M19027 JohnPlunkett 2019-05-20T02:51:08Z