Timeline for PostGIS: Correct way of using ST_Union/ST_Difference with or without gridsize
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| yesterday | answer | added | Bartłomiej Wierciński | timeline score: 0 | |
| yesterday | vote | accept | Bartłomiej Wierciński | ||
| Dec 10 at 1:35 | comment | added | dr_jts | Using a different SRID won't solve this problem, since the algorithms for overlay and relationships are the same for all coordinate systems. | |
| Dec 6 at 20:57 | answer | added | dr_jts | timeline score: 0 | |
| Dec 5 at 20:17 | history | edited | Vince | CC BY-SA 4.0 |
naming; removed helpmes
|
| Dec 5 at 19:31 | comment | added | Bartłomiej Wierciński | I would like to underline that my issue is how to edit geometries correctly and that the output geometry is with those weird spikes and how to avoid them so geometry looks like it should and st_touches will work | |
| Dec 5 at 18:15 | comment | added | Mapperz♦ | postgis mbr (minimum bounding rectangle) or bbox (bounding box) gis.stackexchange.com/questions/4067/… see ST_OrientedEnvelope and postgis.net/docs/ST_Envelope.html (these are efficient as your sending/scanning less coordinates) for calculation. | |
| Dec 5 at 18:10 | comment | added | Bartłomiej Wierciński |
Thanks for your reply. I meant instead of using st_touches, i can use st_intersection(g1, postalcode, 1e-9) and then check if the outcome is multilinestring. What is mbr? Please also check out EDIT in main post.
|
|
| Dec 5 at 17:58 | history | edited | Bartłomiej Wierciński | CC BY-SA 4.0 |
added 116 characters in body
|
| Dec 5 at 17:52 | comment | added | Mapperz♦ | st_intersect might be a more efficient way and using mbr [&&] gis.stackexchange.com/questions/393316/… and uses spatial indexes if available. | |
| S Dec 5 at 17:37 | review | First questions | |||
| Dec 5 at 18:07 | |||||
| S Dec 5 at 17:37 | history | asked | Bartłomiej Wierciński | CC BY-SA 4.0 |