[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Is there a faster way to create a polygon overlay?
From:       Jeff Adams <jadams () azavea ! com>
Date:       2010-07-23 18:46:47
Message-ID: AANLkTi=Ct80pj6SyndCDrtNd_DWFfiyJL0-L8MDgrrEK () mail ! gmail ! com
[Download RAW message or body]

This is what I have:

INSERT INTO test_pieces
SELECT geom FROM St_Dump(
	(SELECT St_Polygonize(the_geom) AS the_geom
	 FROM
		(SELECT ST_Union(the_geom) AS the_geom
		 FROM
			(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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]