[postgis-users] Fwd: ST_OffsetCurve

[Simon Greener]

I have a simple linestring that when i put it into st_offsetcurve a segment goes missing.

It must be something simple that I can't see... Help.

select ST_GeomFromEWKT('SRID=28356;LINESTRING(500307.696019595 6976743.9186081,500308.071454138 6976743.93737982,500308.409115531 6976743.97994064,500309.18401595 6976743.94236971,500309.644736808 6976743.81057794,500310.659151902 6976743.82466703,500311.203930379 6976743.92798709,500311.603 6976743.93)') as geom


union all


select ST_OffsetCurve(ST_GeomFromEWKT('SRID=28356;LINESTRING(500307.696019595 6976743.9186081,500308.071454138 6976743.93737982,500308.409115531 6976743.97994064,500309.18401595 6976743.94236971,500309.644736808 6976743.81057794,500310.659151902 6976743.82466703,500311.203930379 6976743.92798709,500311.603 6976743.93)'),0.02) as g


Regards
Simon
⁣39 Cliff View Drive
Allens Rivulet Tas 7150
(W) 0418 396 391​

On 5 May 2022, 16:28, at 16:28, Simon Greener <simon.greener at brisbane.qld.gov.au> wrote:
>select ST_GeomFromEWKT('SRID=28356;LINESTRING(500307.696019595
>6976743.9186081,500308.071454138 6976743.93737982,500308.409115531
>6976743.97994064,500309.18401595 6976743.94236971,500309.644736808
>6976743.81057794,500310.659151902 6976743.82466703,500311.203930379
>6976743.92798709,500311.603 6976743.93)') as geom
>union all
>select
>ST_OffsetCurve(ST_GeomFromEWKT('SRID=28356;LINESTRING(500307.696019595
>6976743.9186081,500308.071454138 6976743.93737982,500308.409115531
>6976743.97994064,500309.18401595 6976743.94236971,500309.644736808
>6976743.81057794,500310.659151902 6976743.82466703,500311.203930379
>6976743.92798709,500311.603 6976743.93)'),0.02) as g
>
>
>
>
>
>The contents of this email message and any attachments are intended
>only for the addressee and may be confidential, private or the subject
>of copyright. If you have received this email in error please notify
>Brisbane City Council, by replying to the sender or calling +61 7 3403
>8888, and delete all copies of the e-mail and any attachments.
>
>
>SECURITY LABEL: OFFICIAL
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220505/385182a0/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled.png
Type: image/png
Size: 43057 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220505/385182a0/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled.png
Type: image/png
Size: 43057 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220505/385182a0/attachment-0001.png>