[postgis-users] Hex grid value interpolation
remi.cura at gmail.com
Fri Aug 1 06:19:01 PDT 2014
The answer may depend on the coverage of points you have.
1.) full postgis
If you have a lot of points (meaning few hex without data), you can simply
try to give the 0 hex a value following a function of the value of the
For instance, take the N nearest neighbour (called NN) that have a value!=0
along with there distance to the 0 hex, then update the 0 hex with average
value of NN weighted with the distance.
If you have very few point it should be easier to use PL/R to perform
krigging on your point, thus giving you
_ a 2D grid with value for each cell. Then you transfer the value from grid
to hex by simple intersection.
_a mathematical function that for a given X,Y return a value. You just have
to evaluate it for every hex.
(the krigging output depends on what you uses in R)
3.)Postgis+Grass (which must be binded to R)
grass gives access to kriging methods. This allow you to avoid installing
2014-08-01 14:26 GMT+02:00 Dave Barter <dave.barter at gmail.com>:
> I have a table of tessellated hexagons that I created as a hex binning
> grid to cover an area.
> 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:-
> gid SERIAL,
> wkb_geometry (geometry),
> value INTEGER
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users