Skip to main content
Solved

Remove duplicate features based on geometry

  • May 31, 2022
  • 4 replies
  • 2772 views

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3422 replies
  • 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
  • 627 replies
  • May 31, 2022

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


  • Author
  • 6 replies
  • 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.

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


  • Author
  • 6 replies
  • May 31, 2022

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.