A Look at “PostGIS In Action”

Over the past few weeks, I have been reading a copy of the upcoming book by Regina Obe and Leo Hsu titled “PostGIS In Action.” Through my work with zigGIS and some of my consulting work with Zekiah, I have been using PostGIS with good results for some time now. I have found that it matches or exceeds the capabilities of its commercial counterparts and I can be quite productive with it.

Regina has been a frequent contributor to zigGIS discussions over the years and her expertise with PostGIS has definitely helped Abe, Paolo and I as we have worked on it. Also, many tips from the Boston GIS blog/site have been very helpful so I have been looking forward to this book for some time.

Read moreA Look at “PostGIS In Action”

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 get the data we needed. That part of the process experienced a little “slippage”. As a result, the last part of the task changed from loading data onto the servers to developing a data loading tool that could be run from a DVD with minimal involvement from humans. (Those pesky humans.) Just another Monday.

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

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 types and ArcCatalog provides a decent UI for the user community I’m targeting (also, they already have it). As a result, I’ve been developing an ArcCatalog command that exports a selected feature class.

As the title of this post suggests, I didn’t have a lot of time in which to accomplish this task.

Read moreExporting ArcObjects Feature Class to PGSQL