<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">I have a table of tessellated hexagons that I created as a hex binning grid to cover an area.</p><p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">I've then overlaid a point set to give some of the hexagons a value. The shapes with value "0" have no value and I'd like to interpolate these from the values of the neighbours (ie. as per Kriging or other algorithm). How can I accomplish this in postgis given my table looks like:-</p><pre style="margin-top: 0px; margin-bottom: 10px; padding: 5px; border: 0px; font-size: 12px; vertical-align: baseline; overflow: auto; width: auto; max-height: 600px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; word-wrap: normal; color: rgb(51, 51, 51); line-height: 18px; background-color: rgb(238, 238, 238);"><code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; color: rgb(34, 34, 34); white-space: inherit;">hex_grid_data
(
gid SERIAL,
wkb_geometry (geometry),
value INTEGER
)</code></pre></div><br><div id="bloop_sign_1406895935381198848" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><br></div></div></body></html>