Changes between Version 1 and Version 2 of UsersWikiSplitPolygonWithLineString

Timestamp:

Feb 23, 2011, 10:43:03 PM (13 years ago)

Author:

robe

Comment:

—

UsersWikiSplitPolygonWithLineString

@@ -31 +31 @@
 {{{
 
-SELECT astext(geom )
-FROM dump ((
+SELECT ST_AsText(geom )
+FROM ST_Dump ((
 
-SELECT polygonize(geomunion(boundary(poly), line)) AS mpoly
+SELECT ST_Polygonize(ST_Union(ST_Boundary(poly), line)) AS mpoly
 FROM
    (SELECT 'POLYGON ((1 1, 1 3, 3 3, 3 1, 1 1 ))'::geometry AS poly) AS a,
@@ -48 +48 @@
 
 {{{
-              astext
+              st_astext
 --------------------------------
   POLYGON((1 1,1 2,3 2,3 1,1 1))
@@ -89 +89 @@
 
 CREATE TABLE split_polys AS
-SELECT geom FROM dump ((
-   SELECT polygonize(geomunion(boundary(poly.geom), line.geom))
+SELECT geom FROM ST_Dump ((
+   SELECT polygonize(ST_Union(ST_Boundary(poly.geom), line.geom))
    FROM poly, line
 ));
@@ -96 +96 @@
 DELETE FROM split_polys a
 USING poly b
-WHERE NOT contains(b.geom, pointonsurface(a.geom));
+WHERE NOT ST_Contains(b.geom, ST_PointOnSurface(a.geom));
 
-SELECT astext(geom) FROM split_polys;
+SELECT ST_AsText(geom) FROM split_polys;
 
 }}}
@@ -105 +105 @@
 
 {{{
-                                 astext
+                                 st_astext
 ----------------------------------------------------------------------
   POLYGON((1 1,1 4,2 4,2 3,4 3,4 4,7 4,7 1,1 1))
@@ -137 +137 @@
 {{{
 SELECT geom FROM (SELECT (ST_Dump(g)).geom as geom FROM (
-        SELECT polygonize(g) as g FROM (
-                SELECT geomunion(boundary(geom)) as g FROM geoms
+        SELECT ST_Polygonize(g) as g FROM (
+                SELECT ST_Union(ST_Boundary(geom)) as g FROM geoms
         ) r
-)t) a WHERE EXISTS (SELECT geom FROM geoms b WHERE contains(b.geom, pointonsurface(a.geom)));
+)t) a WHERE EXISTS (SELECT geom FROM geoms b WHERE ST_Contains(b.geom, ST_PointOnSurface(a.geom)));
 
 }}}