## Top 5 Recent Articles

### 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.

### Snap Point to SQL Server Spatial geometry using TSQL

This function uses the SQL Server Spatial ShortestLineTo function to compute a point on the boundary of the supplied geometry nearest to the supplied point. If the snap distance is < the user supplied @p_snap_within distance, the computed point is returned. However, if the distance is > the user supplied @p_snap_within distance the original point is returned.

### STLocateBetweenElevations

STLocateBetweenElevations — Computes and returns elements that intersect the specified Z range. Function Specification Description Is implementation of PostGIS: Processes the supplied (3D, 3DM) (multi)linestring

### STLineSubstring

STLineSubstring — Returns a substring of the providec linestring starting and ending at the given fractions (between 0 and 1) of total 2D length or

### STLineInterpolatePoint

STLineInterpolatePoint is a PostGIS like function that returns point geometry at supplied fraction along linestring.

### STLineLocatePoint

This function, given a point near a the supplied measure @p_linestring, returns the measure/Measure_Range or length/Total_Length ratio of the found position.

### STFindPointByMeasure

STFindPointByMeasure — Returns (possibly offset) point geometry at supplied measure along linestring. Function Specification. Description. Given a measure, this function returns a geometry point at

### STFindPointByRatio

STFindPointByRatio — Returns (possibly offset) point geometry at supplied length ratio along linestring. Function Specification. Description. Given a ratio (0 to 1.0), this function returns