[postgis-users] ST_OffsetCurve

Simon Greener simon at spdba.com.au
Thu May 5 14:34:46 PDT 2022


Thanks Paul.
I assume there are a simple set of instructions on how to do this. Our IT Dept took 3 months to add PostGIS to an existing DB! So being able to provide them with the accompanying request will be key.
Simon

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

On 6 May 2022, 04:44, at 04:44, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
>Hi Simon,
>This is going to be one of those annoying "you should upgrade!"
>answers. You should upgrade! 
>In particular, the new offset curve in the latest GEOS (3.10+) does not
>have this behaviour.
>ATB,
>P
>
>> On May 4, 2022, at 11:32 PM, Simon Greener <simon at spdba.com.au>
>wrote:
>> 
>> 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
>>
><Untitled.png><Untitled.png>_______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220506/14bc7d54/attachment.htm>


More information about the postgis-users mailing list