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