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 |
Click OK when you are finished.
4. 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
|