format of latitude and longitude in the script

[#1]

Hi, I recently downloaded a qlikview demo on how to apply maps in a qlikview document. i'm having a problem with applying the latitudes and longitudes and adding new countries etc to the Load Inline Statement in the script. The example of the 'Load Inline' Statement is below.

Data:

LOAD * INLINE [

Country,Population, latitude, longitude

Albania, 3600523, 41.153332, 20.168331

Algeria, 33858000, 28.033886, 1.659626

Argentina, 40301927, -38.416097, -63.616672

Armenia, 3230100, 40.069099, 45.038189

Australia, 21446187, -25.274398, 133.775136

Austria, 8340924, 47.516231, 14.550072

Azerbaijan, 8629900, 40.143105, 47.576927

Bahrain, 760168, 25.930414, 50.637772

Antarctica, 57000, 16.58, 62.19

U.S.A., 307943000, 40.14, 76.08

Zimbabwe, 12523000, 17.43, 30.58

New Zealand, 4315800, 41.19, 174.46

];

The map turned out fine in the Qlikview document but when i added the new Countries with their Latitudes and Longitudes they would end up on opposite sides of the world.. Lets say Johannesburg, South Africa's coordinates are:

26°10'S

28°02'E

How would i put that in the script.

Would it be - South Africa, (pop) 30000000, 26.10, 28.02 ???

Probably a very simple and stupid question..

[Bill_Britt · Accepted solution]

Maybe, this site will help

http://www.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html

[#3]

Ok that s great, just tried it and realised i've actually got something wrong with the map, i need to get a southern african map. I think i can figure it out though. but thanks for the link, that is going to help me alot.