Vector raster overlays in PostGIS 2

Another very common operation using both raster and vector data involves extracting statistics from the raster that falls within a buffer around points. The method shown yesterday can be used to obtain mean values from numerical values. Extracting the percentage of the buffer that consists of each category of a categorical raster requires a slightly…

Working with raster data in PostGIS

I am leaving yesterday’s post online, as the purpose of a weblog is to track changes to knowledge as they occur. However I learned a great deal more about PostGIS raster today, in large part as a result of an email from Pierre Racine. As a result of my new insight I am aware that…

Using PostGIS raster to hold WorldClim data

Although raster support for PostGIS has been around for a while, PostGIS2.0 was the first version to include it by default. There have always been many workarounds that allow data from raster layers to be used in within PostGIS without importing native raster layers as such. There are also many very effective ways of processing…

Installing PostGIS2.0 on Windows 7

I prefer to install PostGIS on Linux. However the new install procedure for PostGIS2.0 has made it very simple to setup on Windows 7. This could make the power of PostGIS more generally available for students who do not use Linux. I recorded the steps when setting up PostGIS this afternoon in order to show…