nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Coordinate conversion

CCWeedcontrol

So i was given a excel. xls table with Lat and Long of decimal degrees minutes and i need to import it into ArcMap. I am needing to convert them to decimal degrees in order to import it into ArcMap. How can i convert this table the entire table to decimal degrees. I tried using the Add XY Data but when i select the file nothing happens, do i also need to convert the table certain format before add it to arcmap? Can this be done through arcmap or field calculator? I would appreciate any help.

The table is populated as following

Long	Lat
-116 37.863	43 41.353

Trouver plus de publications taguées avec

Accepted answers

AbdullahAnter

It is popular question here, use Convert Coordinate Notation—Help | ArcGIS Desktop

All comments

CCWeedcontrol

Dan, Thanks for the field calculator formula.

DanPatterson_Retired

Yes, or just in the field calculator for future reference

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">ddm_ddd</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> sep<SPAN class="operator token">=</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">""" convert decimal minute string to decimal degrees
&nbsp;&nbsp;&nbsp; : a - degree, decimal minute string
&nbsp;&nbsp;&nbsp; : sep - usually a space, but check
&nbsp;&nbsp;&nbsp; """</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> math&nbsp; <SPAN class="comment token"># if not already imported or available</SPAN>
&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">,</SPAN> m <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>abs<SPAN class="punctuation token">(</SPAN>float<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN>sep<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; sign <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>d <SPAN class="operator token"><</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; dd <SPAN class="operator token">=</SPAN> sign<SPAN class="operator token">*</SPAN><SPAN class="punctuation token">(</SPAN>d <SPAN class="operator token">+</SPAN> m<SPAN class="operator token">/</SPAN><SPAN class="number token">60</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> dd

<SPAN class="comment token"># useage in field calculator, python parser to calculate into a double field</SPAN>
<SPAN class="comment token"># for the expression box...</SPAN>
<SPAN class="comment token"># ddm_ddd(!YourField!, sep=" ")</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

CCWeedcontrol

Aww sweet tool it took the table and converted it correctly, it worked with space separating the degree!

FID	Shape	Long	Lat	DDLat	DDLon
0	Point	-116 37.863	43 41.353	43.68922	-116.63105

CCWeedcontrol

Yes there is a space.

AbdullahAnter

It is popular question here, use Convert Coordinate Notation—Help | ArcGIS Desktop

DanPatterson_Retired

are the entries really formatted with a space separating the degree portion from the decimal minutes?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.