Browse by Tags

All Tags » spatial (RSS)
Mon, Nov 17 2008 7:53

The problem with America - spatial data

Ok, it's not really a problem with America, just a problem with the perception of straight lines like the USA-Canada border. It's roughly the latitude line 49 degrees north. A line that goes East-West, on a straight line. Except that latitude...
Posted by Rob Farley | 4 comment(s)
Filed under: , ,
Mon, Aug 25 2008 22:11

Map of the world in the Spatial Results tab (and converting from Geometry to Geography)

One of the things on my list of stuff to check out in the RTM version of SQL Server Management Studio in 2008 is the Spatial Results tab that Isaac Kunen talked about a while back . He called it Eye Candy, and it really is. I started by grabbing a set...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Tue, Jan 8 2008 22:34

Querying distances using Spatial data types in SQL 2008

SQL Server 2008 has spatial types which are very useful for all kinds of applications. I thought it would be nice to produce one of those charts like you get in maps, telling you the distance between cities. So I start by populating the data. This uses...
Posted by Rob Farley | 2 comment(s)
Filed under: , ,