topic Select a point by attribute inside a polygon in Data Management Questions

Select a point by attribute inside a polygon

ManfredSaberbein — Fri, 16 Jul 2021 16:50:05 GMT

Hi, I have 88k polygons with 128k points and I want to select the points with the highest attribute "1-12" inside each polygon.

Thank you

Re: Select a point by attribute inside a polygon

RPGIS — Fri, 16 Jul 2021 17:36:43 GMT

So you can accomplish this using the intersect tool (or similar) in conjunction with other tools, or methods, to determine the highest "1-12" for each polygon assuming that each polygon has that many points inside.

Also, what do you mean by highest attribute "1-12". If you mean ObjectID, then that will take a few more steps.

Re: Select a point by attribute inside a polygon

ThomasHamill — Fri, 16 Jul 2021 18:22:18 GMT

@ManfredSaberbein you could also do this with a Spatial Join. Spatially Join the Points layer to the Polygons layer and select the option that would "Summarize by Maximum."

If you run the Intersect tool instead, I'd recommend running Table To Excel afterwards and pull the data into a Pivot Table for easy summarization (to find the max of the Point field of interest).

Re: Select a point by attribute inside a polygon

ManfredSaberbein — Mon, 19 Jul 2021 15:57:58 GMT

Thank you, I did it! 🎉