Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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):

731632.384716794;5863923.31681192

731351.09395362;5864059.81606372

731351.452782778;5864091.19255148

731202.814656544;5864134.45924451

731322.906745951;5864210.56763595

731128.278515869;5864216.17023219

731337.333643971;5864149.17870271

730796.011530197;5864247.06311145

731613.06159501;5864003.29715222

730454.864224799;5863712.64413468

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Looks like you picked the wrong Swiss CRS.

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

share|improve this answer
    
I'm feeling so stupid. Thank you so much for your answer! –  Antonin Mar 19 '12 at 10:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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