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 84870

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

3 votes

PostGIS - identify duplicate points from polygons/linestrings?

You can make use of st_dump to get every points of the polygon ring(s), then ignore the starting point as it has to be the same as the last point, and at last to group by geometry (point) and identify …
JGH's user avatar
  • 43.2k
3 votes

Polygons with same geometry and bbox but can't be aggregated with GROUP BY

Two completely different geometries can have the same bounding box: select box2d('polygon((0 0, 1 0, 10 10, 0 0))'::geometry), box2d('polygon((0 10, 1 10, 10 0, 0 10))'::geometry); box2d …
JGH's user avatar
  • 43.2k
4 votes

Duplicates Not Highlighted

It is not working as expected because one of the duplicate is closest to a point having a different name Instead, it is possible to get multiple nearby points - with a max distance - and to count if t …
JGH's user avatar
  • 43.2k
3 votes
Accepted

How do I select features with the same values but different IDs from a layer's attribute tab...

I understand you have multiple polygons and a table of point-polygon intersections, and you want to keep only one polygon out of the many that share exactly the same point-polygon intersections. That …
JGH's user avatar
  • 43.2k