I have recalculated PTV_Mercator (PTV Spherical Mercator EPSG:505456) coordinates to WGS84 EPGS:4326 coordinates in Excel. And when checking them on Google Maps they show up correct.

But after loading the CSV and trying to combine them with a map (tried several like OSM, QGIS, etc.), I can in no way get them to "overlap". I've read (and tried) the QGIS "Projection"-topic in the manual several times, but I can not get it to work correct.


As requested, I have added a picture of the problem:

Issue The recalculation was done with the use of this code-snippet:

enter image description here

  • Other than OSM, what have you tried? And what "Projection" manual? For OSM? Or something else? Thanks!
    – MaryBeth
    Commented Mar 14, 2016 at 15:11
  • Thanks for your reaction. The manual mentioned was the QGis-manual. I have also used geo-data from PDOK (Dutch open source geo-data. Grtz,
    – Bert
    Commented Mar 14, 2016 at 15:19
  • Can you give an example of PTV coordinates, the WGS84 latlon you calculated, and where they appear on OSM background? You can still edit your question and add a screenshot.
    – AndreJ
    Commented Mar 14, 2016 at 16:43
  • Based on this. It looks like it's a spherical Mercator definition. What's the sphere's radius? Note: EPSG has no IDs larger than 32766.
    – mkennedy
    Commented Mar 14, 2016 at 18:17

1 Answer 1


I've made a newbie mistake. When importing the CSV-data I switched the X and Y fields. For anybody who encounters the same issue:

X= Longitude Y= Latitude

Sorry to have bothered you all, but I still want to thank everyone who tried to help me.

  • 2
    If I had a nickel for everytime I've seen this... ;)
    – Joseph
    Commented Mar 15, 2016 at 15:19

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.