Geometry Validity and Method Access

Introduction All database spatial types that I have worked with have constructors based on Well Known Text (WKT). When constructing a geometry all those types check the WKT’s structure. So, for example, the polygon below is wrong for two reasons: 1. It does not have its exterior ring correctly defined (eg “POLYGON((…))” ; 2. ItRead More

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.