[Gvsig_english] Importing Data in DMS form to gvSIG

[Juan Lucas Dominguez Rubio]

Hello,
You can use the Excel functions to parse the coordinate string. For example:
 
45º35'12'' W
 
You can use the function FIND to find the degrees symbol (º), minutes symbol (') and seconds symbol (''). Then you can use the EXTRACT function (or similar) to split the string, then the VALUE function (or similar) to convert those strings into numbers, then simply divide the minutes by 60 and the seconds by 3600 and sum them up. You can use the FIND symbol again to decide the hemisphere (if it contains a 'W' it's the western hemisphere, so the longitude must be negative, etc).
 
I have attached an example in an Excel file (coord_parser.xls) to do this (also screenshot coord_parser.jpg). You ONLY have to change the yellow cells, the rest is automatic. The IND_* columns find the relevant symbols. The string is split in columns DEG, MIN, SEC. The result is in the DECIMAL DEGREES column, which uses the HEMISPEHERE column to find out the sign of the result.
 
If you want to convert thousands of values, you only have to copy the formulas vertically and paste your values in the input column. I hope the Excel format is multi-language, because I used the function names in Spanish.
 
Is that what you were looking for?
 
Regards,
 
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Da Kn
Enviado el: vie 30/10/2009 20:49
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Importing Data in DMS form to gvSIG


hello community, 

i've already posted about this problem, so I'm sorry for this new one, but unfortunately the problem remains, perhaps I'm doing a silly error. 

I've got an Excel table with XX°XX'XX'' data and trying to import it into gvSIG. projection should be WGS 84 (DMS), right? After adding the table UTF-8 (assigned via shalom), gvSIG only shows one point at 0°0'0'' to me, so the program can't read my data in XX°XX'XX'' form. How do I have to change the pattern of my data so that gvSIG will read it correctly? importing data in decimal degress works perfectly. 

unfortunately I don't know another program which allows batch conversions for DMS to Decimal, which would solve the problem. There are plenty of single value converters which are perfect if one just wants to convert few coordinates.

I will be very thankful vor any suggestions. thank you. greetings davk 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 156558 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20091030/3ae8200e/attachment-0001.bin