topic Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS in ArcMap Questions

How Can I Find The Missing Sequence Number in a Field in ArcGIS

MAMDOUHZALAKY — Fri, 08 Sep 2023 07:20:27 GMT

How Can I Find The Missing Sequence Number in a Field in ArcGIS I have thousand numbers on that field ? I have ArcGIS 10.8

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

JohannesLindner — Fri, 08 Sep 2023 09:30:16 GMT

You can do it with a little Python script:

fc = "TestPolygons" # path the the feature class or name of the layer field = "IntegerField1" # get a set of values in the field values = {row[0] for row in arcpy.da.SearchCursor(fc, [field])} # get a set of the complete range complete_values = set(range(min(values), max(values))) # the difference between these sets are the missing numbers missing_values = complete_values - values print(sorted(missing_values))

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

MAMDOUHZALAKY — Sat, 09 Sep 2023 05:37:57 GMT

what should I change in your Python script to work , I create field test to run your Python script but it does not work , I want to know the missing number in field parcel ….I need more details!!!

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

MAMDOUHZALAKY — Sat, 09 Sep 2023 05:30:53 GMT

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

JohannesLindner — Sat, 09 Sep 2023 06:25:45 GMT

The script is meant to be run in the Python Window, not in the Fieled Calculator.

Open the ArcMap Python Window
Copy/Paste the script into the window
Change the first two lines
Execute by pressing Enter (may have to press it twice)

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

MAMDOUHZALAKY — Sat, 09 Sep 2023 15:38:44 GMT

Ok now its work …. but can we make another change in the python script to let him give us the missing number in group A and the missing number in group B , because the missing number in group A is different than the missing number in group B.

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

JohannesLindner — Mon, 11 Sep 2023 07:29:32 GMT

fc = "TestPolygons" # path the the feature class or name of the layer field = "IntegerField1" group_field = "TextField1" # read the fc data = [row for row in arcpy.da.SearchCursor(fc, [group_field, field])] # iterate over the groups groups = {d[0] for d in data} for g in sorted(groups): # get the values in that group values = {d[1] for d in data if d[0] == g} # get a set of the complete range complete_values = set(range(min(values), max(values))) # the difference between these sets are the missing numbers missing_values = complete_values - values print("Missing values in group {}: {}".format(g, sorted(missing_values)))

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

MAMDOUHZALAKY — Mon, 11 Sep 2023 14:55:25 GMT

Thank You Very Much For Your Great Solution

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

Krocha — Wed, 16 Oct 2024 19:57:14 GMT

Hello i am receiving this error message when trying to run.

fc = r"path"
field = "FXSA_ID"

# get a set of values in the field
values = {row[0] for row in arcpy.da.SearchCursor(fc, [field])}
# get a set of the complete range
complete_values = set(range(min(values), max(values)))
# the difference between these sets are the missing numbers
missing_values = complete_values - values
print(sorted(missing_values))

Traceback (most recent call last):
File "<string>", line 7, in <module>
TypeError: '<' not supported between instances of 'NoneType' and 'int'

Re: How Can I Find The Missing Sequence Number in a Field in ArcGIS

Krocha — Fri, 25 Oct 2024 20:44:53 GMT

Never mind i got it. I had some fields that did not have a number they were NULL. Had to remove those. Not sure if there is a way to ignore them.