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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to