Changes between Version 7 and Version 8 of UsersWikiSimplifyPreserveTopology

Timestamp:

04/08/12 07:26:16 (14 months ago)

Author:

nicolasribotosgeo

Comment:

--

UsersWikiSimplifyPreserveTopology

@@ -148 +148 @@
         select gid, code_dept, (st_dump(geom)).* 
         from departement
-) select distinct on (d.code_dept) d.code_dept, qux.geom 
+) select distinct on (d.code_dept) d.code_dept, baz.geom 
  from ( 
-        select (st_dump(st_polygonize(distinct baz.geom))).geom as geom
+        select (st_dump(st_polygonize(distinct geom))).geom as geom
         from (
-                select (st_dump(geom)).geom as geom
+                select (st_dump(st_simplifyPreserveTopology(st_linemerge(st_union(geom)), 10000))).geom as geom
                 from (
-                        select st_simplifyPreserveTopology(st_linemerge(st_union(geom)), 10000) as geom
-                        from (
-                                select st_exteriorRing((st_dumpRings(geom)).geom) as geom
-                                from poly
-                        ) as foo
-                ) as bar
-        ) as baz
-) as qux,
+                        select st_exteriorRing((st_dumpRings(geom)).geom) as geom
+                        from poly
+                ) as foo
+        ) as bar
+) as baz,
 poly d
-where st_intersects(d.geom, qux.geom)
-order by d.code_dept, st_area(st_intersection(qux.geom, d.geom))/st_area(qux.geom) desc;
+where st_intersects(d.geom, baz.geom)
+order by d.code_dept, st_area(st_intersection(baz.geom, d.geom))/st_area(baz.geom) desc;
 }}}