I'm a beginner in QGIS, and I have a PostGIS database and a CSV file I would like to visualize. I followed the instructions in this question and the answers, but it doesn't work for me, my two layers are still not overlapping.

Here is what I'm doing:

  1. I create a new project, and in the project properties, in CRS, I "enable 'on the fly' CRS transofrmation" and select "Google Mercator".
  2. I add a PostGIS layer. In the "Properties" ("General") of this layer, the specified layer is "EPSG:900913 - Google Mercator". In "Metadata", I have:

    +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs

  3. Finally, I add a Delimited Text layer. This one is in Swiss Coordinates, so when adding it, Google Mercator is proposed, but I change it to "CH1903+". In "Metadata", I have:

    +proj=somerc +lat_0=46.95240555555556 +lon_0=7.439583333333333 +k_0=1 +x_0=2600000 +y_0=1200000 +ellps=bessel +towgs84=674.374,15.056,405.346,0,0,0,0 +units=m +no_defs

I'm choosing Google Mercator because when I first added the PostGIS layer, it was automatically selected.

What am I doing wrong here?

Here are examples of data from my sets: CSV (Swiss coordinates):

533288 152585

533230 152625

533066 152647

533057 152660

533110 152607

533143 152627

533162 152571

533103 152560

PostGIS (Google Mercator coordinates) (supposedly overlapping more or less):











1 Answer 1


Looks like you picked the wrong Swiss CRS.

EPSG:21781 - CH1903 / LV03 looks good to me.

  • I'm feeling so stupid. Thank you so much for your answer!
    – Antonin
    Mar 19, 2012 at 10:52

Your Answer

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

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