SQL Server Advent Calendar 22 – Spatial Data
Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008..
SQL Server 2008 now has data types to store points lines and polygons in 2 spatial data type, Geometry and Geography. I have already posted quite extensively on spatial data, but it is is one of my favourite new things in SQL Server so all I am going to do here is point you at my blogcasts:
- Geometry based example,
- SQL Server 2008 and Virtual Earth
- SQL Server 2008 Geo-spatial functions and indexes.
There are also some excellent developer resources on spatial data and virtual earth from Mike Ormond, and Johannes Kebeck.
Finally all of this is in all editions of SQL Server 2008, including the free Express editions.
Technorati Tags: spatial,geometry data type,geography data type,sql server 2008
Comments
- Anonymous
December 22, 2008
PingBack from http://bestwebhostingservices.com/andrew-fryers-blog-sql-server-advent-calendar-22-%e2%80%93-spatial-data/