I have a multipolygon containing a one large polygon, itself containing a number of smaller polygons, which constitute 'holes' in the largest polygon.
My goal is to simplify the multipolygon into one polygon that closely respects the existing perimeter but removes all the smaller polygons (holes)
I have been using a combination of
ST_Dump to get rid of the points and lines, however I can't make this work when there are multiple polygons.
The closest working solution I've found is to use
ST_ConcaveHull(geometry, 0.99), however this does not follow the perimeter of the shape closely enough (it smoothes over the recesses).
I've pasted the text representation of the multipolygon below https://gist.github.com/glennpjones/51acef849825470386f24a6c3259295d
I'm using PostGIS 2.5.
How would you approach this?