I am new to GIS.
I have multiple coordinates of places from Safegraph. I believe there are some duplicates in my file (they have different IDs, but they seem to be identical places based on their names and location), and want to find them.
I thought I can do it by finding the distance to the closest point. For example, if the distance between two points is less than 5 meters, I can suspect they are identical.
I tried using the distance matrix using same input and target layer, trying to find "2" nearest places. I assumed I have one point with distance zero (the identical coordinate) and the other nearest one (what I really want).
But I am getting some weird results--the minimum distance is not zero.
Is there a better way to do this?