Changes between Version 3 and Version 4 of UsersWikiSplitPolygonWithPoints

Timestamp:

Apr 27, 2013, 2:21:49 PM (11 years ago)

Author:

nicolasribotosgeo

Comment:

—

UsersWikiSplitPolygonWithPoints

@@ -42 +42 @@
 
 Linear Referencing function st_line_interpolate_point() and st_line_substring() will be used to first locate all points along their respective Linestrings, then cut linestrings based on these locations.
+
 In the first CTE, an union is performed to generate the 0 and 1 line fractions, that are necessary to correctly split linestrings.
+
 To identify each point location for a Linestring, we use the rank() windowing function to generate a ascending id for each successive point location.
+
 Then, a self join of the table will be used to select the 2 locations to give to st_line_substring
 
@@ -69 +72 @@
 where loc2.idx = loc1.idx+1;
 }}}
+
+Splitting is very fast.
+
+Nicolas Ribot.