Opened 10 years ago
Closed 10 years ago
#2782 closed defect (wontfix)
st_lineMerge not merging
| Reported by: | mjurce | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | |
| Component: | postgis | Version: | 2.0.x |
| Keywords: | Cc: |
Description
st_lineMerge not producing the expected result. Give geom is closed.
select st_astext(st_linemerge(st_curvetoline(st_GeomFromText('MULTICURVE(CIRCULARSTRING(708237.133 153748.878, 708240.630 153778.206,708246.992 153807.048),CIRCULARSTRING(708246.992 153807.048,708246.308 153805.266,708245.236 153803.688),CIRCULARSTRING(708245.236 153803.688,708242.097 153802.592,708239.161 153804.152), CIRCULARSTRING(708239.161 153804.152,708238.274 153806.923,708238.402 153809.829), CIRCULARSTRING(708238.402 153809.829,708232.204 153779.826,708228.571 153749.406), (708228.571 153749.406,708237.133 153748.878))')) ) )
The result is wrong.
Will not paste the result here too long.
Attachments (1)
Change History (3)
comment:1 by , 10 years ago
comment:2 by , 10 years ago
| Resolution: | → wontfix |
|---|---|
| Status: | new → closed |
Since you have a workaround, and it seems to work for me, I'm closing as wontfix
by , 10 years ago
| Attachment: | screenshot_65.png added |
|---|
In this way merges.
select st_asText(st_makeLine(a.geom)) from ( select (ST_DumpPoints(st_curvetoline( st_GeomFromText('MULTICURVE(CIRCULARSTRING(708237.133 153748.878, 708240.630 153778.206,708246.992 153807.048),CIRCULARSTRING(708246.992 153807.048,708246.308 153805.266,708245.236 153803.688), CIRCULARSTRING(708245.236 153803.688,708242.097 153802.592,708239.161 153804.152), CIRCULARSTRING(708239.161 153804.152,708238.274 153806.923,708238.402 153809.829), CIRCULARSTRING(708238.402 153809.829,708232.204 153779.826,708228.571 153749.406), (708228.571 153749.406,708237.133 153748.878))')) )) .geom ) as a
Should linemerge also work. Any drawback usning dumPoints insetead of linemerge?
Thanks.