Many PostGIS raster queries now run much faster than previously due to optimisation of the underlying code. However speed is still greatly affected by decisions made regarding tile size and data storage. This is an update to a post published around a year ago. Sensitivity tests are easy to run from R using the system.time…

Although it is usually preferable to stick with stable releases of PostGIS for production databases, there are good reasons to use recent development versions for raster processing. Compiling from source on Ubuntu is quick and painless using default settings, providing all the libraries are available. The loaders are compiled and just need installing. PLR can…

Back in May I participated in the Geostat summer school in Quebec by Webinar http://geostat-course.org/ This year’s course concentrated mainly on the use of R for spatial analysis, so I gave a brief tutorial showing how PostGIS can be run through R. The material is available here http://rpubs.com/dgolicher/6373 All the code can be run through…