DMS to Pro xy?

2968
4
11-04-2015 11:04 PM
MirbazAhmadzai
New Contributor

How Can I convert DMC to Pro absolute xy, because Pro need xy and our Data in DMC like (30°11'4.46"N)

69.20800481249913, 34.654771721221316

0 Kudos
4 Replies
DanPatterson_Retired
MVP Emeritus

DMS to decimal degrees manually in arcmap and Pro or the Convert Coordinate Notation​ tool

MirbazAhmadzai
New Contributor

Type Of xy in Pro?

0 Kudos
DanPatterson_Retired
MVP Emeritus
BillChappell
Occasional Contributor II

One issue is DMS is a string and you need to convert it to a number (Double) so you can plot them

The basic conversion is dd = d + m/60 + s/3600

you could field calculate it in ArcMap  two fields  DMS has the dms values, and DD a double field where you want to field calc it

.DD=  left( [DMS],2) + (mid( [DMS],4,2)/60) + (Mid( [DMS], 7,4)/3600)

The left and mid functions are a way to pull apart the string, in your example

30°11'4.46"N  you want the left 2 (maybe 3 if in western hemisphere ie. -30)   Mid 4,2 gets the 11 and mid 7,4 gets the 4.46  The °'."N symbols are not math symbols..