We have around 60,000 separate shp – tab files. We have to move all those into a gdb. While doing so, at times the data are getting duplicated as shown in the fig. Lyr_1 – gdb layer. Lyr_2 – individual shp file. We have to identify the duplicates of Lyr_2 in Lyr_1(gdb) and give unique id's to that features in Lyr_2.
Curretnly, we are using Xtools pro for ArcGIS -> Find duplicates option to identify the duplicates. ArcGIS -> Select by location -> are identical to source feature layers is not working. We dont have license to Data Reviewer & Find identical tool.
Is there a way to do this in QGIS ?
Even in QGIS, tried with Spatial query -> features equals. But didn't work
Best Answer
You could use the Select by location tool from the Processing Toolbox to identify and select features from Lyr_2 which spatially equals features from Lyr_1:
Once selected, you could add unique IDs using, for example, the Field Calculator.
Note: Depending on your data, you may need to be careful as this method makes a spatial comparison, it doesn't check if the features are duplicates.