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 Mar 14 '16 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 Mar 14 '16 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 Mar 14 '16 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 Mar 14 '16 at 18:17

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 Mar 15 '16 at 15:19

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.