Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 88814

For questions related to creating, finding, or removing duplicate records or features.

0 votes
Accepted

Extract duplicate points

Use Select by expression with this expression: overlay_equals (@layer) to select all duplicate points. Copy and paste the selected points as a new layer: Menu Edit > Paste Features As > ... [select …
Babel's user avatar
  • 74.9k
2 votes
Accepted

Intersect without duplication (QGIS)

You can use QGIS expressions with the function overlay_intersects( ), available since QGIS 3.16. Set the field type to string as the output will be formatted as text: array_to_string ( overlay_int …
Babel's user avatar
  • 74.9k
5 votes

Removing duplicates from the Attribute table by expression in QGIS

Let's say you have duplicate values in field "value" and want to keep just one of the duplicate: the one with the smallest "id" value: use "Select by expression" with this expression: array_contains ( …
Babel's user avatar
  • 74.9k
6 votes

Eliminating duplicates only if data is the same according to attributes

You have two options, depending on whether the points are actual duplicates (exactely the same point) or if the are "almost" duplicates (very close to one another): Use Menu Processing / Toolbox / De …
Babel's user avatar
  • 74.9k
4 votes
Accepted

Highlight duplicates at nearest distance

You can use expressions to get for each point the id of the closest point with the same attribute value, like name. You can use for this overlay_nearest function (available since QGIS 3.16, for older …
Babel's user avatar
  • 74.9k
1 vote

Removing duplicate features in QGIS based on two conditions

The solution The basic idea is to create two fields with values 1/0 for true/false for the two conditions (let's call them cond1 and cond2). Concatenate the 1/0 values and convert them to a number. Th …
Babel's user avatar
  • 74.9k
1 vote
Accepted

Find and delete duplicate rows in matrix in QGIS 3.6

Avoiding duplicates Creating duplicates should only be a problem if both origin- and destination layer are the same. For different layers, only connections from input to destination are calculated. As …
Babel's user avatar
  • 74.9k
1 vote

Why highlighting duplicates does not work in QGIS?

Use Conditional Formatting (1st screenshot) or Select by expression (2nd screenshot) with this expression (replace value twice by the name of the field where you want to find duplicates). count (value …
Babel's user avatar
  • 74.9k