How to identify duplicate attributes in a field?

Question

I have a point shapefile with thousand of points. It has an ID code field that supposed to be unique. Every now and then the data entry clerk wrongly type the id creating duplicates.Right now I'm manually scrolling the field to find the duplicate.Is there a sane way to do this using the Search Query Builder ? Thanks for any help.

Answer 1

If the IDs are consecutive, I would add a new temporary column with unique values like @Ship.shp suggested and then use the query builder to search for ID != uniqueID.

That would return the duplicates directly. After fixing the original IDs, remove the extra column or repeat the whole process as needed — it is not clear what kind of pattern your IDs must match. If they just need to be unique, note the last value first and you can then edit the bad IDs in one iteration, just bumping the number as you go.

Answer 2

Use Group Stats plugin and set the ID as a field classification. You can see how many times each value has been entered in 'count' column.

Answer 3

A quick (although inelegant) way to do this is to go into Layer properties, select Style - Categorized using the column that you're interested in. Apply this, then right click on the layer in the layers window and check the Show Feature Count checkbox. Then expand the layer in the layers window and you can immediately see how many times each value has been entered.

Answer 4

Also you can use the split by attribute and end up with a seperate table for each value.

I like Rayo's suggestion though. except statist doesn't quite work like I thought it did.
It does give a count of unique values but doesn't help with what those values are.
Another software might add a count field and allow you to export it to csv or other spreadsheet format.

My suggestion for the split layer by attribute is in the vector management tools

split your data on any 1 field an dyou will have your counts.
way more inelegant than ship.ship's solution