Creating an open source GIS test server Part 2: Installing and Configuring PostgreSQL/PostGIS

In this four part tutorial series, I document the process of creating an open source GIS server using Ubuntu Server, PostgreSQL/PostGIS, Geoserver, and QGIS as the desktop front end. In the first part, I documented the basic process of installing Ubuntu Server on VirtualBox. In this second part, I will document the process of setting …

Creating an open source GIS test server Part 1: Installing VirtualBox and Ubuntu Server

In recent months, I have been asked numerous times for my notes on how to set up an open source GIS server. Although I meticulously document all my installations, my notes were admittedly scattered between several documents that focus on setting up Ubuntu Server, Geoserver, PostGIS, or integrating QGIS. I wrote this tutorial in an …

A brief introduction to PostgreSQL/PostGIS trigger functions

Trigger functions are a useful tool for DB administrators since they can be used to automatically populate fields when rows are inserted, updated, or deleted. Trigger functions can be used to do such things as generate unique IDs that contain concatenated string and number fields, perform calculations on inputted fields, populate metadata fields (e.g. modified …