[postgis-users] Help with SQL query?

Darrel Maddy darrel.maddy at newcastle.ac.uk
Fri Nov 27 14:28:09 PST 2015


Dear Brent,

Yes that works for me too !

Sometimes I look for what is familiar and overlook the obvious – a little embarrassing, but I know now .

Many thanks

Darrel

From: Brent Wood [mailto:pcreso at yahoo.com]
Sent: 27 November 2015 21:53
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>; Darrel Maddy <darrel.maddy at newcastle.ac.uk>
Subject: Re: [postgis-users] Help with SQL query?


Darrel

You can use the logical operators in the QGIS raster calculator as a binary conditional :

eg: raster a is used to generate a new raster with default 0, but pixel value=1  where pixels in a have a value >300...   use the following operation

(a > 300.0)

Save the result as a grid rather than a image. It works for me....
Brent

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151127/00fb0b1c/attachment.html>


More information about the postgis-users mailing list