Skip to content
Menu
geoMusings
  • About
geoMusings

Category: sql server spatial

Spatial References in SQL Server 2008, Part 2

Posted on 2007-11-26

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…

Continue Reading

Spatial References in SQL Server 2008 November CTP

Posted on 2007-11-26

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.

Continue Reading

SharpMap and SQL Server 2008 Spatial

Posted on 2007-11-20

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…

Continue Reading

SQL Server 2008 November CTP Released

Posted on 2007-11-19

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. 🙂

Continue Reading
  • Previous
  • 1
  • 2

Pages

  • About

Recent Posts

  • Analyzing Location Change Over Time in PostGIS
  • Analyzing Location Change Over Time in BigQuery
  • Mornings and Evenings
  • Looking Back, Looking Ahead
  • Lately…

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org




Web Analytics Made Easy - StatCounter


©2021 geoMusings | WordPress Theme: EcoCoded