Solved

Cleaning up possible duplicate points

  • 29 June 2021
  • 5 replies
  • 40 views
M
Rank
Badge +2

I have a shapefile with a few thousand points. I would like to be able to remove points that are too close or overlapping on each other.

 

Usually, the points should be at a minimum of 1 meter of each other. If I have points that are exactly at the same coordinates or within let's say 0.8 meter, I would like to keep only the point with the lowest value into the OBJECTID attribute.

 

Any idea of which transformer I should use ?

 

Thank you.

 

Mathieu.

icon

Best answer by theodrogo 29 June 2021, 22:10

View original

5 replies

theodrogo
Rank
Badge

Hey @mlupien​ ,

I've made a quick workspace to help you. It's not optimized, but I hope it will help you!

Here is my methodology :

 

  1. Create a buffer of 1 meter
  2. Perform a PointOnAreaOverlayer and create a list to obtain the ID of all the points which are grouped together within a radius of 1m
  3. Identify the point with the smallest ID within the 1 meter radius
  4. Managing the duplicate and keep only the smallest point ID

 

There are many other ways to make this, but I think this one can work. Also, I don't know what you want to do when this situation happens :

 

Example 

Sorry for my mediocre talents with paint... And hope that will help!

 

Théo Drogo

GIS consultant​ @Consortech PartnerPortalLogin​ 

 

theodrogo
Rank
Badge

@mlupien​ here is my sample data... sorry I forgot to put them on the previous message!

1 Attachment
M
Rank
Badge +2

Looks to be exactly what I was looking for !!

Thank you !

I will integrate this into my workbench and see what it looks like.

M
Rank
Badge +2

Thank you @theodrogo​ !

It did the job !

I will use this into some other workbenches to cleanup data.

theodrogo
Rank
Badge

@mlupien​ 

I'm glad it worked!

 Have a good day (and a good data cleaning 😄)!

Reply


Community Stats

28,707
Posts
109,479
Replies
36,552
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.