Opened 5 years ago

Closed 4 months ago

#4350 closed defect (fixed)

MultiLinestring with gap returned as ST_OffsetCurve for simple linestring

Reported by: rouen Owned by: pramsey
Priority: medium Milestone: PostGIS GEOS
Component: postgis Version: 2.3.x
Keywords: ST_OffsetCurve Cc:

Description

I have simple linestring in srid 4326. Transforming it to srid 3857 and calling ST_OffsetCurve with distance -1 (meter) returns multilinestring with gap in the middle.

WITH sample AS (

SELECT ST_SetSRID(ST_GeomFromText('LINESTRING(18.9410244 48.4221217,18.9411421 48.4221211,18.9413075 48.4221223,18.9413848 48.4221223,18.9415133 48.4221223)'),4326) AS geom

) SELECT ST_AsText(geom), ST_AsText(ST_Transform(ST_OffsetCurve(ST_Transform(geom,3857), -1),4326)) FROM sample

Attachments (1)

postgis_offset_bug.PNG (4.1 KB ) - added by rouen 5 years ago.

Download all attachments as: .zip

Change History (3)

by rouen, 5 years ago

Attachment: postgis_offset_bug.PNG added

comment:1 by rkolka, 4 months ago

I stumbled upon this bug in POSTGIS=3.3.3 PGSQL=150 GEOS=3.9.0-CAPI-1.16.2 PROJ=7.2.1 LIBXML=2.9.10 LIBJSON=0.15 LIBPROTOBUF=1.3.3 WAGYU=0.5.0 (Internal)

However, apparently it is fixed in POSTGIS=3.4.1 PGSQL=160 GEOS=3.11.1-CAPI-1.17.1 PROJ=9.1.1 LIBXML=2.9.14 LIBJSON=0.16 LIBPROTOBUF=1.4.1 WAGYU=0.5.0 (Internal)

comment:2 by mdavis, 4 months ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.