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 that there are numerous workflows that can be employed to create spatial tables in PostGIS and many of these don’t necessarily register in the geometry_columns table. For example, you can use a standard CREATE TABLE to create a table that includes a geometry column. In this case, the table will not be registered but will still be a valid spatial table. The same can be said for views.
database
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 … Read more
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 … Read more
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 one way or another. Here are a few notes:
SQL Server SIG at the UC
My blogging has been slower this time around because I’ve been doing a lot of booth duty. This is my thrid conference this year and some of our other staff are getting to go to the sessions. I did, however, go to the SQL Server SIG a little while ago. Ed Katibah had a few … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more