<div dir="ltr">Hey Dear List,<div><br></div><div>Some showcase of strange ST_OffsetCurve Behavior :</div><div>It returns completely wrong output, even if far from double precision limit (3 to 6 digits remaining).<br>As a proof seconf image show 1k points with the min spacing possible with double precision limit</div>
<div><br></div><div><div>DROP TABLE IF EXISTS test_1 ;</div><div><span class="" style="white-space:pre">                    </span>CREATE TABLE test_1 AS</div><div><span class="" style="white-space:pre">                     </span>SELECT 1,ST_OffsetCurve(ST_GeomFromText('LINESTRING(1000001000 1000001000 ,11000001000 1100001000)'),0.01)</div>
<div><span class="" style="white-space:pre">                    </span>UNION</div><div><span class="" style="white-space:pre">                      </span>SELECT 2, ST_OffsetCurve(ST_GeomFromText('LINESTRING(1000001000 1000001000 ,11000001000 1100001000)'),-0.01)</div>
<div><span class="" style="white-space:pre">                    </span>UNION</div><div><span class="" style="white-space:pre">                      </span>SELECT 3,ST_GeomFromText('LINESTRING(1000001000 1000001000 ,11000001000 1100001000)');</div></div>
<div><br></div><div>image : <a href="http://hpics.li/66442f1">http://hpics.li/66442f1</a></div><div>image : <a href="http://hpics.li/1ae01f8">http://hpics.li/1ae01f8</a></div><div><br></div><div><br></div><div>Cheers,</div>
<div>Rémi-C</div></div>