topic Re: Locating skipped field values in Data Management Questions

Locating skipped field values

PatMadsen — Wed, 23 Feb 2011 18:05:15 GMT

Hi -
I have access to tools that assist with various field calculations, but what I do not have is a way of identifying any skipped values/records in my data... for instance, I have a feature class with over 1500 records and each of them are attributed with consecutive number values; there are 3 incidents of skipped values and I would like a quick way to locate where these are.
Thanks!
Pat

Re: Locating skipped field values

JoeBorgione — Wed, 17 Aug 2016 15:33:03 GMT

Skipped meaning they are out of order from the others?

10 ?

Can you sort ascending or descending to find them? Look for duplicates?

Re: Locating skipped field values

DarrenWiens2 — Sat, 11 Dec 2021 12:00:02 GMT

You can get at this with Python:

>>> fc = 'points' # feature class/layer
... field = 'Id' # field to inspect
... start = 0 # first value
... stop = 25 # last value
... step = 1 # increment value
... present_values = [i[0] for i in arcpy.da.SearchCursor(fc,field)] # load present values to list
... missing_values = [i for i in range(start,stop,step) if i not in present_values] # compare present values to possible values
... print missing_values‍‍‍‍‍‍‍‍ # print list, or do some thing with values
... 
[0, 9, 15, 16, 21, 22, 23, 24]‍‍‍‍‍‍‍‍‍‍