I am trying to run a st_concavehull after st_boundary/st_exteriorring on polygons, however st_concavehull doesnt seem to reinclose the polygon properly. For example
SELECT ST_GeomFromText('POLYGON((-123.11897224620935 49.277180232191874,-123.1190714879429 49.277147859512795,-123.11909831003305 49.27705424110504,-123.11896889344808 49.277020993403475,-123.11885959343073 49.27706517784409,-123.11901046768781 49.27707961433591,-123.11896889344808 49.277129923289536,-123.11886898116228 49.277155296481496,-123.11897224620935 49.277180232191874))')
Becomes
SELECT ST_ConcaveHULL(ST_boundary(ST_geomFromText('POLYGON((-123.11897224620935 49.277180232191874,-123.1190714879429 49.277147859512795,-123.11909831003305 49.27705424110504,-123.11896889344808 49.277020993403475,-123.11885959343073 49.27706517784409,-123.11901046768781 49.27707961433591,-123.11896889344808 49.277129923289536,-123.11886898116228 49.277155296481496,-123.11897224620935 49.277180232191874))')),0.80)
Why does it become like this? I expected it to return the exact same polygon.
SELECT ST_ExteriorRing(ST_MakeValid(<geom>)) AS geom FROM <your_layer>;
instead. not exactly solving the question, but maybe the issue... – ThingumaBob Nov 28 '18 at 12:37