Maptitude Technical Support FAQs

Home > Maptitude > Tech Support > Converting to Degrees-Minutes-Seconds

The problem:

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. Using Dataview-Modify Table, add the following fields:

Name:	Type:	Width:
Lat Degrees	Integer	10
Lat Minutes	Integer	10
Lat Seconds	Integer	10
Long Degrees	Integer	10
Long Minutes	Integer	10
Long Seconds	Integer	10

4. Click OK when you are done.

5. Scroll to the new fields. Select the field [Lat Degrees] by clicking the title of the column. The entire column will be shaded black. Choose Edit-Fill-Formula and type in the following formula:

R2I(Latitude/1000000)

Click OK when finished and the column will fill. Repeat the same procedure for each of the remaining columns, using the following formulas:

Field:	Formula:
Lat Minutes	R2I(Abs(Mod(Latitude/1000000,1)*60))
Lat Seconds	Round(Mod(Abs(Mod(Latitude/1000000,1)60),1)60,0)
Long Degrees	R2I(Longitude/1000000)
Long Minutes	R2I(Abs(Mod(Longitude/1000000,1)*60))
Long Seconds	Round(Mod(Abs(Mod(Longitude/1000000,1)60),1)60,0)

Return to Main Tech Support Page