Object Implementation of Oracle SDO_LRS
This article describes how to repackage the functionality in the SDO_LRS package via an PL/SQL object to provide a cleaner neater API.
Linear Referencing
Linear Referencing System (LRS) Functions for TSQL
This articles logically steps through all the functions in a complete package of Linear Referencing functions that I have written for TSQL. The article both demonstrates the power of SQL Server Spatial but what can be done with TSQL.
Using Range Querying to Filter LineString Segments
This article shows how to use range querying against cumulative length to filter/select LineString segments
LINEAR (LRS)
UPDATED: This package of functions underwent a revamp in early July 2012. In that revamp: ST_Locate_Point was overhauled to correctly handle both distance based segmentation of 2D lines as well as Measured geometries (p_value_Type parameter now fully handled). ST prefixes added to public functions._ T_Vector Type enhanced ST_GetVector renamed to ST_Vectorize Bugs fixed in ST_SplitRead More