1

I am using both QGIS 1.8 and 2.0. So either is helpful.

A client has given me locations of trial pits but i cannot load them into QGIS no matter how hard i try.

For example, 50°24.711 North 7°25.529 West. The site is near Enniskillen Co. Fermanagh Northern Ireland. Any system i can find to convert degrees minutes and seconds will not allow 24.711, and seconds only go to 60.

  • 3
    you need to convert it from degree-decimal minutes (different from degree/minute/second) into decimal degrees. if you have this data in an excel table, you have to divide the 24.711 by 60, and add that decimal value to the degree value for 50.41185, and use that value instead. you can use a formula in excel if you have lots of values to change, or manually if there are only a few – TDavis Jul 31 '14 at 15:55
  • The location you were given, maps to the middle of the Celtic Sea. – Maksim Jul 31 '14 at 15:56
  • 1
    How have you been given these locations? In a spreadsheet, text file, written on a scrap of paper? Any chance we could have a sample of the source? – Spacedman Jul 31 '14 at 16:31
  • 1
    In order to convert deg/min second to decimal degrees I do it with the following formula in a spreadsheet deg+(min/60)+(sec/3600). for western longitudes and southern latitudes I do as follows -1*(deg+(min/60)+(sec/3600)). Usually I isolate the results by copy and paste values add a column with a name/identifier and save as a csv comma delimited file. Then you can use the "add delimited text layer" plug in to load the points in qgis. Hope it helps – Gerardo Jimenez Jul 31 '14 at 18:12
  • 1
    TDavis, i think you have answered my question and possed me with another....what system did they use to record them as it appears to be incorrect! If you wish to ad your comment as an answer i will accept it. – Ger Aug 1 '14 at 11:19
1

As commented by @TDavis:

you need to convert it from degree-decimal minutes (different from degree/minute/second) into decimal degrees. if you have this data in an excel table, you have to divide the 24.711 by 60, and add that decimal value to the degree value for 50.41185, and use that value instead. you can use a formula in excel if you have lots of values to change, or manually if there are only a few

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.