Find Duplicates

 

 

Purpose

 

The tool is aimed to finding and, optionally, removing duplicated features/records in the specified feature class/table.

 

Description

 

Using the Find Duplicates tool you can easily find duplicated features and records in your data. Found duplicates are indexed in a new attribute field of an output features class/table. Using this index field you can always select duplicated entries and/or remove them if required.

Duplicated features can be searched by the Shape field. Features and records are considered as duplicates by comparing the selected attribute fields and/or Shape field. Therefore, you can find features duplicated by both geometry and attributes.

 

Finding Duplicates

 

1. Select the "Find Duplicates" tool from the XTools Pro Table Operations menu.

2. Select the input feature layer or table in which you wish to find duplicated features/records.

3. Specify the name and location of the output table or feature class.

4. Select fields to compare.

5. Specify duplicates processing options:

- Select to either remove duplicates or output only duplicates

- Select index type for duplicates

- Specify index field name

6. Specify geometry options (if Shape field is selected):

- Select to compare features by Z and M values

- Specify XY and Z tolerance

7. Specify ID field to store input features IDs.

8. Press Run to find duplicated features or records.

 

 

 

The Remove duplicates option allows removing all found duplicates but the first ones, i.e. only the first duplicated records will remain in the output dataset. At that, if you select to remove duplicates all other options become unavailable.

 

For indexing duplicates there are two index types provided:

 

• Indexes "0" or "1", where all distinct values indexed with 0, and all others indexed with 1

• Group Indexes 1, 2, 3, 4, ..., where each group of duplicated values indexed with a unique index

 

---