I'm trying to import a csv file into QGIS 2.18.00. The attributes and thus coordinates inside of QGIS are displayed just fine but QGIS only shows 9 of 14 imported points. I checked the coordinates with googlemaps, they work fine there. I exported the csv with python so I tried different delimiters and converted the coordinates to a string and integer, which shows the exact same results for all my approaches.


Import csv

( It says I cannot share more than two links so I had to cut out 2 screenshots which shows a) 9/14 points on the map and b) the complete attribute table inside of QGIS)

You can find the original CSV File here: http://txt.do/dk57u

  • 3
    You have 14 points, but 5 points are overlapping...(plotted at the same location).
    – Kazuhito
    Jun 30, 2017 at 9:39
  • 2
    How is it possible, that one man can be so stupid as I am? This is pretty awkward. Thank you, sir!
    – Simmen
    Jun 30, 2017 at 9:43
  • One of those things...I do every once in so often.
    – Kazuhito
    Jun 30, 2017 at 9:56

1 Answer 1


You have 14 points, but 5 points are overlapping...(plotted at the same location).

Overlapping features are really difficult to detect. I honestly have no good idea how to deal with this problem, without prior knowledge that they are located at the same place.

enter image description here

One way to double-check is to sort the csv by its Latitude or Longitude, but this is just an afterwit.

  • 2
    +1, one of the methods I use to check for duplicates is to use the Topology Checker plugin. If you configure this, you can select a layer and choose the rule must not have duplicates. Add this rule then click OK and Validate All which should highlight which features have duplicated geometries :)
    – Joseph
    Jun 30, 2017 at 10:24
  • 1
    Thanks @Joseph I have not had used Topology Checker yet, but sounds promising. (There are several tools with similar names, and I have been just hesitant... ) Will do try it.
    – Kazuhito
    Jun 30, 2017 at 10:46
  • 3
    What about labelling the points? Then you get two labels placed automatically so that they don't overlap.
    – AndreJ
    Jun 30, 2017 at 14:17
  • 2
    A quick possibility to check the feature count is to right-click on the layer and select "Show feature count". Also, this is more efficient than counting in case of >10 points ;). Ad overlapping features (and their selection): There is some discussion about this on the qgis user mailing list: lists.osgeo.org/pipermail/qgis-user/2017-May/040101.html
    – LuWi
    Jun 30, 2017 at 14:18

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.