sql server spatial – geoMusings

PgMap Is Now SpatialKit

2011-10-25 by Bill Dollins

I blogged a while back on PgMap, a freeware ArcGIS extension for directly connecting to PostGIS. ST-Links, the makers of PgMap, sent out an e-mail this morning announcing that PgMap and QMap (the equivalent technology for interacting with SQL Server 2008 spatial data) have been combined into a single tool called SpatialKit. This move comes … Read more PgMap Is Now SpatialKit

SQL Server SIG at the UC

2008-08-06 by Bill Dollins

My blogging has been slower this time around because I’ve been doing a lot of booth duty. This is my thrid conference this year and some of our other staff are getting to go to the sessions. I did, however, go to the SQL Server SIG a little while ago. Ed Katibah had a few … Read more SQL Server SIG at the UC

“Upgrading” to SQL Server 2008 February CTP

2008-02-25 by Bill Dollins

There is no direct upgrade yet so you need to remove the November CTP. Apparently, the uninstall doesn’t always work well (hey, it’s beta). Luckily, Tim’s post straightened me out. This worked for me. More accurately, the guidance in Michael’s comment worked for me.

SQL Server 2008 and 2005 Side-By-Side

2008-02-01 by Bill Dollins

Installing the the SQL Server 2008 November CTP side-by-side with SQL Server 2005 is very straightforward. On the previous build of my machine, I had them both running just fine. After my system crash, I began setting things up again. Because I had been working with 2008 before the crash, I installed that first and … Read more SQL Server 2008 and 2005 Side-By-Side

SQL Server 2008 Spatial: One Month Later

2007-12-28 by Bill Dollins

So it’s been about a month since the release of the SQL Server 2008 November CTP. I’ve been dabbling with it and have made several posts about it. I still have a lot more digging to do with it but here are my impressions after a month:

SQL Server 2008 WKT X/Y Switching Illustrated

2007-12-18 by Bill Dollins

UPDATE: Microsoft has announced that they will address this issue in an upcoming CTP. They plan to implement longitude-latitude ordering in WKB and WKT for both the geography and geometry types. In a response to my previous post, Brian Flood mentioned the ongoing discussion about SQL Server 2008 and the “switching” of X and Y … Read more SQL Server 2008 WKT X/Y Switching Illustrated

Inserting SQL 2008 Geometry With a SqlCommand

2007-12-18 by Bill Dollins

Update (7/1/2011): I wrote this post early in the SQL 2008 CTP. I no longer use the method described here. If you found this post via StackOverflow or some other Q&A site, I highly recommend this post by Vish as a more efficient way of doing things: http://viswaug.wordpress.com/2008/09/29/inserting-spatial-data-in-sql-server-2008/ I’m in the process of using SharpMap … Read more Inserting SQL 2008 Geometry With a SqlCommand

MSDN Article on Mapping with WPF

2007-12-18 by Bill Dollins

I found this article today about using VB9 and WPF to draw thematic maps. It’s a good walk-through of how to do it. The article admits that the coordinate transformation used is not terribly accurate but that can be rectified. This article is a good example of how to build a mapping application without any … Read more MSDN Article on Mapping with WPF

Spatial References in SQL Server 2008, Part 3

2007-12-08 by Bill Dollins

A little clarification is in order: SQL Server 2008 Books Online makes the following statement about SRIDs: “A SQL Server-supported SRID for geography instances must be used when performing calculations or using methods with geography spatial data. The SRID must match one of the SRIDs displayed in the sys.spatial_reference_systems catalog view.” As previously noted, SQL … Read more Spatial References in SQL Server 2008, Part 3

SQL Server 2008 SharpMap Data Provider Code

2007-11-28 by Bill Dollins

As promised, I have uploaded the data provider code I mentioned earlier to the SharpMap site. It’s written in C#. I took the existing Oracle provider, stripped out the Oracle SQL and put in T-SQL. There are a couple of things I’m still trying to chase down but it’s basically done at this point. I know they’re busy trying to finish up SharpMap 2.0 so I don’t know how long it’ll take to become available. Just in case, here’s the code: