Skip to content

Instantly share code, notes, and snippets.

@romanshuvalov
romanshuvalov / tesselate_to_multipolygon.sql
Created September 7, 2016 13:41
Postgis ST_Tesselate to a multipolygon
-- thank to http://gis.stackexchange.com/questions/209825/converting-tin-to-multipolygon-in-postgis
CREATE OR REPLACE FUNCTION tesselate_to_multipolygon(
geometry)
RETURNS geometry AS
$BODY$
SELECT ST_Collect(geom) AS geom
FROM (
SELECT ST_MakePolygon(ST_ExteriorRing((ST_Dump(ST_Tesselate($1))).geom)) AS geom) as geom_item;
$BODY$
LANGUAGE sql