[postgis-users] PostGIS Raster and IDW

[Mr. Puneet Kishor]

Check out http://earth-base.org/fossils for my heat map implementation. I calculate the clusters in PL/R, and send the data to the browser as json and construct the heatmap in the browser.

I will clean up the PL/R code and publish it on my web site and post a notice on this list soon as I get some breathing time.

On Mar 27, 2012, at 10:35 PM, John Callahan wrote:

> The gdal_grid tool supports IDW interpolation.  I've used ths for CSV files
> to TIFs.  Very recent versions of GDAL should be able to read/write to
> postgis rasters.   Check out  http://www.gdal.org/gdal_grid.html
> 
> Personally, I would love to have postgis do spatial interpolations.
> However, the last I checked into this, PostGIS does not really have any
> spatial interpolation methods (IDW, kriging, splines) built in.  I saw some
> examples of people integrating R functions into postgres pl/sql:
> http://www.joeconway.com/plr/
> 
> - John
> 
> ***********************************************
> John Callahan, Research Scientist
> Delaware Geological Survey, University of Delaware
> URL: http://www.dgs.udel.edu
> *************************************************
> 
> 
> 
> On Tue, Mar 27, 2012 at 11:20 PM, Blair Deaver <blairdeaver at gmail.com>wrote:
> 
>> Hello,
>> 
>> I am trying to find out if PostGIS Raster supports the Inverse Distance
>> Weighted interpolation method via some function.  I am specifically trying
>> to generate a heat map from a geometry table with point locations.  Can
>> some one point me in the right direction?  Thanks.
>> 
>> Cheers,
>> Blair
>>