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
-2

My friend the format you have given up there is utm which is in metres. It 100% possible to export dms in QGIS as lon as u have well arranged and tick dms check box. So convert utm to dms or dd then export

  • It is unlikely that UTM coordinates would not have 6, 7, 8, or 9 in the tens or thousands places. Given that the values are marked latitude/longitude, and the values are compatible with DMS, and the DMS answer was marked correct, it's probably incorrect to assert that this is UTM data. – Vince Nov 10 '19 at 20:46

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.