I am importing a simple 5 column csv file into QGIS using Add Delimited Text Layer. Each row of the table contains a name, a street address, a postcode, a decimal latitude and a decimal longitude, for example:
Harewood Road,"8a Harewood Road, Brentwood, Essex",CM15 9PD,51.635252,0.292283
In the add layer window (
Data Source Manager), I get the file format and encoding recognised; under
Point co-ordinates is automatically selected with
X field linked to my longitude column and
Y field as my latitude column.
DMS coordinates is not ticked.
Sample Data at the bottom, all looks as you would expect.
Once the layer is added, dots are displayed in QGIS on the map in a scatter as I would expect (my csv contains several point locations). But the scale is completely wrong. If I right-click on my layer and select
Zoom to layer I find my dots are all in the middle of the sea (actually, off the Isles of Scilly in the far south-west corner of the UK National Grid).
At the bottom of my QGIS window there is a little widget showing
Co-ordinate that shows appropriate-looking numbers e.g.
0.292283,51.635252, (lon,lat), but the
Scale widget is showing 1:3! So these places are being mapped as if they cover the area of a post-it note.
Edit: looks like a duplicate of Mysterious Lat Long conversion to XY problem using QGIS ... the solution there was to use a different CRS. I'm currently using
EPSG:27700 (British National Grid) for all my layers and basemap. So what should I project with instead?
If I then go to the layer properties and from the left menu select
Attribute form, and then select the
Latitude field, it shows the Widget type as
Text Edit. If I change this to
Range, the Minimum and Maximum fields are enormous numbers:
Advanced Options it tells me that: "
Current minimum for this value is 51.608082 and current maximum is 51.834236" which matches the min and max of my dataset.
If I import a similar csv file as a delim text layer, but with Eastings and Northings included, and pass those columns as the X and Y co-ordinates, it imports the points perfectly. But for some reason QGIS is not correctly interpreting the valid lat and lon numbers I am giving it. I would like to know why.