nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Select duplicate rows in FGDB attribute table using SQL

Bud

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.

タグ付きの投稿をもっと見る

Geodatabase

Status: 開く

MMBR

@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

AllenDailey1

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.

Bud

Kevin_MacLeod

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

会話に参加する

投稿、コンテンツのフォローなどにはサインインしてください。初めてですか？無料で登録しましょう。