[postgis-users] St_OffsetCurve - gaps in the line

[Darafei "Komяpa" Praliaskouski]

Hi Ross,

Can you please file a ticket on https://trac.osgeo.org/postgis/ and share
the geometry that reproduces behavior there, in form of WKB?

ср, 14 февр. 2018 г. в 21:19, McDonaldR <McDonaldR at angus.gov.uk>:

> Hi List
>
>
>
> I’m using the following query to offset my geometry from a road centre
> line.
>
>
>
> SELECT row_number() OVER () AS gid,
>
>     gm_scrim_master_b.esu_id,
>
>     st_curvetoline(st_offsetcurve(gm_scrim_master_b.geometry, 3::double
> precision, 'quad_segs=8 join=round'::text)) AS geometry
>
>    FROM roads.gm_scrim_master_b
>
>   WHERE st_isvalid(gm_scrim_master_b.geometry);
>
>
>
> SELECT row_number() OVER () AS gid,
>
>     gm_scrim_master_b.esu_id,
>
>     st_curvetoline(st_offsetcurve(gm_scrim_master_b.geometry, -3::double
> precision, 'quad_segs=8 join=round'::text)) AS geometry
>
>    FROM roads.gm_scrim_master_b
>
>   WHERE st_isvalid(gm_scrim_master_b.geometry);
>
>
>
> If I offset one way I get a nice complete line.  If I go the other way I
> get a line with gaps in it.  The source data is LINESTRING and I am
> checking validity to see if that is an issue.  Anyone got any suggestions
> as to where to start looking?
>
>
>
> Thanks in advance
>
>
>
> Ross
>
>
>
> [image: cid:image001.png at 01D3A5AF.0FD714D0]
>
>
>
> *Ross McDonald | *GIS Data Coordinator | Angus Council, People, IT |
> Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT* | t:
> 01307 476419*
>
>
>
>
> This message is strictly confidential. If you have received this in error,
> please inform the sender and remove it from your system. If received in
> error you may not copy, print, forward or use it or any attachment in any
> way. This message is not capable of creating a legal contract or a binding
> representation and does not represent the views of Angus Council. Emails
> may be monitored for security and network management reasons. Messages
> containing inappropriate content may be intercepted. Angus Council does not
> accept any liability for any harm that may be caused to the recipient
> system or data on it by this message or any attachment.
> _______________________________________________
> 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/20180215/89294c94/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 149064 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180215/89294c94/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 149064 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180215/89294c94/attachment-0001.png>