[postgis-users] Create new table from result of MapAlgebra

[JamesH]

"Don't use a.*, b.*. Instead, explicitly specify the columns you want."

Thanks,
I used:
CREATE TABLE DensDist AS(
SELECT
	ST_MapAlgebraExpr((ST_MapAlgebraExpr(a.rast,1, '32BF',
'[rast]/67.6499557495117')), 1, 
        (ST_MapAlgebraExpr(b.rast,1, '32BF', '[rast]/14052.134765265')), 1,
'([rast1] * 0.5) + ([rast2] * 0.3)', '32BF') as rast, 1 as rid
FROM density a, euclidean b
	);
And it produced the result I hoped for.

Kind Regards,
James

-----
GIS Undergraduate
--
View this message in context: http://postgis.17.n6.nabble.com/Create-new-table-from-result-of-MapAlgebra-tp4930430p4930528.html
Sent from the PostGIS - User mailing list archive at Nabble.com.