I have a table with two raster columns, which I'm trying to combine into a
third column using the two raster MapAlgebra. The columns represent fire events
at different resolutions, which fortuitously are a simple factor of two
different. These are all 8BUI rasters interpreted as Boolean masks
Ahh, forgive stupid question:
ST_Rescale flipped the sign of my y pixel size. Changing to
ST_Rescale(rast_750, 375,-375) makes everything ducky.
Bryce
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Nordgren, Bryce L -FS
Sent: Thursday, March 10, 2016 12:00 PM
What kind of network separates client and server? Conservatively assuming that
each point is only two 64-bit binary floats, your 56 points equals 9MB of
additional payload.
If you did something like “ST_AsText(geom)”, the additional payload is much,
MUCH larger.
I’d also be interested to k
Paul's suggestion of using the ST_Affine function is likely going to work, but
the biggest problem is likely to be the definition of transformation chains
which go from your building's origin to the floor's origin to the room's origin
to coordinates on particular objects. PostGIS doesn't underst
Hi Carl,
I may be reading too much into your message, but my spidey sense tells me you
might be using ST_Value inside a loop to get values to put in an equation (or
to evaluate thresholds), thereby constructing an output raster. If this is the
case, a more efficient way to proceed may be to use
