idea Select duplicate rows in FGDB attribute table using SQL in ArcGIS Pro Ideas

Select duplicate rows in FGDB attribute table using SQL

Bud — Mon, 17 Jun 2024 13:49:18 GMT

Edited.

As far as I know, there isn't a way to select rows in a file geodatabase attribute table where there are duplicates in a certain column. The docs say it can't be done using SQL since FGDB SQL is limited. Could FGDB SQL be enhanced?

I'm aware of the Find Identical (Data Management) geoprocessing tool. But I think that tool creates a separate table. Whereas I want to select rows in the attribute table.

Re: Select duplicate rows in FGDB attribute table

MarceloMarques — Tue, 11 Jul 2023 18:37:38 GMT

@Bud - see the Data Reviewer Extension "checks".

ArcGIS Pro:
Duplicate Feature—ArcGIS Pro | Documentation
ArcGIS Data Reviewer checks—ArcGIS Pro | Documentation

ArcMap:
Finding duplicate geometry—ArcMap | Documentation (arcgis.com)
An overview of running data checks—ArcMap | Documentation (arcgis.com)

Community.esri.com - ArcGIS Data Reviewer

Re: Select duplicate rows in FGDB attribute table

AllenDailey1 — Tue, 11 Jul 2023 18:33:35 GMT

Good idea!

I have a way of doing this with Python, but of course that's a lot more complicated than simply being able to perform a selection. You use an arcpy Update Cursor, add each row's value for that field to a list if the value is not in the list already, and if it is in the list, then you put a value in a different field to indicate that it's a duplicate value. Like, the field could be "Duplicate" and the value you enter for that row would be "yes." Then later you can select all the rows that have "yes." That wouldn't select the first row that had the duplicate value, but I know it would be possible to do that, with different use of the value list or what you put into the "Duplicate" field.

Re: Select duplicate rows in FGDB attribute table using SQL

Bud — Wed, 30 Apr 2025 16:04:27 GMT

Re: Select duplicate rows in FGDB attribute table using SQL

Kevin_MacLeod — Fri, 08 Aug 2025 19:12:44 GMT

same question. Reason we might want selection or Definition Query, is that it stays updated. (FYI selection does not stay updated) So an app with a service could track duplicate inputs for example. I too am well aware of Find Identical, and various ways in python to do this. Not the same thing. Don't want an extra field, either. SQL with SSMS and a view could this but I don't have access to SQL Server at my agency unfortunately. There are lots of folks in this boat. IDEA: Add ability to select duplicates and filter in definition query for duplicates (or not duplicates) in Pro