[postgis-users] Is there a faster way to create a polygon overlay?

Jeff Adams jadams at azavea.com
Fri Jul 23 11:46:47 PDT 2010

This is what I have:

INSERT INTO test_pieces
SELECT geom FROM St_Dump(
	(SELECT St_Polygonize(the_geom) AS the_geom
		(SELECT ST_Union(the_geom) AS the_geom
			(SELECT ST_ExteriorRing(polygon_col) AS the_geom
			 FROM myTable) AS lines
		 ) AS noded_lines

My polygons are ugly though, there are about 5000 of them in myTable
but they overlap a lot (any given one overlaps 100+ others) so there
are going to be a lot of pieces.

More information about the postgis-users mailing list