Timeline for Polygons with same geometry and bbox but can't be aggregated with GROUP BY
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 18, 2022 at 17:28 | comment | added | Leehan |
Ok Thanks a lot ! So If I want to select all "spatial duplicates" regardless of the order of the vertices, st_equals() has to be chosen.
|
|
| Jan 18, 2022 at 15:36 | comment | added | JGH |
see edits showing how st_equals and = differ
|
|
| Jan 18, 2022 at 15:35 | history | edited | JGH | CC BY-SA 4.0 |
added 516 characters in body
|
| Jan 18, 2022 at 15:05 | comment | added | Leehan |
Sure but why select st_equals(o1.geom,o2.geom) from activite.ouverture o1, activite.ouverture o2 where o1.gid = 230605 and o2.gid = 230606 _- without box2D - returns true, but the GROUP BY geom does not return these duplicates geometries ?
|
|
| Jan 18, 2022 at 14:57 | comment | added | JGH |
st_equals looks at the geometry itself, not the bounding box, so in the example the two geometries won't be equal (despite having the same bbox). Doing st_equals on the two bbox will be true however
|
|
| Jan 18, 2022 at 14:35 | comment | added | Leehan |
ok thanks. So what about st_equals() ? And I have indeed to modify the function.
|
|
| Jan 18, 2022 at 14:33 | history | edited | JGH | CC BY-SA 4.0 |
added 91 characters in body
|
| Jan 18, 2022 at 14:28 | history | answered | JGH | CC BY-SA 4.0 |