Changes between Version 3 and Version 4 of UsersWikiBuildPolygonsWithLines

Timestamp:

Apr 8, 2015, 11:27:55 PM (9 years ago)

Author:

Mike Taves

Comment:

also consider closed LINESTRINGS

UsersWikiBuildPolygonsWithLines

@@ -13 +13 @@
 ) t1,
 (
-  SELECT ST_Union(ST_Intersection(A.geom, B.geom)) AS pt
-  FROM data A, data B
-  WHERE A.path[1] < B.path[1] AND ST_Intersects(A.geom, B.geom)
+  SELECT ST_Union(geom) AS pt
+  FROM (
+    SELECT ST_Intersection(A.geom, B.geom) AS geom
+    FROM data A, data B
+    WHERE A.path[1] < B.path[1] AND ST_Intersects(A.geom, B.geom)
+    UNION SELECT ST_StartPoint(geom) FROM data WHERE ST_IsClosed(geom)
+  ) s
 ) t2
 WHERE ST_Intersects(ST_StartPoint(geom), pt) AND ST_Intersects(ST_EndPoint(geom), pt);' LANGUAGE sql IMMUTABLE;