Browse by Tags

• 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 Read More... Posted Monday, November 17, 2008 7:53 AM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, spatial

• 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 Read More... Posted Tuesday, January 08, 2008 10:34 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, spatial