[postgis-users] raster question

2016-03-10 Thread Stephen Crawford
Hell all, I have a table of rasters, daily weather data, each record is one full raster and an date column, all the same extent. One of my use cases is to drill down to get the all the data for a month or year one grid cell. Performance is slow. Should I make tiles of these daily rasters?

Re: [postgis-users] Call for Case Studies and knowledge about who uses PostGIS and how

2016-03-10 Thread Andy Colson
On 3/9/2016 11:49 AM, Nicklas Avén wrote: Hi all At PostGIS web site http://www.postgis.net, there is a case study list of PostGIS usage. The list is very short and not touched for some years. Here is a first draft, spelling/fixes/suggestions welcome: Vanguard Appraisals is new to the GIS w

[postgis-users] 2 raster map algebra returning all zeros

2016-03-10 Thread Nordgren, Bryce L -FS
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

Re: [postgis-users] 2 raster map algebra returning all zeros

2016-03-10 Thread Nordgren, Bryce L -FS
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 T