Take the 2-minute tour ×  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.  share|improve this
question If you need to enforce uniqueness I would recommend
using a database e.g. Postgres/PostGIS, Spatailite –  Nathan W
Jun 20 '12 at 10:26  5 Answers 5  up vote 3 down vote accepted
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 i