topic Re: Select Specific Numbers in ArcGIS Pro Questions

Select Specific Numbers

IsaacAcosta — Wed, 09 Feb 2022 22:09:49 GMT

Is there a way to select numbers by a specific number or a script for it? For example, I want to select all numbers that are multiples of 5. How could i do it?

Re: Select Specific Numbers

HannesZiegler — Wed, 09 Feb 2022 22:32:15 GMT

You can just use list comprehension:

multiples = [n for n in range(100) if n % 5 == 0]

That gives you all the multiples of 5 between 0 and 99. You can substitute range(100) with any iterable that contains numbers and 5 with any number you choose.

Re: Select Specific Numbers

JoshuaBixby — Wed, 09 Feb 2022 22:40:31 GMT

If you want to select all records in a layer that are a multiple of a certain number, say 5, then you can use Select Layer By Attribute/Location and the SQL modulo operator:

MOD(Field, 5) = 0

Note, the implementation of the modulo operator does vary between DBMS, so if MOD doesn't work you can search the internet for the specific modulo syntax for the backend data store you are using.