Hi everyone! My db of 150,000 points include 1 to 10 GPS points representing each location due to repeated visits. GPS readings are slightly different due to accuracy and there is no unique ID or name for most of the points to be able to group them on.
Any ideas on how to clean the database and harmonize the data to create a unique ID for each group of points that represent the same feature without having to do that manually?
Many thanks and best regards;
HF
You could do some cluster analysis
Density-based Clustering—ArcGIS Pro | ArcGIS Desktop
sounds like it might do the job if your inter-location spacing exceeds the inter-site spacing.
Once you have identified your clusters, you can establish a centroid(ish) location to represent the location if you want to denote each location with a single point
More general clustering discussion
An overview of the Mapping Clusters toolset—ArcGIS Pro | ArcGIS Desktop
Another idea is to add the coordinate as fields (AddXY) then run a process that round them into the closest 1 meter (or 10 meters depending on your data). Then points with the same coordinate values are identical (without changing the points themselves unless you want to do it).
Have Fun