topic Re: XY Out of Place in Coordinate Reference Systems Questions

XY Out of Place

PaulGardiner — Wed, 22 Aug 2018 16:02:57 GMT

Yet another XY out of place question.

Imported Excel table with XY coordinates.

Coordinate system for point layer is the same as the data frame.

When XY event is created in ArcMap points are about 150 miles from where they should be.

When XY are plotted in Google Maps they are in the correct position.

It's been a long day and can't think of any rationale reason as to why this is occurring. Any ideas/insight greatly appreciated.

Re: XY Out of Place

DanPatterson_Retired — Wed, 22 Aug 2018 20:32:27 GMT

are the coordinates in decimal degrees? degrees decimal minutes? degrees minutes seconds? Projected?

Did you try using the Excel to Table tool to bring in the excel data?

Do you have a few sample points you could post?

What is the coordinate system that is being used?

Re: XY Out of Place

PaulGardiner — Thu, 23 Aug 2018 08:19:06 GMT

Thanks for your reply Dan.

Coordinates are in decimal degrees.

Have tried using the Excel to table tool with the same results.

Sample Points

longitude	latitude
-8.129814	53.003450
-8.124604	53.004524
-8.074488	53.034590
-8.133948	53.083420
-8.040790	53.106630
-8.108042	53.111565
-8.108042	53.111565

Coordinate system of both the layer and data frame is TM65_Irish_Grid.

Edit: I should add that if I use the go to XY tool it brings me to the correct location.

Re: XY Out of Place

NeilAyres — Thu, 23 Aug 2018 08:31:44 GMT

Just to confirm...

When you make a XY event layer from this table you are specifying that the input coordinates are a geographic coord sys? TM65_Irish_Grid is some form of projected system.

Re: XY Out of Place

DanPatterson_Retired — Thu, 23 Aug 2018 08:41:35 GMT

As Neil says, these are a GCS (geographic coordinate system) and depending on the source of the data (GPS???) are probably in a WGS84 datum, hence you need to define the coordinate system either when you bring them in or after (Define Projection tool).

You will ultimately need to save them as a featureclass in a File Geodatabase or a shapefile (if sharing).

This file can then be used to produce a projected version (Project tool)

Re: XY Out of Place

PaulGardiner — Thu, 23 Aug 2018 08:41:36 GMT

Thanks Neil. Yes, had been specifying a geographic coordinate system.

Re: XY Out of Place

PaulGardiner — Thu, 23 Aug 2018 08:44:31 GMT

Thanks Dan and Neil.

I had used WGS84 (geographic) yesterday but for some reason points were still showing up in an incorrect position.

I had a clean run at it this morning and thankfully points are now showing up where they should be.

Thanks for your input and help.

Re: XY Out of Place

SimonKettle — Wed, 12 Dec 2018 12:14:20 GMT

This might be helpful 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