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; } } }

How to Automate "Calculate Geometry" Degrees Minutes Seconds within ModelBuilder?

JohnSmith40

Does anyone know how I can add the functionality of "Calculate Geometry" (Units: Degrees Minutes Seconds (DDD MM' SS.sss" [W|E]) and Degrees Minutes Seconds (DDD MM' SS.sss" [N|S])) within ModelBuilder? I figured out how to automate the calculation of both decimal degrees and State Plane coordinates using the "Calculate Field" tool (see below):

Decimal Degrees (using Python 9.3):

arcpy.PointGeometry(!Shape!.firstPoint,!Shape!.spatialReference).projectAs(arcpy.SpatialReference(4326)).firstPoint.X

arcpy.PointGeometry(!Shape!.firstPoint,!Shape!.spatialReference).projectAs(arcpy.SpatialReference(4326)).firstPoint.Y

State Plane Coordinates (using Python 9.3):

!SHAPE!.firstPoint.X

!SHAPE!.firstPoint.Y

Thanks for your time.

Najděte více příspěvků označených jako

Accepted answers

DanPatterson_Retired

You could try a code block in the field calculator.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">dd_mm_ss</SPAN><SPAN class="punctuation token">(</SPAN>dd<SPAN class="punctuation token">,</SPAN> cal_long<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> use_sign<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> use_quad<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""decimal degrees to deg dec min"""</SPAN>
    deg_sign <SPAN class="operator token">=</SPAN> u<SPAN class="string token">'\N{DEGREE SIGN}'</SPAN>
    deg <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>dd<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> deg <SPAN class="operator token"><</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'S'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>cal_long<SPAN class="punctuation token">]</SPAN>
        deg <SPAN class="operator token">=</SPAN> abs<SPAN class="punctuation token">(</SPAN>deg<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'N'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>cal_long<SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> use_quad<SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> use_sign<SPAN class="punctuation token">:</SPAN>
        deg_sign <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
    mins<SPAN class="punctuation token">,</SPAN> secs <SPAN class="operator token">=</SPAN> divmod<SPAN class="punctuation token">(</SPAN>dd<SPAN class="operator token">*</SPAN><SPAN class="number token">3600</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN>
    degs<SPAN class="punctuation token">,</SPAN> mins <SPAN class="operator token">=</SPAN> divmod<SPAN class="punctuation token">(</SPAN>mins<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN>
    frmt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{} {:0.0f}' {:05.2f}{}''"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>deg<SPAN class="punctuation token">,</SPAN> deg_sign<SPAN class="punctuation token">,</SPAN> mins<SPAN class="punctuation token">,</SPAN> secs<SPAN class="punctuation token">,</SPAN> quad<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> frmt

<SPAN class="comment token"># expression box... python parser</SPAN>

dd_mm_ss<SPAN class="punctuation token">(</SPAN>!YourField!<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

yielding

<SPAN class="comment token"># substituted a number for a field value to demo</SPAN>

dd_mm_ss<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">75.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">"75° 30' 00.00W''"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Of course, there are variants and you can mess with the code to suit your needs

All comments

DanPatterson_Retired

You could try a code block in the field calculator.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">dd_mm_ss</SPAN><SPAN class="punctuation token">(</SPAN>dd<SPAN class="punctuation token">,</SPAN> cal_long<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> use_sign<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> use_quad<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""decimal degrees to deg dec min"""</SPAN>
    deg_sign <SPAN class="operator token">=</SPAN> u<SPAN class="string token">'\N{DEGREE SIGN}'</SPAN>
    deg <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>dd<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> deg <SPAN class="operator token"><</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'S'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>cal_long<SPAN class="punctuation token">]</SPAN>
        deg <SPAN class="operator token">=</SPAN> abs<SPAN class="punctuation token">(</SPAN>deg<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'N'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>cal_long<SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> use_quad<SPAN class="punctuation token">:</SPAN>
        quad <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> use_sign<SPAN class="punctuation token">:</SPAN>
        deg_sign <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
    mins<SPAN class="punctuation token">,</SPAN> secs <SPAN class="operator token">=</SPAN> divmod<SPAN class="punctuation token">(</SPAN>dd<SPAN class="operator token">*</SPAN><SPAN class="number token">3600</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN>
    degs<SPAN class="punctuation token">,</SPAN> mins <SPAN class="operator token">=</SPAN> divmod<SPAN class="punctuation token">(</SPAN>mins<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN>
    frmt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{} {:0.0f}' {:05.2f}{}''"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>deg<SPAN class="punctuation token">,</SPAN> deg_sign<SPAN class="punctuation token">,</SPAN> mins<SPAN class="punctuation token">,</SPAN> secs<SPAN class="punctuation token">,</SPAN> quad<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> frmt

<SPAN class="comment token"># expression box... python parser</SPAN>

dd_mm_ss<SPAN class="punctuation token">(</SPAN>!YourField!<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

yielding

<SPAN class="comment token"># substituted a number for a field value to demo</SPAN>

dd_mm_ss<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">75.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">"75° 30' 00.00W''"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Of course, there are variants and you can mess with the code to suit your needs

JohnSmith40

Thank you Dan. I tried running the above code and received the below error:

Start Time: Thu May 09 10:02:32 2019
ERROR 000539: Error running expression: dd_mm_ss(-110.7623741472387, True, True, True)
Traceback (most recent call last):
File "<expression>", line 1, in <module>
File "<string>", line 16, in dd_mm_ss
UnicodeEncodeError: 'ascii' codec can't encode character u'\xb0' in position 0: ordinal not in range(128)

Failed to execute (Calculate Field).

I'm using this code within ArcMap, not ArcPro - not sure if that has anything to do with Python 2 vs. Python 3.

DanPatterson_Retired

big difference... python 2 doesn't support Unicode without some effort

try changing

deg_sign = u'\N{DEGREE SIGN}'

deg_sign = "d" or just ""

and

frmt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{} {:0.0f}m {:05.2f}{}s"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>deg<SPAN class="punctuation token">,</SPAN> deg_sign<SPAN class="punctuation token">,</SPAN> mins<SPAN class="punctuation token">,</SPAN> secs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>frmt<SPAN class="punctuation token">)</SPAN>

<SPAN class="operator token">-</SPAN><SPAN class="number token">75d</SPAN> 30m <SPAN class="number token">30.</SPAN>00s<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

KyleBalke__GISP

An alternative solution would be the Add Geometry Attributes geoprocessing tool.

http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/add-geometry-attributes.htm

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

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