4

I try to add geocaches with x,y coordinates in a xls-table to qgis and convert to shp.file.

Usally geocach-coordinates are like this: N 51° 29.440' E 011° 56.430' (WGS84) (in german its called "bogenminute) . But it seems that qgis only know geographic coordinate system (WGS 84) with coordinates like this one: 51.754683 12.000967 ("dezimalgrad"). So i can charge them from one to another but i think its sensless. There must be a easier way.

Is there another geographic coordinate system ,qgis has, to add the points directly from the first format (bogenminute)?

  • Are your coordinates in two columns - one for latitude one for longitude? – Simbamangu Jun 4 '13 at 7:11
5

You could use regular expressions in the field calculator (QGIS 1.9 / 2.0, not 1.8!) to extract the appropriate numbers and do some basic arithmetic. If your latitude is in the 'lat' column:

regexp_substr("lat", '(\\d+)') + (regexp_substr("lat", '(\\d+).(\\d+)') / 60)

From your example - N 51° 29.440' – this gives 51.4906667.

3

Unfortunately, QGIS' Add Delimited Text Layer plugin can only import coordinates in decimal degrees (51.754683 12.000967) format and not in the degrees, minutes, seconds (N 51° 29.440' E 011° 56.430') format.

  • ok thank you for helping. is there another way/plugin who can import in format deegrees, minutes, seconds? – user12700 Nov 12 '12 at 15:02
  • 1
    Not in Qgis, but in Excel: office-loesung.de/ftopic512318_0_0_asc.php. You can import the result into Qgis. – AndreJ Nov 12 '12 at 15:21
  • as Andre Joost already told you, you can easliy convert to decimal degrees in your spreadsheet (Excel, OO, Libreoffice,...): Decimal lat/lon = degrees + minutes/60 + seconds/3600 – Kurt Nov 12 '12 at 16:37
  • 1
    ADDENDUM:Keep in mind that South latitude and West longitude are negative – Kurt Nov 12 '12 at 16:44
1

In QGIS 2.8 it is possible to load it with Add Delimited Text Layer and check the DMS Coordinates checkbox next to the X field and Y field combo boxes.

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.