[postgis-users] ST_Slope

JamesH james.holmes at newcastle.ac.uk
Mon Apr 2 05:28:04 PDT 2012


Doing steps above, ST_Slope now exists and runs. 

'SELECT 
	rid, rast, ST_Slope(ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10,
0, 0, 0.1, 0.1, 0, 0, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) *
10 + [rast.y]'), 1, '8BUI'::text) 
 FROM
	nclheights'
Now returns successful:
http://postgis.17.n6.nabble.com/file/n4678758/ST_Slope.jpg 

However when trying to export this into a new table to view in QGIS, the
table does not have any raster geometry to it? Where am I going wrong?

Export query is:
CREATE TABLE slope AS(
SELECT 
	rid, rast, ST_Slope(ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10,
0, 0, 0.1, 0.1, 0, 0, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) *
10 + [rast.y]'), 1, '8BUI'::text) 
 FROM
	nclheights
	);

Regards,
James

--
View this message in context: http://postgis.17.n6.nabble.com/ST-Slope-tp4551303p4678758.html
Sent from the PostGIS - User mailing list archive at Nabble.com.



More information about the postgis-users mailing list