topic Re: Show points when count of attribute is greater than n in ArcGIS Pro Questions

Show points when count of attribute is greater than n

AndrewIngall2 — Thu, 15 Feb 2024 19:40:39 GMT

Hello

I have a load of point data which i have filtered down to just show business properties, which works fine. I am now trying to show only those properties where the number of premises on a street is greater than n.

I know I am missing something simple here, but how do i show only those records when the count of the street is greater than or equal to 'n'?

street 1 ID - count 5 do not show

street 2 ID - count 10 show

Thanks

Re: Show points when count of attribute is greater than n

Ed_ — Thu, 15 Feb 2024 20:21:08 GMT

One way could be Arcade, now I am not an Arcade expert but this, Symbology, Arcade and Group By might help.

Another option could to be use the `Summarize` tool to get a `count` column for `n`, then join (Join Field tool) that `count` column from the summary statistics table to your point data. After the join, run a query where `count` is `5` do not show and show. Hope this helps, cheers and good luck 🙂

Re: Show points when count of attribute is greater than n

Bud — Thu, 15 Feb 2024 23:51:58 GMT

Can you explain why a definition query won’t work?

Can you provide a screenshot of your data including the attribute table?