topic Re: ArcGIS Pro points from export file fail geometry test in ArcGIS Pro Questions

ArcGIS Pro points from export file fail geometry test

John_Hynes — Tue, 02 Mar 2021 10:02:14 GMT

Have a working centroids table which plots. Exported the centroids XY to Excel and created a new and different CSV file using the centroid XY longitude and latitude. Then used Geoprocessing "XY table to point" tool to create new table and all table entries rejected. Errors 100160 and 000192.

Re: ArcGIS Pro points from export file fail geometry test

DanPatterson — Tue, 02 Mar 2021 10:07:17 GMT

000192: Invalid value for <value>.—ArcGIS Pro | Documentation

What does the table look like?

Re: ArcGIS Pro points from export file fail geometry test

John_Hynes — Tue, 02 Mar 2021 10:12:59 GMT

table has headings but all rows rejected

Re: ArcGIS Pro points from export file fail geometry test

DanPatterson — Tue, 02 Mar 2021 10:22:16 GMT

The Excel file? It sounds like something went wrong at that step, eg. non-numeric entries, csv issues

Re: ArcGIS Pro points from export file fail geometry test

JayantaPoddar — Tue, 02 Mar 2021 13:55:41 GMT

Could you share a sample of the XLS and CSV files for us to have a look at?

Re: ArcGIS Pro points from export file fail geometry test

John_Hynes — Tue, 09 Mar 2021 15:03:56 GMT

The problem seems to be with the XY of the centroids. These were in WEB Mercator or UTM. IRENET95 is in UTM zone 29. When I converted the centroid XY to Latitude and Longitude the Latitude was off 10 degrees and the longitude off 1/2 degrees. So the centroid values were not valid.