Odds and Ends (SpatiaLite and Stuff)

It has been quite a while since I last blogged. The holidays are always a busy time of year with family a friends and work has been somewhat busy as well. We established a new presence in Colorado Springs (I’ll be traveling there at the end of January). Additionally, I’ve been busy with project work … Continue reading Odds and Ends (SpatiaLite and Stuff)

A One-Touch (Almost) Data Loader With FWTools and PostGIS

So my PostGIS/SharpMap/WPF project is ready to go out the door. Literally. The servers are being loaded onto pallets and shipped to their respective destinations. Great! Time for a cold one! Well……maybe not. There’s one little problem: there’s no data on the servers yet. We had to coordinate with a large national government agency to … Continue reading A One-Touch (Almost) Data Loader With FWTools and PostGIS

A Silk Purse…

Well, salvaging the brightest outlook I can from the aforementioned hard drive crash, it does present me with an opportunity to “trim the fat” as it were. So, at first glance here’s the stuff (in no particular order) that will get put back on immediately:

SQL Server 2008 WKT X/Y Switching Illustrated

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 SQL Server 2008 WKT X/Y Switching Illustrated

Inserting SQL 2008 Geometry With a SqlCommand

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 Inserting SQL 2008 Geometry With a SqlCommand

MSDN Article on Mapping with WPF

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 MSDN Article on Mapping with WPF

Exporting ArcObjects Feature Class to PGSQL

The same project that has me working with WPF has me busy on a few fronts. I’ve been spending the last few days writing a tool to export data out of an ArcObjects feature class and dump it to a pgsql .sql file. ArcGIS acts as a serviceable generic data accessor to many vector data … Continue reading Exporting ArcObjects Feature Class to PGSQL