Drew -
There is a MapBasic Tool that, unless I am mistaken, ships with MI. Look
for the file "DMSCNVRT.MBX". It should be in the 'Tools' subdirectory of
MI.
Hope this helps.
-Matthew
Drew Pollock <[EMAIL PROTECTED]> on 01/26/99 02:38:26 PM
To: "David Herzog" <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED] (bcc: Matthew James/hdq/Optel)
Subject: Re: MI conversing DMS to decimal degrees
At 11:35 AM 1/26/99, you wrote:
>Is there a way to get MapInfo to read lat/long points reported in
>degrees/minutes/seconds? Or must I convert the DMS points to decimal
>degrees? If I must convert, can anyone recommend a tool? Thanks.
>
>
Depending on the file size, you could do it through Excel.
1 Open the file as a .dbf inside of Excel
2 Make sure that the DMS points are parsed out across three fields
3 Add two new fields that will contain the DD values
4 In those new fields add the following formula:
$D1 = $A1 + ($B1/60) + ($C1/3600),
assuming that:
A = the degree value
B = the minute value
C = the second value
5 Copy that formula through all cells and the conversion will happen
automatically
6 Don't forget to put a negative sign in the appropriate column
7 Save the .dbf and open it in MI
Good Luck
=================
Atlanta Georgia
EMail: [EMAIL PROTECTED]
Web: http://www.avana.net/~pollocka/masterpage.html
Photography: http://www.avana.net/~pollocka/APPhoto/index.html
DWMap: http://www.avana.net/~pollocka/DW/DWMain.htm
Email for freelance mapping information. I could use the work!
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
