Timeline for Seeking PostGIS equivalent to GeoPandas union overlay?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2018 at 12:14 | comment | added | Asad Abbas | You can check there will be no overlaps, ST_collect is same as st_union only difference is that it does not merge boundaries but it returns geometry collection so to get polygons from geometry collection st_dump is used | |
| Nov 13, 2018 at 11:56 | comment | added | RutgerH | can you explain why you use ST_dump and ST_collect ? | |
| Nov 13, 2018 at 11:44 | comment | added | RutgerH | Almost. One comment: The preferred result is that none of the geometries overlap i.e. if you look at the image with the seven colors, the green geometry is a multipolygon with two rectangles. If you query the result layer at a random location, you only find 1 layer i.e. not stacking / overlap. | |
| Nov 13, 2018 at 11:21 | history | answered | Asad Abbas | CC BY-SA 4.0 |