Removing SQL Geography Relief

How to remove "holes" /linestrings/.etc from a GeographyCollection? Secondary, how do you join MPolygons that don't intersect into one polygon?

We have a zipcodes swap onto a geographic map, but we have holes in the shape. Investigated this and this, but I did not find a good way to remove the internal holes.

ConvexHull creates a funky form that is actually not what we want. The goal is to make the area “touch” close to each other so that they are accessible to the person on the map.

.Reduce helps, but it does not delete everything. I just want the outer envelope to be with a small (small) convex hull only if there are two polygons side by side.

Thoughts? Redirection?

+3
source share

Source: https://habr.com/ru/post/1750154/


All Articles