[GIS] Selecting the correct projection for an imported .csv file

qgisqgis-2.18

I am trying to import a .csv file into a QGIS project and cannot get it to be correctly positioned.
The data is the output from a series of sound recordings (bat calls) that were automatically georeferenced when recorded (on a GPS eneabled bat detector). The recorder GPS is set to WGS84 (I am in the UK).

The projection of the QGIS project is EPSG:3857 WGS 84/Pseudo Mercator with “On The Fly” CRS Transformation enabled. This is the default that was prompted when I added the raster base tiles to the project at the start (Ordnance survey data)

When I import the csv file it plots but way, way off the correct location.
I have tried selecting the following as the Projection for the imported .csv file during import but none work.
EPSG:3857 WGS 84/Pseudo Mercator [whihc I assumed would be correct]
OSGB 1936.British National Grid
EPSG 102013: Europe_Albers_Equal_Area(Conic)

If I import and plot the gpsx file from the recorder as a track it plots in the correct place (so I know that the data location was correctly recorded in the field) but the .csv file of the point data (the recordings taken at various points on the track) plots the individual points for each recording in the correct general pattern but miles away.

Can anyone suggest where I am going wrong?

QGIS version is:

QGIS version
2.18.3
QGIS code revision
77b8c3d
Compiled against Qt
4.8.5
Running against Qt
4.8.5
Compiled against GDAL/OGR
2.1.2
Running against GDAL/OGR
2.1.2
Compiled against GEOS
3.5.0-CAPI-1.9.0
Running against GEOS
3.5.0-CAPI-1.9.0 r4084
PostgreSQL Client Version
9.2.4
SpatiaLite Version
4.3.0
QWT Version
5.2.3
PROJ.4 Version
493
QScintilla2 Version
2.7.2

Best Answer

QGIS sets the project's CRS to imported *.csv file (EPSG:3857 in your case). EPSG:3857 is a metric projection (basic unit - meter), while your data stored as degrees (1 degree = apx. 111km on Equator latitude). When you import your data, QGIS 'thinks' you use metres as the main unit, so it shows all your features near the point with coordinates (0;0).qgis screenshot

For correct representation of your data, you should set the CRS it is stored:

  1. Right click on imported *.csv
  2. Set Layer CRS
  3. Choose WGS 84 (EPSG:4326)
Related Question