Latitude-Longitude Ordering

Hi Folks, If you’ve been following the spatial forum over at MSDN, you’ve probably run across this thread.  In short, we’ve ignited quite a controversy with the coordinate ordering for the well-known text and well-known binary we use for the geography type: we use latitude-longitude; many would prefer longitude-latitude. While I don’t buy into many of…

16

SQL Server Spatial on the Web

Hi Folks, Now that our initial spatial support has shipped, there has undestandably been an uptick in discission on the web.  It seemed time for a bit of a link post. Besides this blog, the forum I’m most involved in is the Kamai Spatial forum on MSDN, and traffic there is certainly up.  There are even…

2

Spatial Indexing Part 3: Faster Primary Filtering

Hi Folks, Last time we talked about a simple primary filter.  (See previous installments: 1, 2.)  We stopped short, however, of showing how this primary filter would actually make anything faster. Recall that our simple grid index defines a table-valued function (TVF) Grid() that maps spatial objects to a set of integers.  Looking at our…

4