Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 Geo-Spatial functions and indexes

SQL Server 2008 Geo-Spatial functions and indexes

  • Comments 2
  • Likes

SQL Server 2008 enables the use of geo-spatial data or location intelligence in four ways:

  • a new geography data type (there's another one for 2D geometry), which can store points, lines, line segments and polygons
  • A rich set of functions to make use of them, e.g. whether they intersect, how far are they away etc.
  • a special indexing mechanism to enable the function to perform quickly
  • Virtual earth integration so your users can see the results on a map without resorting to any extra software investment, while keeping their data in a secure database.

Below is a short blogcast to show how these come together following on from my last two blogcast's on this interesting aspect of SQL Server 2008...

image

Technorati Tags: ,
Comments
  • Geography & Geometry has much significance in day to day life, within that as a data now you can

  • Geography & Geometry has much significance in day to day life, within that as a data now you can

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment