shrug-l: Locate Duplicate Records

Sandell, Keith M. sandell.keith at
Thu Feb 26 12:42:49 EST 2009

Hey everyone,


Quick turn around on that, thanks! The suggestions were:


-          To use one of the many different options available for free
download at
<>  - many recommendations for
this site

-          Import the table into an access db and use the find
duplicates query

-          Use dissolve tool or summarize column on the attribute table
to identify the duplicates

-          For those you with SAS you can use LAG statements

-          Right-click the attribute field and Summarize, then add the
new table to the map and sort descending to quickly locate the

-          Summarize the field, sort descending and then query on the


Personally I like the quick and dirty methods for getting my "right-now"
solution, but I am going to be looking at the other suggestions as time
allows to find a permanent solution for this ongoing issue.


In keeping with the quick and dirty I decided to summarize the field in
Map, added the new table and then joined the summary table to the
original using that same field and sorted the Cnt_ID descending to bring
the wayward records to the top to bring my search and destroy mission to
a close just as quickly as it began.


Thank you for all the great suggestions. Ya'll are a great group of


Keith Sandell, MBA

Correctional Services Assistant Consultant

Florida Department of Corrections

Phone: (850) 410-3045

Fax: (850) 487-4427



From: shrug-l-bounces at
[mailto:shrug-l-bounces at] On Behalf Of Sandell,
Keith M.
Sent: Thursday, February 26, 2009 12:03 PM
To: shrug-l at
Subject: shrug-l: Locate Duplicate Records


Hey Shruggers,


Does anyone out there know how to easily identify duplicate records in a
table or feature class based on an attribute? I've seen a hand full of
ArcScripts on ESRI's support site, but have not had any luck getting
them installed/working. I have a table with about 14,000 records that I
need to "look" through for just a small number of duplicates that I know


I don't want to outright delete them, but find them so I can decide what
action is most appropriate.




Keith Sandell, MBA

Correctional Services Assistant Consultant

Bureau of Probation and Parole Field Services

Office of Community Corrections

Florida Department of Corrections

2601 Blairstone Road

Tallahassee, Florida 32399

Phone: (850) 410-3045

Fax: (850) 487-4427



This electronic message may contain protected health record/care
information intended for addressee(s) only. Unauthorized release or
disclosure may violate state and/or federal laws.


-------------- next part --------------
An HTML attachment was scrubbed...

More information about the SHRUG-L mailing list