Hi Jessie,
There's a tool called DMSCNVRT.MBX that comes with Mapinfo. It will
convert DMS to DD. However you will have to massage your data a
little bit first. The tool expects the format of 123,58,34
representing D,M,S - commas between the D,M,S.
Here's what I would do:
-----------------------
1. Get the data out of Word and into Excel. If your data is tab
separated in Word then you should be able to cut & paste the whole lot
in one go into Excel.
2. In Excel, search/replace all instances of:
*° * with *,*
*' * with *,*
*"* with ** (ie. nothing)
Ignore the *
3. Read the XLS file into MI.
4. Save as native MI table.
5. Open the native MI table, make it mappable, create two new columns
"Long_DEC", "Lat_DEC", of float data type.
6. Run DMSCNVRT.MBX, follow instructions.
7. Create points from your two new "_DEC" columns.
Easy as 1,2,3 ...... 4,5,6,7 !
Good luck,
Peter Zyczynski
Analyst Programmer
Insight GIS
Australia
Ph: (03) 6244-7344
Fax: (03) 6244-7028
[EMAIL PROTECTED]
www.insightgis.com.au
-----Original Message-----
From: Jessie O. Floren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 August 2002 2:57 PM
To: 'MI-List'
Subject: MI-L Creating points from lon/lat having DMS symbols
Hi
I have a lot of coordinates contained in several files given to me
from
another agency that is in Word format. Now I need to create points
out
these word format. Normally MapInfo would create points in decimal
degrees
so that I need to convert all the coordinates into decimal degrees. Is
there
anybody from the list that help me do the job quicker? The format
goes like
this:
Point Latitude Longitude
1 09° 36' 09" 123° 58' 34"
2 09° 36' 00" 123° 58' 24"
3 09° 35' 48" 123° 58' 24"
4 09° 34' 17" 123° 58' 10"
and so forth...
I remember David Haycraft and others gave me the Mapbasic code for
generating the DMS symbols from decimal degrees, this is somehow a
reverse
of the process.
Thanks in andvance.
Jessie
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
Message number: 2530
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 2531
