Alastair on Spatiotemporal with StreamInsight

Alastair Aitchison has started a series on doing spatiotemporal analysis using StreamInsight and the SQL Server spatial library over on his blog. I’ll certainly be watching how he makes out. To answer one question he asks in his post: StreamInsight doesn’t require SQL Server Compact, but if you use it for you use it for…

0

Eye Candy of the Highest Order

Hi Folks, One of the most common questions about the spatial support in SQL Server is how to visualize results.  To illustrate the problem, consider a query over zip code data: select id, shapegeogfrom zipcodeswhere id like ‘981%’ The results, while an accurate description of the data, are profoundly unhelpful: We can improve the human…

24

Our Upcoming Builder API

Hi Folks, We have one more upcoming pre-release before we’re done with SQL Server 2008, and while I’ve posted a few articles about the coordinate order swap, there’s another exciting piece we’re releasing: our builder API. Let’s say you wanted to write a very simple method that shifted a geometry instance in space.  You could write…

9

Where are my Spatial Columns?

Hi Folks, I’ve been asked a few times how to find out what spatial columns are defined in a database.  We don’t have any special table for this, but you can easily find out by looking at the usual system views:SELECT ta.name as table_name, co.name as column_nameFROM sys.tables ta JOIN sys.columns co ON ta.object_id =…

3

More on the Multi-Level Grid

Hi Folks, In my last indexing post, I filled in most of the details about our multi-level grid index.  Let me clean up a few lingering questions about our planar grid. We’ll do this Q&A style: Q: What happens if I set the maximum number of cells-per-object so small that I cannot obtain a covering…

5

The Unexpected Too-Large Polygon

Hi Folks, I recently got contacted via email with the following problem: … I have 2 complex polygons, representing district boundaries.  The polygons look correct, but I’m getting exceptions when I try to create the type. I’ve attached the wkt polygons to the email. These polygons are stored in a table, but I’ve tried it…

4

February CTP Optimizer Issue

Hi Folks,   We don’t call them betas, but that’s basically what CTPs are: they let us suss out problems before we drop a final product on everyone.  Well, we’ve found a regression in the February CTP spatial support that we’d like to let you know about.   Essentially, a costing problem was introduced that…

0

The Upcoming Geography Coordinate Order Swap—A FAQ

Hi Folks, I just thought I’d take a few moments clarify the upcoming coordinate order swap for the geography type.  Here’s a quick FAQ on the issue: What exactly is the change?We are swapping the coordinate order for well-known text (WKT) and well-known binary (WKB) formats from latitude-longitude to longitude-latitude.  E.g., a point in the Seattle area might…

14

Basic Multi-Level Grids

Hi Folks, Last time, we highlighted several problems with a simple grid index.  If you don’t recall—and since it’s been a while, that wouldn’t be a surprise—you may want to review them.  In this post I’ll start to describe how we get around them. In SQL Server, we don’t use a simple grid like the…

3

One Type, Two Types…

This is a little bit less of an introductory post than the last one, but there was quite a bit of discussion about our decision to split our spatial types in two—one for our planar (“flat-Earth”) model and one for our ellipsoidal (“round-Earth”) model—so I thought I’d address it.  To be honest, this is something…

10