[postgis-users] St_OffsetCurve - gaps in the line

[McDonaldR]

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

[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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180214/a899dc9c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 149064 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180214/a899dc9c/attachment.png>