HOW TO

Convert DMS to DD with the Field Calculator

Last Published: April 25, 2020

Summary

You can use the Field Calculator to convert field values stored as Degrees-Minutes-Decimal Seconds (DMS) to Decimal Degrees (DD).

For example, 953015.75, broken down to its constituents, is 95 degrees, 30 minutes, and 15.75 seconds. For the sake of this example, let's assume we have two fields in the table: one named LatDMS, which stores the Latitude values, and another named LongDMS, which stores the Longitude values.

Note:
The content in this article pertains to ArcView GIS versions 3.0, 3.0a, 3.0b, 31., 3.2, and 3.2a only. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.

Procedure

  1. Create two new number fields with widths of 12 and four decimal places. Name one LatDD and the other LongDD.
    1. Open the table and select Start Editing from the Table menu.
    2. Select Add Field from the Edit menu.
    3. In the Field Definition dialog box:
      1. Set Name to an appropriate name, for example 'Area'.
      2. Set Type to Number.
      3. Set Width to an appropriate number, for example '32'.
      4. Set Decimal Places to the desired number, for example '6'.
      5. Click OK.
    4. Select Stop Editing from the Table menu and save the edits.
  2. Click the Select None button to make sure all records in the table are unselected.[O-Image] Select none button image
  3. Select Start Editing from the Table menu.
  4. Make the LatDD field active.
  5. Select Calculate from the Field menu.
  6. Type the following expression:
(([LatDMS].AsString.Left(2).AsNumber) +
([LatDMS].AsString.Middle(2,2).AsNumber / 60) +
([LatDMS].AsString.Right(5).AsNumber / 3600))  
  1. Click OK.
  2. Make the LongDD field active.
  3. Select Calculate from the Field menu.
  4. Type the following expression:
(([LongDMS].AsString.Left(2).AsNumber) +
([LongDMS].AsString.Middle(2,2).AsNumber / 60) +
([LongDMS].AsString.Right(5).AsNumber / 3600))
  1. Click OK.
  2. Select Stop Editing from the Table menu.
Note:
On steps 5 and 9, replace the example field names with the actual field names in your table. Don't press the Enter key to move to the next line; allow the expression to wrap automatically.  

Article ID:000002602

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic