# Maptitude Mapping Software

## The problem: Convert decimal degrees to degrees minutes seconds formula

As Maptitude locates points in a database, it saves the coordinates of those points in decimal degrees. However, many users may want to know the degrees-minutes-seconds translations of these coordinates.

## What to do about it:

1. Open the layer of the points you want to convert.
2. Open the dataview of that layer.
3. Choose Dataview-Formula Fields to display the Formula dialog box. Paste the following fomula for converting longitude into degree-minutes-seconds into the dialog box:

r2s(abs(r2i(GetPoint(rh2id(GetRecord())).lon/1000000)))+"° "+i2s(r2i(abs(mod(GetPoint(rh2id(GetRecord())).lon,1000000)/1000000)*60))+"' "+format((abs(mod(GetPoint(rh2id(GetRecord())).lon,1000000)/1000000) - r2i(abs(mod(GetPoint(rh2id(GetRecord())).lon,1000000)/1000000)*60)/60)*3600,"00.00")+'" '+(if r2i(GetPoint(rh2id(GetRecord())).lon/1000000) > 0 then "E" else "W")

4. Give the formula field a name such as "DMS Longitude" and click OK.
5. Choose Dataview-Formula Fields again and paste the following fomula for converting latitude into degree-minutes-seconds into the dialog box:

r2s(abs(r2i(GetPoint(rh2id(GetRecord())).lat/1000000)))+"° "+i2s(r2i(abs(mod(GetPoint(rh2id(GetRecord())).lat,1000000)/1000000)*60))+"' "+format((abs(mod(GetPoint(rh2id(GetRecord())).lat,1000000)/1000000) - r2i(abs(mod(GetPoint(rh2id(GetRecord())).lat,1000000)/1000000)*60)/60)*3600,"00.00")+'" '+(if r2i(GetPoint(rh2id(GetRecord())).lat/1000000) > 0 then "N" else "S")

6. Give the formula field a name such as "DMS Latitude" and click OK.