Search Results
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 |
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 …
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 …
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 …
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 …