Using ArcSDE 9.3 with PostgreSQL, Part 1

First part in a series documenting my experiences with PostgreSQL and ArcSDE 9.3.

Coming Up For Air

Work has a funny way of intruding on blogging. I’ve been writing a LOT of proposals lately. The funny part is that so have a lot of others that I know. Federal, state, local…they seem to have gotten their budgets all at the same time. There are worse problems to have. During this period (which … Continue reading Coming Up For Air →

Quote of the Day…

Abe Gillespie had the quote of the day in his latest post about zigGIS. In describing the development approach (disclaimer: I have been known to dabble in the zigGIS code from time to time although it’s been the Abe show recently), Abe described it as “software 2.0” which, in his words, “doesn’t mean much, but … Continue reading Quote of the Day… →

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:

A Year of GeoMusings

It’s been a year since I stood up GeoMusings. This is my second attempt at blogging. My first, ArcDeveloper, fizzled mainly because of a lack of focus on my part. So I started again on 1 December of 2006. I was originally on Blogger but quickly moved to WordPress. Early on, I started playing with … Continue reading A Year of GeoMusings →

ArcSDE: Time For a Change

Thoughts on where ArcSDE should go.

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 →

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 … Continue reading Bringing It All Together… →

Creating ArcObjects Spatial Reference Objects From PostGIS Spatial Reference Definitions

As discussed in my previous post, I’m trying to beef up the spatial reference support in zigGIS. I am doing this mainly to introduce support for user-defined spatial references. It pretty much boils down to querying the the appropriate SR from the PostGIS spatial_ref_sys table and applying the value of the srtext column to create … Continue reading Creating ArcObjects Spatial Reference Objects From PostGIS Spatial Reference Definitions →

Moving Forward On A Couple of Fronts

Well, it’s been a while since I’ve posted anything technical. Work has been a little crazy and I’m not willing to carve into time with the family to keep other stuff moving. As a result a few things have been sitting for a while but I’ve been able to get around to two things. First, … Continue reading Moving Forward On A Couple of Fronts →