When we mapped out the way ahead for zigGIS, we knew we wanted to lay the groundwork to add support for SQL Server 2008 and possibly other database platforms. The way zigGIS was originally constructed, it used the PostGIS geometry_columns table to discover available spatial tables. This has worked well but we came to realize…
Category: postgresql
zigGIS 2.0.2 Enhancements Announced
Abe posted today about upcoming enhancements in zigGIS 2.0.2. These changes address some of the most common feedback that we’ve heard from users. Abe has been working hard to get these changes implemented and released in a timely fashion. Testing will begin shortly. In addition to the flexibility that Abe describes, these changes also begin…
Using ArcSDE 9.3 with PostgreSQL, Part 3.5
I thought I was done with the series a while back but I’ve been getting a steady stream of questions through other channels so I thought I’d wrap up a lot of the common stuff in another post. Most of the inquiries come from people trying to integrate ArcSDE for PostgreSQL with open-source tools in…
A Good PostGIS Overview…
Steven Citron-Pousty gave a talk on PostGIS and has helpfully posted his slides here. It’s a good introductory overview and provides some good examples of basic spatial SQL in PostGIS. With ArcGIS Server now supporting PostgreSQL as a back end RDBMS and also supporting the use of PostGIS geometries, a lot of new users may…
zigGIS and ArcGIS 9.3
Now that ArcGIS 9.3 has been finalized, I have finally gotten around to testing zigGIS 2.0.1 with it. While the source code is available, I wanted to test the unmodified binary distro. I am happy to report that zigGIS appears to work fine with ArcGIS Desktop 9.3. I guess the statement in the zigGIS About…
Using ArcSDE 9.3 with PostgreSQL, Part 3
Well, 9.3 is now shipping so the sun is setting on my time with the release candidate. One update from my first post: I posted the problem I was having with sdelayer -o register not calculate a default extent on the Beta forum and I got a reply that it shouldn’t work that way and…
DMS to Decimal Degrees Function for PostgreSQL
For another project, I had to work with a PostgreSQL table that was storing locations in Degrees/Minutes/Seconds. We had to create an event layer in ArcGIS so they had to be converted to decimal degrees. The server was not using PostGIS and I really had no control over the configuration (although the admins would let…
Oregon PostgreSQL Conference
This came through my inbox. I thought it may be of interest to PostgreSQL/PostGIS/ArcGIS 9.3 users in the Pacific Northwest. Request for proposals: PDXPUG PgDay, due by June 20,2008 PDXPUG PgDay will be on July 20, 2008. This is a one-day conference happening the day before OSCON at the Oregon Convention Center. We are inviting…
Using ArcSDE 9.3 with PostgreSQL, Part 2
In my previous post, I discussed some approaches to configuring PostgreSQL databases and accessing the data in them with ArcSDE 9.3. For this post, I will describe some of my ongoing experiences with getting data into ArcSDE 9.3. There are two main ways that I am investigating of loading/making available your spatial data in ArcSDE…
Using ArcSDE 9.3 with PostgreSQL, Part 1
First part in a series documenting my experiences with PostgreSQL and ArcSDE 9.3.