I am trying to place points in QGIS that are given in a csv-file, coordinates are given in WGS84 (4326) but the positions are like this
LAT;LONG
5724.3180;1548.4021
I can't get QGIS to place them correctly. When I divide them by 100 I get the extent correct but the place is not correct 57.24318 / 15.4021
It should be Hultsfred. The points represent trees along Väg 23 between Målilla-Hultsfred
How do I solve this?
If you add the DMS-notations at the correct places, 5724.3180;1548.4021 becomes 57°24'31.8" N; 15°48'40.21" E - which is placed exactly where it should be as you state in the comments.
I suggest you load the data into QGIS as a table without geometry. Then you use the field calculator with the following expressions to create new latitude and longitude fields:
substr(LAT,1,2)||'°'||substr(LAT,3,2)||'\''||substr(LAT,6,2)||'.'||substr(LAT,8)||'"N'
substr(LONG,1,2)||'°'||substr(LONG,3,2)||'\''||substr(LONG,6,2)||'.'||substr(LONG,8)||'"E'
Then save to .csv, then reload with the new coordinates as DMS.
You could also use excel for this editing, I guess.
It is also likely, as @mkennedy pointed out, that the original coordinates were DDMM.mmmm. In this case the expression would be:
substr(LAT,1,2)||'°'||substr(LAT,3)||'\'N'
And similarly for the East-coordinate.
