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…
Category: postgis
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…
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…
Spatial References in SQL Server 2008, Part 2
With some guidance from Paul Ramsey, I implemented a check constraint on my sample table to allow only a single SRID in a table. As Paul indicated in his comment on my previous post, PostGIS does this for you. SQL 2008 doesn’t yet but I hope it does. The syntax for my table was: [sourcecode…
Whither zigGIS?
Things have been a little quiet (publicly) with zigGIS, owing mainly to outside workload. For those of you who may be wondering, Abe Gillespie, the original author of zigGIS is now more fully engaged on it and making some updates. He should have some announcements in the coming weeks but I just wanted to float…
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…
Way Ahead for zigGIS
Abe, Paolo and I had a chat session yesterday to coordinate efforts on zigGIS. It was good session and we’re all on the same page with getting zigGIS solidified. The general theme of the outcome from yesterday is that we want to make zigGIS a solid experience for PostGIS users first. We have discussed other…
ZigGIS Catalog Objects
Things have been REALLY slow on zigGIS for a while. All of us (Paolo, Abe, me) have all been up to our eyeballs with work, leaving little time to work on the zig. Now that Abe is out on his own, the three of us have been trying to coordinate a chat session to lay…
Flashback…
Just back from vacation 🙁 and as a way of easing back into things, I have been tinkering with my WCF project that’s been sitting while the paying work has gotten done. It’s the one that wraps PostGIS coordinate conversion as a web service written using WCF. My copy of “Professional WCF Programming” arrived while…
Bringing It All Together…
These are pretty fun times to be working in GIS. There’s an explosion of new technologies across the whole spectrum and integration possibilities are seemingly boundless. Back when I got started, ESRI and Intergaph were duking it out and others, like MapInfo, were out there on the periphery also. GRASS was flying the OS banner…