Category Archive: Systems

Mar 07

PostgreSQL Series, Part 2: Learning the Basics

Continuing with our series of utilizing PostgreSQL for your Geodatabase storage needs. Part 1 covered the installation and configuration of creating an empty geodatabase. Part 2 is focused on learning some of the basics: data access, how to backup/restore, and general database maintenance. Geographic Database Consulting highly recommends installing the version of PostgreSQL from EnterpriseDB.com. …

Continue reading »

Jan 09

UDL Properties on 64-bit Windows

Since ArcGIS is still a 32-bit application, it requires that you install the 32-bit Oracle client. If you are trying to use a UDL file on 64-bit windows, and want to use the 32-bit Oracle Provider for OleDB, you need to open the UDL file with the 32-bit Ole DB Providers properties. Do that using …

Continue reading »

Jan 04

Direct Connect made EZ at ArcGIS 10.1

As ESRI pushes more customers toward using Direct Connect, the biggest push back I see is the complexity of dealing with the Oracle client. Installing the full Oracle client on every client machine can be a daunting task, as well as configuring TNSNAMES entries. Oracle recently introduced their “Instant Client” package, which greatly simplifies the …

Continue reading »

Jul 23

Python and GeoProcessing on Linux, part 1

After reading this ESRI blog post, I decided to give this a try with ArcGIS 10.  I love playing with Linux, and I’m pretty good with Python, so this seemed like a fun experiment. I set up a VirtualBox VM with Fedora 13 (32-bit).  Next, I installed Eclipse.  The Fedora version of Eclipse installs PyDev …

Continue reading »

Jan 31

Running Cygwin SSH as a Service

This is not a complete installation guide, there are plenty of those available via Google.  These are my hints/tips, so I remember how to do it next time. 1)  Assuming you already installed Cygwin, along with SSH.  You need to run the config script:   /usr/bin/ssh-host-config 2) This will call CYGRUNSRV.EXE, which creates the service for …

Continue reading »

Dec 26

Creating ISO files on Windows

WARNING:  This is a NON-GIS-related post. In the past 6 months, I’ve started using a lot more “digital media”.  We bought a Canon Vixia HF200 HD camcorder for recording the kids.  We bought a Canon Rebel XTi digital SLR for, well, taking pictures of the kids… With all this digital media, one thing I’ve started …

Continue reading »