Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library November 10th, 2005

Vinod Kumar

This article explains how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server 2005 using C# and table-valued functions. It is possible to use this library to add spatial search to your application without writing any special code. The library implements the public-domain C# Hierarchical Triangular Mesh (HTM) algorithms from Johns Hopkins University. That C# library is connected to SQL Server 2005 using a set of scalar-valued and table-valued functions. These functions act as a spatial index.

Interesting read and catch it from MSDN.

Tags: ,

This entry was posted on Thursday, November 10th, 2005 at 21:08 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply