Category Archives: PostGIS

PostGIS How-to: NetCDF to PostGIS

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 … Continue reading

Posted in PostGIS, Tips | 5 Comments

PostGIS How to: Calculate the average raster pixel value inside a polygon

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 … Continue reading

Posted in PostGIS, Tips | Leave a comment

PostGIS raster values become integer when Polygonizing

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. … Continue reading

Posted in GDAL, PostGIS | Leave a comment

PostGIS Back-up and restore

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 … Continue reading

Posted in PostGIS | Leave a comment