Wrong coordinate system when adding XY Points

1019
10
Jump to solution
10-07-2022 03:55 AM
Labels (1)
MathildePaustian
New Contributor II

Hi

 

I've tried to add points to ArcGIS Pro from an excel sheet via the tool XY Table to Point.

Both my map and the points are in the "GCS WGS 1984" coordinate system, but as seen on the image, the map is distorted and squeezed and the points don't appear in exactly the correct place. The points should be in the ocean just near the danish coast of Zealand. 

MathildePaustian_0-1665140296153.png

 

Am I using the wrong coordinate system or do anyone know how to fix this?

Here is a sample of the lat and long from the excel sheet:

55,4378512,05772
55,4235712,00436
55,416912,02
55,426412,0605
55,4025111,57064
55,4085912,01427
55,4082512,04301
0 Kudos
1 Solution

Accepted Solutions
ThomasHoman
Occasional Contributor III

Ah. I think what your colleague gave you is degrees and decimal minutes and not just decimal degrees. Plotting the first coordinate pair under this thought I got - note that the gotoxy location is set to ddm instead of dd

ThomasHoman_1-1665150795850.png

Is this closer to reality?

Tom

 

View solution in original post

10 Replies
by Anonymous User
Not applicable

The problem is the basemap. Save your points / Close ArcGIS Pro / Open ArcGIS Pro and add the points to a brand new .aprx.

MathildePaustian
New Contributor II

Unfortunately this is the result when I try to save the points and open a new .aprx. I havn't chosen any baselayer here, but the image and points are still distorded.

And if I change the coordinate system to like mercator, the map is fixed but the points are then located near 0,0 (null island)

Do you know any solution to this?

MathildePaustian_0-1665142363929.png

 

by Anonymous User
Not applicable

Try projecting it to your local coordinate system. Not familiar with this part of the planet. It appears like your points have slid to the south.

MathildePaustian
New Contributor II

I've tried a bunch of different coordinate systems, none of which makes a difference. 

0 Kudos
by Anonymous User
Not applicable

I went back and reviewed the thread above. Your sample data is confusing to me. If you are using WGS84, Where are the decimals in your coordinates?

0 Kudos
ThomasHoman
Occasional Contributor III

Hi @MathildePaustian 

My first thought is if the data is off somehow or was collected under a different coordinate system. Can you go back and verify the source and accuracy? 

To remove the question of the software entirely I dropped your first point into Google Maps and it returned the below picture indicating nowhere near the coast.

ThomasHoman_0-1665148523709.png

Regards,

Tom

 

MathildePaustian
New Contributor II

The coordinates was given to me by a colleague as below:

LatLong
5543,7851205,772
5542,3571200,436
5541,691202
5542,641206,05
5540,2511157,064
5540,8591201,427
5540,8251204,301
5547,9481235,372
5555,941233,11
0 Kudos
ThomasHoman
Occasional Contributor III

Ah. I think what your colleague gave you is degrees and decimal minutes and not just decimal degrees. Plotting the first coordinate pair under this thought I got - note that the gotoxy location is set to ddm instead of dd

ThomasHoman_1-1665150795850.png

Is this closer to reality?

Tom

 

MathildePaustian
New Contributor II

Thank you so much! This did the job and the points are now in the correct place.

0 Kudos