3

I have been struggling with a CSV file I need to import into QGIS 2.2.0 (on Windows 7).

The coordinates are in this format:

LATITUDE  LONGITUDE
424605    861204
395222    861206
303051    861219
32155     861220
395541    861229
425119    861242

Latitude and Longitude are in units of degrees, minutes and seconds according to the person who provided the data.

I tried different formats (placing commas, dots, ',", etc at different places) to import this dataset into QGis, checking the "DMS coordinates" box in the "Create a layer form Delimited Text File". I always had a Delimited text file error message.

What is the format expected by QGis for Latitude/Longitude in DMS?

  • I'm not sure it can import DMS, you may have to convert them to decimal degrees. – artwork21 Apr 1 '14 at 1:49
  • 1
    Guesses-> degrees° minutes' seconds" But conversion is easy to Decimal Degrees. D+m/60+s/3600 – wildintellect Apr 1 '14 at 4:23
  • 1
    My search turned up that as long as you check that DMS box the format expected is very general - Three numbers separated by some character(s). ##°##'##" or ##'##'## should work. Commas might not work, as they are often field delimiters. Periods/dots would also potentially indicate a decimal (as it supposedly can take degree-decimal minute). Can you try ##-##-## and see if that works? The issue may also be your field delimiting character - if a tab try a comma or vice-versa. – Chris W Apr 2 '14 at 4:47
3

Assuming the data is really DD MM SS you can just add the data as follows

LAT,LON

42 46 05 N,86 12 04 E

I use spaces to separate DD MM SS and I assume since numbers are positive N,E. Other ways may work but I find this the fastest for me at least since using special characters takes typing time

  • Did you mean N,E? – BradHards Apr 4 '14 at 5:18
  • Ah yes N,E typo since I only ever use N,W in my part of the world – Antonio Locandro Apr 10 '14 at 21:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.