[postgis-users] Is there a faster way to create a polygon overlay?
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