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.

Read More »

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

Read More »

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

Read More »

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.

Read More »

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

Read More »

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

Read More »

STFindPointByLength

Function finds point at position @p_length along linestring (does not need to be measured) with optional offset to left or right of @p_linestring

Read More »

STLocateAlong

STLocateAlong — Returns (possibly offset) point geometry at supplied measure along linestring. Function Specification. Description. This function is identical to STFindPointByName and so is a

Read More »