topic importing x y coordinates in Coordinate Reference Systems Questions

importing x y coordinates

deleted-user-q-lEfy9R6GTz — Sat, 18 Aug 2018 22:53:42 GMT

I add an excel spreadsheet with x y coordinates, and it successfully imported. The problem is it hasn't set to the exact location on my map. In fact I suspect the projection is off because it appears to be in a white no-mans-land with a white background. My map uses an imported online esri basemap.

Suggestions?

Re: importing x y coordinates

DanPatterson_Retired — Sun, 19 Aug 2018 20:24:32 GMT

Show some of the coordinates.

Use the Excel to Table tool to create a featureclass table

Add that table as an event layer, then save it as a geodatabase featureclass and make sure you define its coordinate system correctly.

And as a tip... don't add a basemap first, add your data to an empty dataframe (if using arcmap) or map (ArcGIS pro)

basemaps can be added after

Re: importing x y coordinates

SimonKettle — Tue, 21 Aug 2018 13:47:31 GMT

Did you set the coordinate reference system, that matches the coordinates in the Excel spreadsheet, to the data frame of your map before adding the coordinates?

If not you could be adding planar units to a Geographic CRS etc...or many other things...

As Dan Patterson‌ says provide a sample so we can work the problem

Re: importing x y coordinates

deleted-user-q-lEfy9R6GTz — Tue, 21 Aug 2018 14:05:17 GMT

Thank you, Simon. I was actually thinking that the spreadsheet might have a crs associated with it, so I’ve emailed the person who provided the data to ask them. I’ll go from there.

Re: importing x y coordinates

deleted-user-q-lEfy9R6GTz — Tue, 21 Aug 2018 14:07:41 GMT

Thank you, the Help tool I read not-so-carefully did not include the process, so this is really helpful! If I can’t get it done from here, I’ll provide some of the data. I’ve also asked the supplier to provide CRS in which the coordinates were exported.

I appreciate the response.

Re: importing x y coordinates

SimonKettle — Wed, 12 Dec 2018 12:17:53 GMT

This might be of use in future iterations of this problem: https://community.esri.com/groups/coordinate-reference-systems/blog/2018/12/12/checklist-adding-coordinate-values-from-a-spreadsheet