English

How To: Convert Decimal Degree values to Degree Minute Seconds values using the Field Calculator

Summary

Instructions provided describe how to use the Field Calculator to convert Decimal Degrees stored in a Numeric field to Degrees Minutes Seconds stored in a Text field. The output by default is in the following format:

DD°MM'SS.SS"N

Procedure

Follow the steps below:

  1. Add the table to ArcMap.
  2. Right-click the table in the Table of Contents and select Open.
  3. Verify that Edit mode is not enabled. Click the Options button and select Add Field.
  4. Type DMSLat in the Name field and select Text from the Type drop-down list. If DMSLat is already used as a field name, select a name that is not being used.
  5. Change the length to 20.
  6. Right-click on the DMSLat field and select Calculate Values.
  7. Click Yes if presented with a message box.
  8. Change the Parser from VB Script to Python.
  9. Check the box to Show Codeblock.
  10. Paste the following code into the Pre-Logic Script Code box:
    Code:
    def decimalDegrees2DMS(value,type):
        """
            Converts a Decimal Degree Value into
            Degrees Minute Seconds Notation.
            
            Pass value as double
            type = {Latitude or Longitude} as string
            
            returns a string as D:M:S:Direction
            created by: anothergisblog.blogspot.com 
        """
        degrees = int(value)
        submin = abs( (value - int(value) ) * 60)
        minutes = int(submin)
        subseconds = abs((submin-int(submin)) * 60)
        direction = ""
        if type == "Longitude":
            if degrees < 0:
                direction = "W"
            elif degrees > 0:
                direction = "E"
            else:
                direction = ""
        elif type == "Latitude":
            if degrees < 0:
                direction = "S"
            elif degrees > 0:
                direction = "N"
            else:
                direction = "" 
        notation = str(degrees) + u"\u00b0" + str(minutes) + "\'" +\
                   str(subseconds)[0:5] + "\"" + direction
        return notation
  11. Paste the following code into the DMSLat = expression box at the bottom of the dialog box.
    Code:
    decimalDegrees2DMS( !DMSLat! ,"Latitude")
  12. Click OK to run the Field Calculator.
  13. Repeat steps 3 through 12 for the longitude values, but change the first parameter in the DMSLong expression box to the field in the table that contains the longitude decimal degree values and replace the word Latitude in the second parameter with the word Longitude.

Related Information