Timeline for ST_Union in PostgreSQL and QGIS
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 2, 2019 at 7:46 | answer | added | oppia04 | timeline score: 0 | |
| Mar 22, 2019 at 18:22 | vote | accept | oppia04 | ||
| Mar 22, 2019 at 18:20 | vote | accept | oppia04 | ||
| Mar 22, 2019 at 18:21 | |||||
| Mar 22, 2019 at 18:04 | vote | accept | oppia04 | ||
| Mar 22, 2019 at 18:20 | |||||
| Mar 22, 2019 at 2:03 | history | edited | Vince | CC BY-SA 4.0 |
naming
|
| Mar 21, 2019 at 18:57 | answer | added | pdavis | timeline score: 3 | |
| Mar 21, 2019 at 18:11 | comment | added | Vince | It's best practice to use the JOIN operator instead of a list in the FROM clause, so you don't forget to specify the join rule in the WHERE clause. | |
| Mar 21, 2019 at 18:09 | history | edited | Vince | CC BY-SA 4.0 |
naming; formatting
|
| Mar 21, 2019 at 16:13 | comment | added | pdavis | ST_Union() in PostGIS is like the 'Dissolve' tool in QGIS. What you need to use is something like 'select ST_Intersection(a.geom, b.geom) where ST_Intersects(a.geom, b.geom) in order to return the area where both A and B overlap. | |
| Mar 21, 2019 at 15:39 | history | asked | oppia04 | CC BY-SA 4.0 |