Browse by Tags

All Tags » sql » 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: , ,
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: , ,