[postgis-users] Dice a large polygon

[Nicolas Ribot]

>  If I have a large POLYGON with 10,000 vertices
> Whats a straightforward way to make several, equivalent polygons
> with a maximum number of vertices.. for example, 200 ?
>
>  (hopefull without using postgres common table expressions)
>

Hi,
st_simplify() or st_simplifyPreserveTopology will reduce the number of
vertex of a given geometry, though not preserving the topology between
objects.

Nicolas