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 <[email protected]> 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 <[email protected]> >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 >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > >------------------------------------------------------------------------ > >_______________________________________________ >postgis-users mailing list >[email protected] >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
