Skip to main content
Solved

Remove duplicate features based on geometry


I would like to remove duplicate features based on geometry. It's a dynamic workbench where i query out all tables which intersect with a polygon.

 

The problem is that our database contains some duplicated features. For example 1 layer for the whole country, and 1 where it's only a small part of it. So i just want one of these.

 

I have tried to use this guide. But the problem is that the geometry is not 100% alike. So the CRCCalculator gives different values. The coordinates are more exact in one of them.

Any tip on how i could fix this?

 

Here is an example of how the difference is for the same point:

Min_max_extents 

 

Best answer by ebygomm

Have you looked at the matcher? That will let you find geometries that match and allows lenient matching and lets you set a tolerance which should handle the slight differences in precision.

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

4 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • Best Answer
  • May 31, 2022

Have you looked at the matcher? That will let you find geometries that match and allows lenient matching and lets you set a tolerance which should handle the slight differences in precision.


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • May 31, 2022

You could try using the Dissolver transformer with the Group By option set to the country identifier.


  • Author
  • May 31, 2022
ebygomm wrote:

Have you looked at the matcher? That will let you find geometries that match and allows lenient matching and lets you set a tolerance which should handle the slight differences in precision.

Yeah i had tried it, but somehow managed to miss the "Vector Tolerance" field! Thanks! 😁


  • Author
  • May 31, 2022
dustin wrote:

You could try using the Dissolver transformer with the Group By option set to the country identifier.

Thanks for the reply. The previous answer solved my problem in this case.


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