Selecting polygons that intersect with 5 or less points

Question

Hi!

This might be a simple problem, but I keep getting stuck.

So, I have many polygons (about 500). A mass amount of points overlaps these polygons. I want to select only the polygons that intersect with less than 5 points (0 to 5). Once I select these polygons I want to remove them from the map.

I have read up on the SQL (https://community.esri.com/t5/arcgis-pro-questions/perform-a-sql-count-in-calculate-field/td-p/1133936) just an example, and seem to keep running into problems. I feel like this should be an easy solution, but I keep getting stuck!

jcarlson · Accepted Answer

You could probably do it with Arcade, too.

var pts = FeatureSetByName($map, 'points layer name')

var xs_pts = Intersects($feature, pts)

return Count(xs_pts)

The resulting count would give you the ability to select by attribute and delete.