Select to view content in your preferred language

# From Decimal degrees to meter

16031
7
08-24-2014 06:28 AM
New Contributor II

Hey Guys

I have a data set Air mass trajectories (excel file) with a lot of points given in decimal degrees. I have plotted the trajectories in Arcmap but I need to know the distance between them. They span more or less from equator to Greenland so there is the issue of different E/W distances.

Regards Kasper

1 Solution

Accepted Solutions
Esri Regular Contributor

If you do not have Desktop Advanced and the Near GP tool then provided you can deal with 0.5% error then the Haversine formula might be suitable.

Or Vincenty if you want to get fancy.

7 Replies
MVP Emeritus

I don't work with data covering such a large area, but I would suggest km...in any event you probably want the geodesic distances which have new options in 10.2.1 perhaps using the Near tool

Occasional Contributor III
Occasional Contributor III

This must work, though I never used it

Esri Regular Contributor

If you do not have Desktop Advanced and the Near GP tool then provided you can deal with 0.5% error then the Haversine formula might be suitable.

Or Vincenty if you want to get fancy.

New Contributor II

I have tried using the Haversine formula in excel but I can’t get the right distance. I have calculated the following parameter:

 R = earth’s radius (mean radius = 6,371km) Δlat = lat2− lat1 Δlong = long2− long1 a = sin²(Δlat/2) + cos(lat1)*cos(lat2)*sin²(Δlong/2) c = 2*atan2(√a, √(1−a)) d = R*c (distance)