Points missing when converting large CSV table to XY Points

CaoimheMoy — Fri, 24 Feb 2023 12:06:04 GMT

I have a huge dataset of housing data which I am trying to upload to ArcPro and then convert to points using XYData.

Every time I convert the data using XYData and the points are created and displayed on the map, there always seems to be points missing, When I cross-reference the dataset and look for the missing points, I always find the data in the table but it hasn't converted.

When I open the uploaded tables to Arc, all points have been uploaded when compared to the initial file. The issue seems to be when I use the 'Display XY Data' function to convert to points.

The dataset being used is very large, each table having 1,000,000+ entries, is there an upper limit on how many rows Arc will convert at any one time? I cannot open in excel and split these files manually as excel also has an upper limit as to how many rows it will allow open in one workbook.

Is there a function other than 'Display XY Data' that I can use to convert the table to points on the map? Any help would be greatly appreciated!

Re: Points missing when converting large CSV table to XY Points

DanPatterson — Fri, 24 Feb 2023 14:17:09 GMT

Did you try

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

make the destination for the inputs a file geodatabase

topic Points missing when converting large CSV table to XY Points in ArcGIS Pro Questions

Points missing when converting large CSV table to XY Points

Re: Points missing when converting large CSV table to XY Points