topic Re: extract a statistic from overlapping features (points / polygons) in ArcGIS Pro Questions

extract a statistic from overlapping features (points / polygons)

RamB — Tue, 17 May 2022 05:30:06 GMT

I have a point layer where multiple points overlap. For example, lets take 3 points at the same location. Each point has an attribute X with some number value (integer). What I want to do is, summarize that location. Meaning have only one point at that location instead of 3, and this one resulting point should get the maximum value of the 3 overlapping points.

thank you,

Re: extract a statistic from overlapping features (points / polygons)

AndyAnderson — Tue, 17 May 2022 05:55:49 GMT

Use the Dissolve tool. Dissolve (Data Management)—ArcGIS Pro | Documentation

The points will need a common attribute or attributes to indicate they share the same location. You could get that using their X & Y values.

— Andy

Re: extract a statistic from overlapping features (points / polygons)

RamB — Tue, 17 May 2022 06:35:08 GMT

Yes, thank you. I solved it using the idential tool. This tool automatically assigns a unique ID to "all features" at the same location. So this was easier than using x,y. Then I dissolved on this unique ID.

Re: extract a statistic from overlapping features (points / polygons)

RamB — Tue, 17 May 2022 18:52:19 GMT

I am accepting my own solution for following reasons:

1. getting an unique id via "identical tool" helped me to join it back to the original layer and also to use in the R bridge and perhaps can also be used with python scripts to summarize results based on unique ID.

2. Comparing locations based on x,y which are essentially floating points, this can cause floating point errors if one wishes to use other scripting tools further. I do not know if "identical" tool uses dissolve based on x,y.. then essentially both soltions are the same.

So idential + dissolve help with further analysis in my opinion.

But thank you Andy.

Re: extract a statistic from overlapping features (points / polygons)

AndyAnderson — Tue, 17 May 2022 19:54:41 GMT

Depending on how you generated the points, you’re correct that they may not be perfectly aligned. So the Find Identical tool definitely has an advantage in that it allows you to compare the geometry within a given tolerance, either for machine error or design decision.

— AA