ST_SimplifyPreserveTopology¶

Simplifies a geometry, ensuring the result is a valid geometry with the same topology.

Usage¶

geometry ST_SimplifyPreserveTopology(geom: geometry, tolerance: double)

Arguments¶

geom (geometry): Input geometry
tolerance (double)

Description¶

Simplifies a geometry, ensuring that the result is a valid geometry having the same dimension and number of components as the input, and with the components having the same topological relationship.

Examples¶

SELECT ST_SimplifyPreserveTopology(
    ST_GeomFromText('POLYGON((8 25, 28 22, 28 20, 15 11, 33 3, 56 30, 46 33,46 34, 47 44, 35 36, 45 33, 43 19, 29 21, 29 22,35 26, 24 39, 8 25))'),
    10
);

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_simplifypreservetopology(st_geomfromtext(Utf8("POLYGON((8 25, 28 22, 28 2 │
│ 0, 15 11, 33 3, 56 30, 46 33,46 34, 47 44, 35 36, 45 33, 43 19, 29 21, 29 2… │
╞══════════════════════════════════════════════════════════════════════════════╡
│ POLYGON((8 25,28 22,15 11,33 3,56 30,47 44,35 36,43 19,24 39,8 25))          │
└──────────────────────────────────────────────────────────────────────────────┘