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 107424

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

3 votes
Accepted

Remove duplicate labels for parallel line features in QGIS 3

If your lines have different directions then you can use this filter: angle_at_vertex($geometry,1) <= 180 So only one line gets labled. The one which first vertex has an angle lower than 180 degre …
MrXsquared's user avatar
  • 35.6k
6 votes
Accepted

Selecting duplicates records except one in QGIS

In QGIS you can use "Select by expression" with this expression: array_contains( array_remove_at( array_agg($id, "field"), 0), $id) It will select all duplicates except for th …
MrXsquared's user avatar
  • 35.6k
7 votes
Accepted

Redistributing duplicated points inside the polygon

Here is how you can do this using a PyQGIS script. Open the Python-Console, copy paste the code, change your settings at the top of the code and hit run. You can also cancel the execution via QGIS-Tas …
MrXsquared's user avatar
  • 35.6k
3 votes

Eliminating duplicates only if data is the same according to attributes

You can also use some of the fuzzy matching expression. Here an example using soundex: As expression I am using $id = array_first(array_agg($id,soundex("name"))), which groups names by their soundex r …
MrXsquared's user avatar
  • 35.6k
2 votes

Eliminating duplicates only if data is the same according to attributes

Here are solutions in Python, the first one is a simple script using soundex and the second one a processing tool letting you choose which algorithm to use. 1. Soundex only selecting all features of a …
MrXsquared's user avatar
  • 35.6k
5 votes

Selecting duplicate records except the first and last duplicate with Select by expression in...

You can use this with select by expression: with_variable('arr',array_agg($id, "myfield"), if($id in (@arr[0],@arr[-1]),false,true)) Or for older QGIS versions where index brackets are not supported …
MrXsquared's user avatar
  • 35.6k
14 votes
Accepted

Labeling only one duplicate attribute without editing original data in QGIS

You can achieve something like in the picture just below by using some expressions without editing any of your data. Just use them as they are. Follow the steps below and adjust them to your personal …
MrXsquared's user avatar
  • 35.6k