How to delete duplicate lines?

Question

I was wondering if anyone could help. I have a tab file in MapInfo consisting of just polylines. Each is meant to have its own reference number, however some are duplicated (e.g two lines occupying the same position with the same ID's) I can identify these with a query, but what I need to know is if it's possible to delete duplicates and leave one remaining (it doesn't matter which one as they are identical).

Thanks, Alan

(ps. I also have access to QGIS if it is easier in that)

score 16 · Accepted Answer · answered Sep 11 '12 at 12:49

16

Plugin mmqgis for QGIS. http://michaelminn.com/linux/mmqgis/ (http://plugins.qgis.org/plugins/tags/mmqgis/)- Delete Duplicate Geometries

answered Sep 11 '12 at 12:49

spatialhast

3,631
2
27
52

score 6 · Answer 2 · answered Sep 11 '12 at 12:28

6

Have a look at the Delete Duplicates tool that you can find in the Tool Manager. It will let you delete duplicates in a table based on attribute values, such as an ID.

Might be a good idea to create a backup of your table before using the tool.

This is in MapInfo Professional :-)

Peter

answered Sep 11 '12 at 12:28

Peter Horsbøll Møller

7,613
20
26

With this tool, you can select several fields to check for duplicates at the same time (e.g., all the fields except the ID. Like this it checks whether there are duplicate rows). Very handy. – Motti Dec 01 '23 at 08:49

score 3 · Answer 3 · edited Dec 27 '22 at 12:31

3

In QGIS you could try GRASS v.clean (rmdupl), it's included in the Sextante toolkit. See this link.

N.

edited Dec 27 '22 at 12:31

Glorfindel

1,096
2
9
14

answered Sep 11 '12 at 12:36

nhopton

6,983
1
19
36

v.clean(break) in case that lines are overlapping but not completely.

watbywbarif

Dec 05 '16 at 08:35

How to delete duplicate lines?

3 Answers3

Linked