I have a csv file which I created from a SQLite3 database. I want to display the points from the csv in QGis - which does not work.
My coordinates are Lat/Long. They get displayed completely wrong. See here (all the points should be in Paris, Eifeltower):
My basemap (the purple world map) is in WGS84 and when QGis asked me in which format it shall format the .csv I told it WGS84 as well. On the fly projection is turned on to WGS84 as well.
I tried to load the csv file into Google Earth pro to see how that gets displayed - did not work. I could not import the directly from the SQLite3 database created csv file into Google Earth. However, I created a csv file from the point layer which I got from QGis (when I imported the csv file). That could be displayed. Google Earth displays it right. There are some points outside of Paris, creating a line just like in the image. But that are just a few... It looks like this (the big white ball is in Paris while next to it there are a few dots, a line running from south to north):
My example .csv file can be downloaded here http://s000.tinyupload.com/?file_id=17576339249280389460
Any ideas why that does not work?! Working with QGis 2.8