Changes between Version 8 and Version 9 of UsersWikiSplitPolygonWithPoints


Ignore:
Timestamp:
Apr 27, 2013, 2:42:22 PM (11 years ago)
Author:
nicolasribotosgeo
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiSplitPolygonWithPoints

    v8 v9  
    4545In the first CTE, an union is performed to generate the 0 and 1 line fractions, that are necessary to correctly split linestrings.
    4646
    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.
     47To identify each point location for a Linestring, we use the rank() windowing function to generate an ascending id for each successive point location.
    4848
    4949Then, a self join of the table will be used to select the 2 locations to give to st_line_substring
     
    7373}}}
    7474
    75 Splitting is very fast.
     75Splitting is very fast compare to other method using st_split(geom, st_expand(point))
    7676
    7777Nicolas Ribot.