topic Re: 2.9 Display XY data, and Coordinate Table to Point Error Invalid SQL statement used in ArcGIS Pro Questions

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

MichelleWilliamsERM — Sat, 08 Jan 2022 19:37:56 GMT

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

Please help.

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

DanPatterson — Sat, 08 Jan 2022 20:14:54 GMT

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

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

MichelleWilliamsERM — Tue, 11 Jan 2022 01:01:12 GMT

@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.

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

DanPatterson — Tue, 11 Jan 2022 04:44:37 GMT

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

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

MichelleWilliamsERM — Wed, 12 Jan 2022 16:22:53 GMT

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.