topic Re: Excel and XY points in ArcGIS Pro Questions

Excel and XY points

LeighBrooks — Sun, 13 May 2018 16:44:11 GMT

I am new to ArcGIS Pro. Having trouble adding an XY point (lat/long) to see where it is like you could do in ArcMap, don't see how you can do this. Tried creating an Excel file with the lat/longs and displaying XY data (right clicking the table). That brings up the Make XY Event Layer, but my lat and long fields are not recognized as X field and X field and I don't see how to add them. I tried the conversion too to convert Excel to a table but when I run it I get a failed error, ERROR 000055: Cannot create a Query Table for this workspace. My Excel header uses no prohibited word and no funky characters that I am aware of.

Can anyone please help me with

1) how to add a quick lat/long to view location on map

2) how to use Excel so lat/longs show as points

Thank you.

Leigh

Re: Excel and XY points

DanPatterson_Retired — Sun, 13 May 2018 16:50:22 GMT

The process is effectively the same, which suggests that there may be something wrong with your coordinates.

Perhaps showing the first couple of rows of the spreadsheet would help.

Longitude is X, Latitude is Y. Decimal degrees is the only format directly supported without extra hoops to leap through.

Re: Excel and XY points

MervynLotter — Sun, 13 May 2018 17:10:58 GMT

You can also add single coordinates in the Locate tool, using a comma to

separate coordinates.

Re: Excel and XY points

LeighBrooks — Tue, 15 May 2018 01:35:38 GMT

Mervyn,

That is so helpful! Thank you very much.

Leigh

Re: Excel and XY points

LeighBrooks — Tue, 15 May 2018 01:35:39 GMT

Dan,

Thank you so much, that was the problem. My Excel data was in another format. I converted to decimal degrees and it is working. Not an easy fix though.

Leigh

Re: Excel and XY points

DanPatterson_Retired — Tue, 15 May 2018 01:37:59 GMT

Wish you had reported earlier....

There is a tool for that

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/convert-coordinate-notation.htm

Re: Excel and XY points

LeighBrooks — Tue, 15 May 2018 02:15:50 GMT

Great to know! I tried it on another Excel sheet someone sent me tonight with lat/longs in one field and it worked to split them out. Really appreciate the help, Dan.

Leigh

Re: Excel and XY points

DanPatterson_Retired — Tue, 15 May 2018 08:36:29 GMT

glad it worked out