<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18203" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=940451704-03032009><FONT face=Arial
color=#0000ff size=2>Greg,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940451704-03032009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940451704-03032009><FONT face=Arial
color=#0000ff size=2>What data format is your lat/long grid
in?</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Greg
King<BR><B>Sent:</B> Monday, March 02, 2009 5:06 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Postgis
Spatial Interpolation<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>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?<BR><BR>Thanks,<BR><FONT color=#888888><BR>G<BR></FONT><BR>PS In
my googling I also saw references to PGRaster, but it looks like that's still
under consideration for development in postgis? </BODY></HTML>