[postgis-users] ST_Slope

JamesH james.holmes at newcastle.ac.uk
Mon Apr 2 08:12:14 PDT 2012


Ok I'm trying OpenJump as I need to get going with this for my dissertation.

Now I'm connected to the datastore, I am trying to run the following query:

SELECT ST_AsBinary(rast), slope
FROM (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) slope 
 FROM 
        nclheights 
        ); AS foo

Which is returning an error of "subquery in FROM must have an alias."
Have I used foo incorrectly?

Regards,
James 

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



More information about the postgis-users mailing list