[Gvsig_english] Importing Data in DMS form to gvSIG

[Juan Lucas Dominguez Rubio]

Hello,
frankly, I never thought about the degree symbol and the ordinal symbol as different things, because I dont think I have ever used any program that needed to parse a DMS string typed by me.
I'll try to use ALT+0176 from now on :)
 
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: sáb 31/10/2009 13:12
Para: Users and Developers mailing list
Asunto: Re: [Gvsig_english] Importing Data in DMS form to gvSIG


Hi,

thanks so much, it's working perfectly, yes it's multi-language (at least with my german office 2007).  thank you very much.
just one question: you are using the º symbol (ordinal indicator) for degree, not the degree symbol °, is this common because the degree symbol doesn't work with the international character set? unfortunately even with the ordinal indicator gvSIG doesn't interpret the DMS form correctly. anway your tool solves the problems. thank you very much. (I think I finally have to learn some VBA now, it's very helpful)

thanks, greetings davk 



2009/10/30 Juan Lucas Dominguez Rubio <jldominguez at prodevelop.es>


	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 
	

	_______________________________________________
	Gvsig_internacional mailing list
	Gvsig_internacional at listserv.gva.es
	http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
	
	


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20091102/4bb6515a/attachment.htm