I'm trying to populate a table with parcel information and assign sequential numbers while dealing with some parcels that have anywhere between 2-50+ entries. One owner has many parcels. Is there a way to query out just duplicates to identify them.

  • 1
    Spatial duplicates, feature on top of feature?
    – artwork21
    Jun 16, 2014 at 14:24
  • What database are you using?
    – Dowlers
    Jun 16, 2014 at 17:13
  • if you want to add a field and query the new field try the identify duplicate query: uniqueList = [] def isDuplicate(inValue): if inValue in uniqueList: return 1 else: uniqueList.append(inValue) return 0
    – MDHald
    Jun 16, 2014 at 18:25
  • if you want to add a field and query the new field try the identify duplicate query. you can access more background on this using the ESRI Technical Article 38700
    – MDHald
    Jun 16, 2014 at 18:27
  • To what are you assigning sequential numbers - parcels, owners, unique owner/parcel combinations, or all records? Based on your question wording, you have a many-to-many relationship (one parcel can have many owners, one owner can have many parcels). It depends on what you're trying to do as to how to solve the problem (and if you care about spatial duplicates, as artwork21 mentions).
    – Chris W
    Jun 16, 2014 at 19:38

1 Answer 1


I've had this exact problem with BUP (Building Unit Plans) where title for each unit in an apartment block was stacked neatly on top of each other.

If you use the feature to point tool to create the centroids it will dutifully create one centroid per polygon. From this you can collect events for exact duplicates, but if they are not exact you will not find them. I planarized the polygons by using feature to line then integrate to snap the boundaries together and feature to polygon - this creates one polygon only for each group of boundaries that should be identical. Then using intersect and summary statistics with a count of the polygon id I could recognize duplicate centroids.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.