http://weblogs.asp.net/jimjackson/archive/tags/SQL/default.aspxTags: SQLenCommunityServer 2007 SP1 (Build: 20510.895)http://weblogs.asp.net/jimjackson/archive/2009/03/09/sql-2008-geography-and-geometry-data-type-problems.aspxMon, 09 Mar 2009 18:28:42 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:6951738axshon0http://weblogs.asp.net/jimjackson/rsscomments.aspx?PostID=6951738http://weblogs.asp.net/jimjackson/commentapi.aspx?PostID=6951738http://weblogs.asp.net/jimjackson/archive/2009/03/09/sql-2008-geography-and-geometry-data-type-problems.aspx#commentsMy plan was to take my application into SQL 08 from 05 since my hosting service now has it available. I was intent on killing all of my lat/long information and storing my geospatial data in geography columns. Here is what I’m finding about the Geography...(<a href="http://weblogs.asp.net/jimjackson/archive/2009/03/09/sql-2008-geography-and-geometry-data-type-problems.aspx">read more</a>)<img src="http://weblogs.asp.net/aggbug.aspx?PostID=6951738" width="1" height="1">Latitude LongitudeSQLSQL 2008Geography DatatypeGeometry DatatypeGeospatialhttp://weblogs.asp.net/jimjackson/archive/2009/02/13/calculating-distances-between-latitude-and-longitude-t-sql-haversine.aspxFri, 13 Feb 2009 15:40:10 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:6903255axshon2http://weblogs.asp.net/jimjackson/rsscomments.aspx?PostID=6903255http://weblogs.asp.net/jimjackson/commentapi.aspx?PostID=6903255http://weblogs.asp.net/jimjackson/archive/2009/02/13/calculating-distances-between-latitude-and-longitude-t-sql-haversine.aspx#commentsI’ve got lots of lat/long information for my Silverlight 2 application and I’m now tinkering with getting the elevation view working in my spare time. The problem is that the distances are very small and the haversine formulae I’ve located on the internet...(<a href="http://weblogs.asp.net/jimjackson/archive/2009/02/13/calculating-distances-between-latitude-and-longitude-t-sql-haversine.aspx">read more</a>)<img src="http://weblogs.asp.net/aggbug.aspx?PostID=6903255" width="1" height="1">.NETHaversineLatitude LongitudeSilverlightSQL