ST_SIMPLIFYPRESERVETOPOLOGY ​

Generates a simplified representation of a GEOGRAPHY object using a variant of the Douglas-Peucker algorithm while preserving topology.

Vertices within the specified tolerance distance are removed from the simplified geometry.

Syntax ​

ST_SIMPLIFYPRESERVETOPOLOGY(<input>, <tolerance>)

Arguments ​

• <input>: The GEOGRAPHY object to be simplified
• <tolerance>: A FLOAT8 value representing the tolerance in meters

Returns ​

Returns a simplified GEOGRAPHY object that preserves the topology of the input.

Example ​

SELECT ST_AsText(ST_SimplifyPreserveTopology('LINESTRING(0 0, 0.5 0.5, 1 1)'::GEOGRAPHY, 1000));
-- 'LINESTRING(0 0, 1 1)'