[GIS] the format expected by QGIS for Latitude/Longitude in DMS

csvdegrees minutes secondsimportlatitude longitudeqgis

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?

Best Answer

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

Related Question