[postgis-users] Postgis Spatial Interpolation

Burgholzer,Robert rwburgholzer at deq.virginia.gov
Wed Mar 4 06:23:16 PST 2009

Depending on where you are located, the NOAA has rainfall at 4km x 4km
grids, and a host of wfs-queryable data at a dynamic grid size (that I
suspect may conform to the 4km x 4km grid as well).

I can dig up the URLs if you are interested.

Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
rwburgholzer at deq.virginia.gov
Open Source Modeling Tools:

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ben
Sent: Tuesday, March 03, 2009 6:32 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Postgis Spatial Interpolation


I'm trying to do something similar (but with commodity prices across a  
number of regions in a number of countries), and only last week  
cottoned on to PL/R, which I think looks like the way to go.

I am thinking I would try (I still am!!) something like kriging to  
create a surface in R, and then I could send the parts back.

So good luck - thanks for asking because there is some great  
references in the responses people have made.



On 04/03/2009, at 5:01 AM, postgis-users- 
request at postgis.refractions.net wrote:

> Date: Mon, 2 Mar 2009 22:06:07 +0000
> From: Greg King <gregspam at kooji.com>
> Subject: [postgis-users] Postgis Spatial Interpolation
> I'm fairly new to postgis and spatial databases but have been very  
> pleased
> with the results I'm getting from postgis to date.  One of my  
> projects is
> using postgis to load weather data from a 0.5 x 0.5 degree lat/long  
> grid.
> I'm looking to  interpolate data values that fall between that grid  
> point I
> have values for.  A bit of googling has revealed a number of  
> applications
> that interface to postgis and can do what I need (eg GRASS), but I  
> don't
> need their full functionality or the overhead of interfacing with  
> them.  My
> project needs simply to return interpolated values to a web page and  
> I would
> rather just have a pl/pgsql procedure that gives me interpolated  
> values for
> a given point.  My initial thoughts are to feed the necessary point  
> data
> from my database into a custom pl/R function and get R to  
> interpolate the
> data for my point.  However, that is going to involve a fair amount of
> custom code and for me to learn more about R.  I don't want to  
> reinvent the
> wheel, so I'd be grateful for any thoughts on solutions that meet my  
> needs?
> Thanks,
> G
> PS In my googling I also saw references to PGRaster, but it looks like
> that's still under consideration for development in postgis?


Ben Madin

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au

							Out here, it
pays to know...

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list