## Top 5 Recent Articles

### STLocateBetween

STLocateBetween — Extracts, and possibly offet, linestring using supplied start and end measures and @p_offset value. Function Specification. Description. Given a start and end measure,

Read More »

### Projecting (snapping) a SQL Server Spatial point to a geometry using TSQL

This function snaps a point to a linestring. If there is more than one possible solution the first point is returned. Computes Z and M values if exist on linestring. If linestring is 2D, the length from start of the linestring to the point is returned in M ordinate of point.

Read More »

### STFindMeasureByPoint

STFindMeasureByPoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. Description. Given a

Read More »

### STFindMeasure

STFindMeasure — Snaps input point to measured linestring returning measure value Function Specification. Description. Given a point near a the supplied measure @p_linestring, this function

Read More »

### STInterpolatePoint

STInterpolatePoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. Description. This function

Read More »

### STFindOffset

STFindOffset — Compute smallest perpendicular offset from supplied point to the supplied linestring. Function Specification. Description. Given a point near @p_linestring, this function returns the

Read More »

### STSplitProcedure

STSplitProcedure — Procedure that splits a line into two parts. Function Specification. Description. Splits @p_linestring at position defined by @p_point. If @p_point is not on

Read More »

### Split SQL Server Spatial Linestring at a known point using TSQL

The STSplit TSQL function splits a linestring into two parts at a supplied point. If the point is not on the line it is first snapped (cf STSnap function) to the line. The function supports LineStrings, and CircularStrings or CompoundCurves.

Read More »

### STRemoveMeasure

STRemoveMeasure — Function that removes measure values from all points in linestring. Function Specification. Description. Removes all measure ordinate values. Linestring with XYM ordinates is

Read More »

### STIsMeasureDecreasing

STIsMeasureDecreasing — Checks if M values decrease in value over the whole linestring. Function Specification. Description. Checks all measures of all vertices in a linestring

Read More »