Select to view content in your preferred language

Points missing when converting large CSV table to XY Points

744
1
Jump to solution
02-24-2023 04:06 AM
CaoimheMoy
Emerging Contributor

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! 

0 Kudos
1 Solution

Accepted Solutions
DanPatterson
MVP Esteemed Contributor

Did you try

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

make the destination for the inputs a file geodatabase


... sort of retired...

View solution in original post

1 Reply
DanPatterson
MVP Esteemed Contributor

Did you try

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

make the destination for the inputs a file geodatabase


... sort of retired...