1

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
3
  • 5
    try the right click on imported csv -> Set Layer CRS -> choose WGS 84 (EPSG:4326). If it doen't work, please provide the line from your .csv file Apr 14, 2017 at 12:14
  • 1
    @MykolaKozyr - Please post your comment as an answer :)
    – Joseph
    Apr 18, 2017 at 9:38
  • 1
    @Joseph done! :) Just added some description Apr 18, 2017 at 14:47

1 Answer 1

2

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)

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.