I have a feature class with many scattered points. My goal is if there are two points within 1 meter, to identify the point with the lowest
Mean value (it is a quality metric from 0 - 1) and delete it, keeping only the higher one.
I have generated a near table, joined the results, and have also joined another table with intensity values for each relevant point. It looks like this:
You'll note that there are actually 3 points in the cluster highlighted blue. Of these, I wish to keep the one with the highest
Mean value (
The cluster highlighted yellow has two points, and I would keep
ID: 5 and delete
ID: 6, because
ID: 5 has a higher
The end result would look like this:
I would need to iterate through the table (thousands of records), identifying the
Near_FID for each record, selecting its record as well, and comparing the
Mean value. Then finally, deleting the record with the lowest
I'm using ArcMap 10.4. I am not averse to using a Python script or even Access if need be.