Skip to content

Instantly share code, notes, and snippets.

@romanshuvalov

romanshuvalov/tesselate_to_multipolygon.sql

Created September 7, 2016 13:41
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save romanshuvalov/8ac44a84c365e31cf049245c8a4852d7 to your computer and use it in GitHub Desktop.
Save romanshuvalov/8ac44a84c365e31cf049245c8a4852d7 to your computer and use it in GitHub Desktop.
Download ZIP
Postgis ST_Tesselate to a multipolygon
Raw
tesselate_to_multipolygon.sql
-- 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment