[postgis-users] ST_Raster question, Use spot heights and create an Elevation raster layer

[Simon Greener]

I have successfully created a PostGIS raster (I am using PostgreSQL 9.1 32bit on Windows 7 64bit with raster 2.0 extension)
and updated those pixels that have specific spot heights. The raster is a single band 32BF raster.

What I wish to now do is to use those spot heights to create an elevation raster layer via which all NoDataValued pixels
have an elevation set that is interpreted from the spot heights around it.

Has anyone any suggestions as to how this can be done by PostGIS's ST_Raster? (ST_MapAlgebra perhaps etc?)

regards
Simon
-- 
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
   Email: simon at spatialdbadvisor.com
   Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3