Splitting linestring geometries – ST_Split
Building on from this road centerline example, imagine a situation where the newly created centerline has to be split, so that a new driveway can be constructed to service the buildings that are in front of the street it describes. In the following figure the dotted line is the proposed driveway:
To split the new road centerline at the intersection point, a new member function that allows us to split an existing (multi) linestring using a single point needs to be constructed. The algorithm does not require the point to actually fall exactly on the line, rather it can be nearby (though the algorithm will not implement a test that limits the distance the point can be from the line – this can be done as an exercise later on).
The member function is described as follows:
Create or Replace T_Geometry As Object { T_Geometry As Object (
[…]
Member Function ST_Split(p_point In SDO_GEOMETRY,
p_snap In pls_integer default 0)
...