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 …
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 …
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 …
There are various ways to serve rasters on Geoserver, but when dealing with hundreds or thousands of tiles, it is usually best to process imagery using GDAL. Although one could use Geoserver’s ImageMosaic plugin to serve tiles directly, I have not had much success with this approach when dealing larger datasets (e.g. >1000 tiles) . In …
I was asked this week to perform a fairly simple GIS task: buffer provincially significant wetlands by 120m, buffer other evaluated wetlands by 30m, and merge the results with an existing wetland layer. This would obviously involve a dissolve process since the buffered wetlands would likely create significant overlap between polygons. This task is a …