Browse by Tags
All Tags »
spatial (RSS)
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
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
Read More...
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
Read More...
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
Read More...
I’ve been pretty quiet around here, and at least part of the reason is that we’ve been pretty tight-lipped about what we’ve been up to. We’ve now gone public—we’re providing support for geospatial data in our next version of SQL Server, codenamed Katmai.
Read More...