2

I have a list of points in Excel where the header says GK Northing and Easting. I assume they are referring to the Gauss Kruger coordinate system.

Example:
GK Hochwert: 3497041
GK Rechtswert 5737303

How can I convert from this reference system to WGS 84? I have QGIS and Alteryx to perform this task.

1 Answer 1

2

Are you sure you didn't mix up the values? Because it looks like you did.

Assuming you did mix the values up, you can load your points into QGIS using EPSG:31467, then they should display properly. Then use Add geometry attributes based on WGS 84 and save the output as CSV.

If you didn't mix up the values, use EPSG:31469, and your points would be somewhere in the mediterranean sea?

8
  • You are right, I mixed up Rechts- and Hochwert.
    – Konrad
    Apr 1, 2019 at 11:03
  • I converted via Alteryx and in the output CSV file I have the coordinates 895607925174524 and 517699042713254 for the respective Rechtswert/Hochwert coordinates. This doesn't seem to be correct. QGIS shows the right points, but if I save the file with WGS 84 the output still contains the GK coordiantes.
    – Konrad
    Apr 1, 2019 at 11:33
  • 1
    How did you save the WGS 84 file?
    – Erik
    Apr 1, 2019 at 11:42
  • 2
    Using "Save As", you can choose the CRS for the output. But this will not change the original attribute table values. The WGS84 coordinates are stored additionally as geometry values.
    – AndreJ
    Apr 1, 2019 at 18:53
  • 1
    It would be better, if you posted this as a new, follow-up question, with a link to this one. That way question and answer would be more distinguishable from the question you posted here. Also, feel free to mark answers as correct and helpful if they are, in order to help others along when seeking help.
    – Erik
    Apr 2, 2019 at 9:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.