Pat.... Using Terrain Navigator topo map software I can convert back and
forth for any point. ie
UTM coordinates 17 02 64 44E
39 05 37N
converts to Lat 35 15 44.93 Long 083 35 37.37 which I then know how to
convert it to D.D for MI.
my two columns at 17 02 64 44 and then 39 05 37.
to make things even more confusing for the novice. the Mentor Software
MGRS/UTM converter gives the DD MM SS conversion to UTM as Zone 17N
Easting 264,050.51 Northing 3,905,236.27
Go figure..... I'll be chasing my tail forever trying to get a hold of all
these coordinates conversions
SSA Jay F. Chamberlain
FBI
Engineering Research Facility
Physical Surveillance Unit
703-632-6628
----- Original Message -----
From: Patrick Phillips <[EMAIL PROTECTED]>
To: 'Jay Chamberlain' <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 12:31 PM
Subject: RE: MI Convert from UTM to D.D
> Jay;
>
> Are your UTM coordinates represented as a number (Integer) in one column,
> or as text in one column, or as numbers in 4 or 8 columns. What I am
> getting at is could you provide the table structure. The approach I would
> take depends on how the data is stored.
>
> As a wild guess I am going to say it is two columns of text eleven
> characters long for each column, but that is just by the way you
> represented the coordinates in your post "17 02 55 55" This equate to 17
> degrees + 02 minutes + 55.55 seconds. Because there are 60 minutes in
> one degree and 60 seconds in one minute the conversion would be
>
> 17 + 02x(0.016667) + 55.55x(0.00027778) = +/- 17.04876 degrees
>
> NOTE: 0.016667 = 1/60 and 0.00027778 = (1/60)/60
>
> Let me know more about your table structure and I will try to help you
> write an update query that will apply this formula to your data.
>
> Patrick J. Phillips
> GIS Programmer I
> City of Orlando, FL
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
