With some guidance from Paul Ramsey, I implemented a check constraint on my sample table to allow only a single SRID in a table. As Paul indicated in his comment on my previous post, PostGIS does this for you. SQL 2008 doesn’t yet but I hope it does. The syntax for my table was: [sourcecode…
Category: sql server spatial
Spatial References in SQL Server 2008 November CTP
I’ve been playing with the SQL 2008 November CTP since it was released last week and have been generally impressed but as I have delved into its handling fo spatial references, I have noted some areas of concern. Keeping in mind that it’s a CTP, I’m hoping that some aspects may be addressed before release.
SharpMap and SQL Server 2008 Spatial
I downloaded the November CTP yesterday and couldn’t resist. Today I wrote a SharpMap data provider for it. The black rectangle below represents a sample data set I created. It’s not as pretty as the Mexico data I used with SQLite but it’s beautiful to me. It’s being displayed in the DemoWinForm app that comes…
SQL Server 2008 November CTP Released
It’s downloading as I write. Here’s the link. Now the rest of us can try the spatial support! This is something that’s been long overdue from Microsoft. It’s time to lock myself in the basement. 🙂