topic Select addresses that don't have street numbers in ArcGIS Pro Questions

Select addresses that don't have street numbers

CherylCollins — Thu, 18 Aug 2022 01:35:20 GMT

I want to QA the address field in my table by removing records that don't have a street number anywhere in the cell. Because StreetMap Premium can use a street number that is not at the beginning of the cell, I still want to keep records in which the number is after the street name, so simply sorting or using "begins with" is not an option. I've tried selecting by using "has value(s)" and "doesn't have value(s)," but I keep getting 0 records selected. So for example, if the cell has

Smith Ave 226

how do I come up with a way to either select that record so I can invert the selection or select records that don't have any numbers?

Thanks.

Re: Select addresses that don't have street numbers

DanPatterson — Thu, 18 Aug 2022 08:30:39 GMT

You can use several options

python - Check if a string contains a number - Stack Overflow

but you could try

a = 'Smith Ave 226' # `a` is your field any([i.isdigit() for i in a]) True

will give you records that have a number, either `not` the above or switch the selection

Re: Select addresses that don't have street numbers

CherylCollins — Wed, 24 Aug 2022 21:59:08 GMT

Thanks for the suggestion. I didn't get a chance to check it out because I discovered that what I was doing wrong was using "does not include the value(s)," when I should have been using "does not contain the text" because the address field has both letters and numbers.