Duncan Golicher's series of articles on PostGIS Raster

Duncan Golicher is researcher in forest ecology at the Colegio de la Frontera sur in Mexico. "The Colegio de la Frontera Sur is a scientific research center that seeks to contribute to the sustainable development of the southern border of Mexico, Central America and the Caribbean through the generation of knowledge, the formation of human resources and the linkage between social and natural sciences."

In the past few months, Duncan has been experiencing a lot with the new raster/vector analysis capacities in PostGIS 2.0 and the integration of PostGIS data in his R workflow. The nicest about it is that he has posted a quite impressive series of articles about his experience in his blog and I thought it was worth sharing them here (so I gain a bit of time to write my next long article :). Here are the posts in chronological order:

• Installing PostGIS in Ubuntu Natty

• Nearest neighbour in POSTGIS

• Connecting to a Postgresql data base from R (Ubuntu Natty)

• Edge to edge distance using PostGIS

• Installing PostGIS2.0 on Windows 7

• Using PostGIS raster to hold WorldClim data

• Working with raster data in PostGIS

• Tile size for raster vector overlays in PostGIS

• Vector raster overlays in PostGIS 2

• Speeding up buffered point on raster overlays in PostGIS

• Building utility functions in PostGIS

• Comparing WorldClim with local climate data

• Loading raster data in PostGIS and visualising the results in QGIS

• Importing Modis fire pixels into PostGIS

• Ten fold speed up using PostGIS2.1.SVN

• Loading Modis NDVI time series into PostGIS raster

• PostGIS raster statistics with PLR

Nice work Duncan!