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; } } }

arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons

I'm attempting to use the arcpy method DeleteIdentical_management on an ESRI geometry type sqlite database. However, no records are removed from the database upon running.

When I run delete identical in ArcPro, the identical records are deleted as expected.

Is this a known issue?

Find more posts tagged with

Accepted answers

Drew Flater

@MulfordnSons this bug has been addressed in ArcGIS Pro 3.0.

All comments

MulfordnSons

Tried doing this within the ArcPro Python window - when I run the arcpy method, the feature class in the contents shows that the tool recognizes the feature class (it greys out, locks). However, after it runs, no identical geometries are deleted.

Then, I run delete identical from the UI using only 'Shape' and all of the identical records are deleted as expected.

Drew Flater

I tried with a list of fields as well and it still is correctly deleting one record. Make sure your field names are matching the real field names, including SHAPE (I don't think upper vs lower case will really matter, but it's something to check)

MulfordnSons

The code sample below doesn't delete any duplicates, even if I just specify the shape field. Can ArcPro be open when this runs?

EDIT: when the application is closed, the duplicates still remain after running this tool on the sqlite feature class

fields = ['SHAPE', 'CommonName', 'ObservationDate']
arcpy.DeleteIdentical_management(r'F:\portfolio_projects\database\PA_Birds1.sqlite\main.pa_birds_pnts', fields)

Drew Flater

I ran a quick test, and I got the same Delete Identical result when running inside Pro using the tool UI and running using arcpy in standalone Python.exe. In both case the single duplicate in my sqlite polygon feature class was deleted.

KoryKramer

I don't think we're aware of this issue. If you have reproducible steps and example data that demonstrate the problem, I'd highly encourage you to report it as a bug here: https://support.esri.com/en/report-bug

Thank you

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.