Using Intersect Tool with One Layer

06-24-2020 05:57 AM
New Contributor III

Hello again! I'm trying to find the duplicates in one shapefile using the Intersect tool. It works great, but I'd love to know how to get it to tell me WHICH unique ID is the one that it intersects with. The selected features in the picture are the ones that are duplicates, but I'm not sure how to transfer over to Excel so I can show which ID is the duplicate. 

I'd like my final example to look like this:

UniqueID      Duplicate Value ID      Duplicate Value ID 2

9216               9366                              9490

Really, I'd only need the first duplicate value returned if that's easier. Anyone know how to accomplish this? Thanks so much!

0 Kudos
4 Replies
MVP Esteemed Contributor

Do you have an advanced license?

Find Identical—Data Management toolbox | Documentation 

... sort of retired...
New Contributor III

I do. I think Spatial Join solved my problem, but I'm going to try the find identical as well. Thank you!

0 Kudos
by Anonymous User
Not applicable

Hi Lindsey Winn,

Unfortunately there isn't one distinct id that intersect as they are all overlappying by the sounds of it.

As Dan mentioned you could use the Find Identical, and if you want to remove the duplicates you can use the Delete Identical tool.

Delete Identical—Help | ArcGIS for Desktop 

New Contributor III

Thank you! Good idea, I'll try this!

0 Kudos