nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

2.9 Display XY data, and Coordinate Table to Point Error Invalid SQL statement used

MichelleWilliamsERM

I've tried all the normal tools to get this to work, but I think the underlining code is broken.

Please help.

Esri9.0 error coord tried DDM csv.png

Esri9.0 error coord tried DDM.png

Esri9.0 error coord tried float and double.png

Esri9.0 error coord tried Show XY from csv.png

Vind meer berichten getagd met

Analysis

Geodatabase

Desktop

Accepted answers

danretired

why don't you show some of your table since I have used those tools many times.

Things that can go wrong... too many to list, but blank entries, wrong text encoding, punctuation within text, ... symbols in text (like a degree symbol) etc etc etc.

Excel to table is pretty good, but will fail if a lot of rules aren't followed. Excel to csv ... same thing.

I suspect your issue is within the table

All comments

MichelleWilliamsERM

Thank you everyone for you comments, I had a teammate try it on his 2.8 software and it broke, so with more digging we found a " in the header from another field.

danretired

why don't you show some of your table since I have used those tools many times.

Things that can go wrong... too many to list, but blank entries, wrong text encoding, punctuation within text, ... symbols in text (like a degree symbol) etc etc etc.

Excel to table is pretty good, but will fail if a lot of rules aren't followed. Excel to csv ... same thing.

I suspect your issue is within the table

MichelleWilliamsERM

@DanPatterson, can you tell me that this tool works for you in Pro 2.9?

I've tried both suggestions, and I get the error when I try to open the attribute table.

Here's my workflow;

csv file to table to points (but I haven't gotten to the points yet).

I also tried importing the Excel table to points.

ArcPro XY error 2.png

ArcPro XY error.png

danretired

DD2, aka decimal degrees, 2 fields is the default,

your field type latfloat, should work

I would suggest

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

to ensure nothing is wrong fundamentally with the data ot

Make XY Event Layer (Data Management)—ArcGIS Pro | Documentation

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Inloggen
Registreren

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.