Changes between Version 8 and Version 9 of UsersWikiSplitPolygonWithPoints
- Timestamp:
- 04/27/13 14:42:22 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiSplitPolygonWithPoints
v8 v9 45 45 In the first CTE, an union is performed to generate the 0 and 1 line fractions, that are necessary to correctly split linestrings. 46 46 47 To identify each point location for a Linestring, we use the rank() windowing function to generate a ascending id for each successive point location.47 To identify each point location for a Linestring, we use the rank() windowing function to generate an ascending id for each successive point location. 48 48 49 49 Then, a self join of the table will be used to select the 2 locations to give to st_line_substring … … 73 73 }}} 74 74 75 Splitting is very fast .75 Splitting is very fast compare to other method using st_split(geom, st_expand(point)) 76 76 77 77 Nicolas Ribot.