database – Page 4 – geoMusings

Using ArcSDE 9.3 with PostgreSQL, Part 2

2008-06-02 by Bill Dollins

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 9.3 for PostgreSQL. The first is the traditional method of importing a feature class via ArcCatalog. (You can also create data in this manner but I haven’t played with that yet.) The second is to register an existing PostGIS table as a layer using the “sdelayer -o register” command-line tool. I will discuss this latter option first.

Using ArcSDE 9.3 with PostgreSQL, Part 1

2008-05-28 by Bill Dollins

This post may cover some similar ground to that which Dave has been treading but I’m just trying to document my experiences as they occur.

By virtue of my association with zigGIS, I’ve been involved with using PostgreSQL and PostGIS in the ArcGIS envrionment for some time now. One of the primary sources of excitement about 9.3 for me was that ArcSDE would finally support PostgreSQL as an RDBMS platform. ArcSDE has always been positioned as an enterprise platform and has, therefore, been rather expensive. This expense has been compounded by the need to also separately license an RDBMS platform such as Oracle, SQL Server or DB2 in addition to ArcSDE. PostgreSQL helps alleviate some of that cost while also providing very advanced capability.

ArcGIS 9.2 SP5 Issue with Oracle

2008-05-02 by Bill Dollins

I just got and e-mail about an issue with ArcGIS 9.2 SP5 and Oracle. The knowledge base article is: http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=34765 Happy reading!

zigGIS Updates

2008-03-28 by Bill Dollins

For those that are interested, Abe has been posting screencasts of the the improvements to zigGIS at the Obtuse site. The zigGIS 2.0 beta will be out soon. The performance of the direct connect to PostGIS has been greatly improved and full editing has been implemented using native ArcGIS tools. There is also a Google … Read more

PostgreSQL Support in ArcGIS

2008-03-18 by Bill Dollins

I just sat through a session titled “Working With the Geodatabase Effectively Using SQL.” It was heavily focused on ST_GEOMETRY. That’s pretty much what they want us to use. Interestingly, though, there won’t be ST_GEOMETRY in SQL Server 2008. They’ve added it to PostgreSQL (more on that later) but not SQL Server. Seems a little … Read more

“Upgrading” to SQL Server 2008 February CTP

2008-02-25 by Bill Dollins

There is no direct upgrade yet so you need to remove the November CTP. Apparently, the uninstall doesn’t always work well (hey, it’s beta). Luckily, Tim’s post straightened me out. This worked for me. More accurately, the guidance in Michael’s comment worked for me.

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

2008-02-13 by Bill Dollins

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.

SQL Server 2008 and 2005 Side-By-Side

2008-02-01 by Bill Dollins

Installing the the SQL Server 2008 November CTP side-by-side with SQL Server 2005 is very straightforward. On the previous build of my machine, I had them both running just fine. After my system crash, I began setting things up again. Because I had been working with 2008 before the crash, I installed that first and … Read more

SQL Server 2008 Spatial: One Month Later

2007-12-28 by Bill Dollins

So it’s been about a month since the release of the SQL Server 2008 November CTP. I’ve been dabbling with it and have made several posts about it. I still have a lot more digging to do with it but here are my impressions after a month:

SQL Server 2008 WKT X/Y Switching Illustrated

2007-12-18 by Bill Dollins

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 … Read more