NAME: Find Duplicate Shapes or Records, v. 1.2   (Click Name to Download)

Aka: find_dupes.avx

Last modified:  October 10, 2005

View Online PDF Manual  (requires Adobe Acrobat Reader)

TOPICS:  Duplicate Records Identical Overlap Same Compare Attributes

AUTHOR:  Jeff Jenness, GIS Analyst

Jenness Enterprises

3020 N. Schevene Blvd.

Flagstaff, AZ 86004
jeffj@jennessent.com

DESCRIPTION:  This is a fairly basic extension that allows you to identify and optionally delete duplicate records in your dataset. You can define “Duplicate” to mean either identical shapes, identical attributes, or both.

Output:  

1)  The “Identify Duplicates” function will produce a report summarizing all the duplicate records and optionally add a field to your table identifying these records.

2)  The “Delete Duplicates” function will produce a new dataset without the duplicated values, without modifying your original theme or table.

3)  The “Identify Unique Values” function will produce a table listing all unique values, plus counts, of all the specified fields in a table or theme.

REQUIRES:  This extension requires that the file "avdlog.dll" be present in the ArcView/BIN32 directory (or $AVBIN/avdlog.dll) and that the Dialog Designer extension be located in your ArcView/ext32 directory, which they usually are if you're running AV 3.1 or better. The Dialog Designer doesn't have to be loaded; it just has to be available. If you are running AV 3.0a, you can download the appropriate files for free from ESRI at:

http://support.esri.com/index.cfm?fa=downloads.patchesServicePacks.viewPatch&PID=25&MetaID=483

Recommended Citation Format: For those who wish to cite this extension, the author recommends something similar to:

Jenness, J. 2005. Find Duplicate Shapes or Records (find_dupes.avx) extension for ArcView 3.x, v. 1.2. Jenness Enterprises. Available at: http://www.jennessent.com/arcview/find_dupes.htm

Please let me know if you cite this extension in a publication (jeffj@jennessent.com). I will update the citation list to include any publications that I am told about.

Updates:  

Version 1.1 (March 24, 2005) adds the option to identify unique values in multiple fields, similar to the Summarize function.

Version 1.21 (October 7, 2005) fixes:

General Instructions:

1)  Begin by placing the "find_dupes.avx" file into the ArcView extensions directory (../../Av_gis30/Arcview/ext32/).

2)  After starting ArcView, load the extension by clicking on File --> Extensions… , scrolling down through the list of available extensions, and then clicking on the checkbox next to the extension called "Find Duplicate Shapes or Records."