[postgis-users] ST_CreateTopoGeo

Sandro Santilli strk at kbt.io
Tue Mar 3 01:22:08 PST 2020

On Fri, Feb 28, 2020 at 10:35:48AM +0000, paul.malm at lfv.se wrote:
> Thanks, Sandro!
> It worked with your LOOP! Great!
> The problem I can see on the result (I'm simplifying country polygons) is that the large polygon of Finland, Germany, Italy and Egypt is missing.

Did you get the WARNING for those ?
What I suggested was to change the code to note down which geometries
did not work on first go, to try at inserting them separately.

> I've tried to change the different tolerances (Simplify tolerance and your loop snap-tolerance). If I use simplifying tolerance 2500 m the missing polygons are there, but not when using 5000 m. The countries included in the  original layer is from Sweden, Norway and Finland down to Jordan, Egypt, Libya and Tunisia.
> Ref sys =WGS 84_UTM-33N

So you already found a way to get them all in ?
Tweak that loop to reduce tolerance when needed.


More information about the postgis-users mailing list