Happy PostGIS day everyone! Until about year ago, most of my work involved using proprietary GIS software, most of it ArcGIS. Today, almost 100 % of the work i do involve open-source software. Contributing much to this shift has without a doubt been PostGIS. One of my main projects the last year have been the [...]

Disclaimer: I am not sure if this is the quickest way of importing NetCDF files to PostGIS, but it works, and for me that is the most important. If you have any other suggestions for improvements, please post them in the comment field! In my work we need to combine a lot of spatial data [...]

In my daily work I use both vector and raster data and the combination of both. Often, I want to include raster data into our common vector grid. Hence, I often want averaged raster pixel values inside each of the grid cells in our vector grid. To do this, we need to use both the [...]

Lately I have been trying to find out why my raster decimal values are truncated to integer when polygonizing. After some research I found out that this is a known bug (http://trac.osgeo.org/postgis/ticket/650), and the problem lies in the GDALPolygonize function. This function is used in PostGIS to convert raster to vector, and since this function [...]

Ever wondered on what is the most appropriate way of backing up and restoring your precious PostGIS database? Or have you experienced errors when restoring your old database backup file? The solution is, put simple: Do not store your data in the public schema in PostGreSQL! Paul Ramsey explains more in detail on his blog: [...]