Microsoft SQL Server Spatial is live – and supported by FME
Many people have been excitedly anticipating the release of Microsoft SQL Server Spatial, and the wait is now over. Because Microsoft holds such a large database market share (some sources state that Oracle, IBM, and Microsoft make up 83% of the market), this move means that the three most widely used database formats now unequivocally support spatial data.
Attending various focus groups over the years, I’ve seen that there’s a clear appetite for spatial data within SQL Server – in fact, people had come up with ways to store spatial data within SQL Server already, but since these methods were not widely accepted they didn’t gain significant traction in the market place. The official support for spatial data within SQL Server will make it easier to introduce GIS in markets where it hasn’t previously been front of mind or practical to implement.
At Safe Software, we try hard to quickly add support in FME for database formats as they emerge because we understand how important it is to for potential users to be able to move their existing data in and out of the new system. We’ve been supporting Microsoft formats for many years now here at Safe, and so it was logical to quickly introduce SQL Server Spatial to FME’s supported formats list last year, well before the updated database was officially released. On a personal note, Ed Katibah and his team provided great support throughout the development process which helped to make the resulting read/write capabilities so crisp.
We’re looking forward to seeing the many projects that FME and SQL Server Spatial will be used in together now that the database has officially hit the market. Johannes Kebeck has already posted one concept on his blog Hanne’s Virtual Earth Blog. Take a look at his workflow involving FME, SQL Server Spatial, and Virtual Earth.
Do you already have plans to use FME together with SQL Server Spatial? Let me know in the comments what you’re planning to do.
Related posts:
I am not able to make use of spatial index without index hint. With index hint it appear to work but in reality it does not as it craetes additional costly data filter.
Anyone expereince this issue at all ?
> I am not able to make use of spatial index without index hint. With index hint it appear to work but in reality it does not as it craetes additional costly data filter.
> Anyone expereince this issue at all ?
Hi Mohammed,
While we have not experimented with this in depth, there are a number of great references on the web that discuss these issues.
For an overview from Microsoft, see http://msdn.microsoft.com/en-us/library/bb964712.aspx.
For two examples discussing why hints may be needed and how to use them, see http://blogs.msdn.com/isaac/archive/2008/08/29/is-my-spatial-index-being-used.aspx and http://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut03.
Finally, for a discussion about diagnosing spatial indices and the role of filters, see http://www.sqlskills.com/BLOGS/BOBB/post/Spatial-Index-Diagnostic-Procs-Intro.aspx and http://www.sqlskills.com/BLOGS/BOBB/post/Spatial-Index-Diagnostic-Procs-Filters.aspx.
My guess is that you need to tune your index with different granularity at each level and/or different parameters, as per my first link above.
Regards,
Paul Nalos
Database Team Lead, Safe Software