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 …