Video Tutorials

Support Online Request Form

Learn more about Maptitude 2014 mapping software

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 Field 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 Field 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.

Return to Main Tech Support Page