Skip to main content
Solved

Cleaning up possible duplicate points


mlupien
Contributor
Forum|alt.badge.img+7

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.

Best answer by thdrg

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​ 

 

View original
Did this help you find an answer to your question?

5 replies

thdrg
Contributor
Forum|alt.badge.img+10
  • Contributor
  • Best Answer
  • June 29, 2021

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​ 

 


thdrg
Contributor
Forum|alt.badge.img+10
  • Contributor
  • June 29, 2021

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


mlupien
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • June 29, 2021

Looks to be exactly what I was looking for !!

Thank you !

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


mlupien
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • June 30, 2021

Thank you @theodrogo​ !

It did the job !

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


thdrg
Contributor
Forum|alt.badge.img+10
  • Contributor
  • June 30, 2021

@mlupien​ 

I'm glad it worked!

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings