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
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
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
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.
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
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 !
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