When I add a delimited text file to QGIS, only two points show up (but there are 122 points in the attribute table). I've seen answers to this question here and here, but neither solved my issue.
Here's my process:
- Start with Excel spreadsheet (I'm working on a Mac) and save as a Windows CSV.
- In QGIS, add delimited text file. Select "CSV" as file format and point coordinates (lat and long columns in spreadsheet). Choose WGS1984 as CRS.
- See screenshot for result- only two points show up, even though the attribute table shows the full dataset.
I've tried exporting the file as a shapefile, saving the CSV in different formats before importing it, and watching tutorials to make sure I'm doing everything correctly, to no avail. I have had this issue before, and could never solve it. Any feedback would be great. I'm using QGIS v. 2.12.
-
1This is a common problem with Excel on Mac, see gis.stackexchange.com/questions/137260/…AndreJ– AndreJ2016年12月07日 19:18:46 +00:00Commented Dec 7, 2016 at 19:18
-
@AndreJ my data imports in columns, not as a string (different from the Q you linked to). I've tried windows CSV, same issue.Hannah– Hannah2016年12月07日 19:24:14 +00:00Commented Dec 7, 2016 at 19:24
-
2The negative scale seems strange and coordinates don't match WGS84. Can you load a Natural Earth shapefile first, and see which features are imported by labelling with the id field? Does your locale use decimal commas?AndreJ– AndreJ2016年12月07日 19:32:32 +00:00Commented Dec 7, 2016 at 19:32
-
1Can you confirm whether you have only two points or whether all the points are stacked on top of each other. Also please confirm that when you say you set the CRS to WGS84, you chose EPSG:4326 and not EPSG:3857MappaGnosis– MappaGnosis2016年12月08日 07:29:11 +00:00Commented Dec 8, 2016 at 7:29
1 Answer 1
Try sorting your latitude column in descending order. I suspect you have a typo in one of the values that makes it much larger than the others. When I look at the image of your canvas, the lower dot appears to be multiple stacked dots.
After sorting, the offending point(s) should be at the top row(s). Once you remove or fix the offending point, right-click on the nigeriapop layer and choose "Zoom to layer"