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 …
Month: October 2017
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 …