Site location duplicates

[sebstrutt]

I'm trying to run a workflow to remove duplicates from a location database.

I have used the unique tool which removes one site of two (or more) that match centroids.

However I'm looking to expand this to return one site from any that are within 0.1km of each other, not just those whose centroids are identical, as such there is no unique value to filter on.

My idea is to use distance calculations and a filter, this returns a list similar to the below:

Target site id...Universe site id...Distance

[1]...[35]...[distance <0.1km]

[1]...[2]...[distance <0.1km]

[2]...[1]...[[distance <0.1km]

.

.

.

[35]...[1]...[distance <0.1km]

However I cannot find a way to produce a list that returns [1] only and [2] and [35] to a different list for tagging as "removed from site list"

Many thanks in advance

[Hannah_Lissaman · Accepted solution]

I have built an example of how to produce a list of 'near neighbours' using the spatial tool palette. 

• Use the Trade Area tool to create a trade area with radius which is half the size of your allowed distance i.e. 0.05km
• Use Spatial Match to identify areas which intersect

This will give a list of which points are within 0.1km of each other, which you can use to identify and remove your duplicates.

I have a sample attached - my distance is 100km rather than 0.01km because of my sample data! But the logic is the same.

I have also included the Make Group tool at the end - I noticed that in my example, I had multiple points which were all within the range I had selected. Using the Make Group tool, I can identify all of the associated points so that I can remove all duplicates in one go. In the Make Group results, all IDs in the right hand column are part of a group with the 'Group' ID.