Timeline for How can I snap lines in PostGIS?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 17, 2019 at 20:28 | answer | added | jbalk | timeline score: 0 | |
| Mar 11, 2013 at 7:55 | comment | added | mrg | A weird thing is that ST_RemovePoint and ST_AddPoint are 0 indexed but ST_PointN is 1 indexed. | |
| Mar 11, 2013 at 7:54 | history | edited | mrg | CC BY-SA 3.0 |
added 634 characters in body
|
| Mar 11, 2013 at 7:40 | vote | accept | mrg | ||
| Mar 11, 2013 at 7:33 | comment | added | simpleuser001 | Thanks you. Could you add example SQL to asnwer ? | |
| Mar 11, 2013 at 7:32 | answer | added | simpleuser001 | timeline score: 5 | |
| Mar 8, 2013 at 14:24 | comment | added | mrg | simplexia - I used St_RemovePoint and ST_AddPoint as a way to replace a vertex (as I couldn't find the ST_ReplacePoint you mentioned). It worked. If you upgrade your comment to an answer I will accept it as the answer I was looking for. | |
| Mar 8, 2013 at 8:47 | comment | added | simpleuser001 | There is ST_AddPoint(line, point, index), ST_RemovePoint(line, index) but you can use only ST_ReplacePoint (line,index,point) then you need ST_PointN(line, index) and ST_NumPoints(line). Add St_Snap twice and replace you old end points with new ones | |
| Mar 8, 2013 at 8:38 | comment | added | simpleuser001 | you could try extract start and end points, snap them and replace old start and end points with data you get from st_snap | |
| Mar 7, 2013 at 17:55 | history | asked | mrg | CC BY-SA 3.0 |