Skip to content
Menu
geoMusings
  • About
geoMusings

Category: sql server spatial

PgMap Is Now SpatialKit

Posted on 2011-10-25

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…

Continue Reading

SQL Server SIG at the UC

Posted on 2008-08-06

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…

Continue Reading

“Upgrading” to SQL Server 2008 February CTP

Posted on 2008-02-25

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.

Continue Reading

SQL Server 2008 and 2005 Side-By-Side

Posted on 2008-02-01

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…

Continue Reading

SQL Server 2008 Spatial: One Month Later

Posted on 2007-12-28

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:

Continue Reading

SQL Server 2008 WKT X/Y Switching Illustrated

Posted on 2007-12-18

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…

Continue Reading

Inserting SQL 2008 Geometry With a SqlCommand

Posted on 2007-12-18

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…

Continue Reading

MSDN Article on Mapping with WPF

Posted on 2007-12-18

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…

Continue Reading

Spatial References in SQL Server 2008, Part 3

Posted on 2007-12-08

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…

Continue Reading

SQL Server 2008 SharpMap Data Provider Code

Posted on 2007-11-28

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…

Continue Reading
  • 1
  • 2
  • Next

Pages

  • About

Recent Posts

  • New Directions
  • Stripe API Pagination in FME
  • Mission Accomplished
  • Organizational Muscle Memory
  • Integrating Stripe with BigQuery

Meta

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




Web Analytics Made Easy - StatCounter


©2023 geoMusings | WordPress Theme: EcoCoded