I am using ArcGIS for Desktop and I have a layer that visually appears to have 50 points. However, the attribute table shows 450 rows, indicating that many points are overlapping. I would like to show only 50 unique points (and have the attribute table reflect that). It is not important which of the overlapping points are saved as I need to do a geospatial analysis and the actual attributes in the table are not important (it's only important that there are 50 of them). How do I create a file with only 50 unique points?
What you could do is:
- Add two fields of type Double, name them X and Y
- In the Attribute table, right click on the X column header, select Calculate geometry and then X Coordinate of Centroid
- Repeat for the Y column
- Select Geoprocessing | Dissolve, select X and Y columns as Dissolve Fields (Make sure you have no features selected, I did that the first try)
Dissolve with no fields, no-multiparts will do. License level doesn't matter.
Alternatively use field calculator expression from my solution here
I am not sure if this is the most ideal solution, but if the points are overlapping you can use collect events to collect all events that occur at a unique point. If there are 10 events at this one point, collect events will create a seperate fc showing just one point with a new field called I_COUNT that will hold the value 10. Since you dont seem to need attribute data this may be an easy way for you.