Re: [postgis-users] ST_CurveToLine and ST_LineToCurve problems

2021-11-12 Thread Bruce Rindahl
As Paul mentioned, this has been an issue for a while. I ran into this when I needed to precisely divide a circle into a specified number of points. I finally had to generate the points directly. To get a table of points precisely spaced around a circle: with parameters as ( select 101.0 as

Re: [postgis-users] ST_CurveToLine and ST_LineToCurve problems

2021-11-12 Thread Marcin Mionskowski
Hi Paul, I'm very grateful for your response. You are right with "cheating" when it comes to non-equal results of ST_LineToCurve on "supposedly" same input, which I described as my second problem (in this case I would use the buffer with minimal number of segments anyway). But that doesn't *fully*

Re: [postgis-users] ST_CurveToLine and ST_LineToCurve problems

2021-11-10 Thread Paul Ramsey
> On Nov 10, 2021, at 7:24 AM, Marcin Mionskowski > wrote: > > So... Are what I have described bugs or is it supposed to work this way? Mostly things are supposed to work this way. Remember you are "cheating", you see the original input run it through linetocurve/curvetoline, whereas the

[postgis-users] ST_CurveToLine and ST_LineToCurve problems

2021-11-10 Thread Marcin Mionskowski
Dear List, I ran across two issues with CurvePolygons today: 1. "The last vertex problem" - result of ST_CurveToLine conversion is missing the "last" vertex: with p as (select ST_SetSRID(ST_MakePoint(50,60),2180) geom) --just a point , b as (select st_buffer(geom,10,2) geom from p)