Re: [postgis-users] Odd st_buffer behaviour

2013-11-26 Thread Rémi Cura
Also in your small code snippet you did't ensure that all your line where simple linestring (and not multilinestring). Just to be sure : SELECT COUNT(*) FROM ukrds WHERE ST_IsSimple(geom)=FALSE Cheers, Rémi 2013/11/25 James David Smith james.david.sm...@gmail.com Steve, Thanks, you are of

Re: [postgis-users] Odd st_buffer behaviour

2013-11-26 Thread Mike Toews
On 26 November 2013 06:04, James David Smith james.david.sm...@gmail.com wrote: 2) Now I buffer it: SELECT ST_Buffer( ST_GeomFromText( 'LINESTRING(555936.152 200920.58202,555938.31202 200908.10202,555943.11201 200883.14201,555953.19201 200839.702,555964.47199

Re: [postgis-users] Odd st_buffer behaviour

2013-11-26 Thread Rémi Cura
About sharp turns : you could use a small buffer then errosion or straight skeleton (out of the box with sfcgal). For the flat encapt I suggest you to use st_split afterward. Cheers, Rémi-C 2013/11/26 Mike Toews mwto...@gmail.com On 26 November 2013 06:04, James David Smith

Re: [postgis-users] Odd st_buffer behaviour

2013-11-26 Thread James David Smith
Thanks for the suggestions and feedback everyone. On 26 November 2013 08:49, Rémi Cura remi.c...@gmail.com wrote: About sharp turns : you could use a small buffer then errosion or straight skeleton (out of the box with sfcgal). For the flat encapt I suggest you to use st_split afterward.

Re: [postgis-users] Odd st_buffer behaviour

2013-11-25 Thread James David Smith
Apologies. I think I've just answered this myself. It's the 'endcap=flat join=round' bit isn't it. It's not doing what I am expecting it to do. Though I'm not quite sure how to fix it yet. On 25 November 2013 17:04, James David Smith james.david.sm...@gmail.com wrote: Hi there, Some code to

Re: [postgis-users] Odd st_buffer behaviour

2013-11-25 Thread Rémi Cura
Does offset curve gives the same result? (seems lile offsetting both side have same behavior) Maybe you can try several buffers with increasing size? (default appears wau before 1000) Also, can you try to simplify your line : each coordinates uses 15 digits, surely you don't need all of this !

Re: [postgis-users] Odd st_buffer behaviour

2013-11-25 Thread James David Smith
Steve, Thanks, you are of course right. I hadn't thought of that. Makes sense. James On 25 November 2013 17:58, Stephen Woodbridge wood...@swoodbridge.com wrote: This is because lines shaped like say an Omega character, will create an island inside the character at a certain offset and this