[postgis-users] problem in two rasters query

Ahmet Temiz ahmettemiz88 at gmail.com
Wed Jun 17 10:48:15 PDT 2015


I tried to build two rasters query. But it gave this error

ERROR 1: Error browsing database for PostGIS Raster properties : ERROR:
 rt_raster_iterator: The set of rasters provided (custom extent included,
if appropriate) do not have the same alignment.

How can I solve the problem?
----------

Create View vslp888 as
WITH slp_30 AS (
SELECT ST_MapAlgebra( dem.rast, slp.rast,
                       'CASE WHEN ([rast1] > 20  and [rast2] > 30) THEN 1
                                      ELSE NULL
                                      END','32BF', 'INTERSECTION')  as rast
FROM o_12_slp_22 as slp , o_8_trdem2 as dem
WHERE slp.rid = 20 and  ST_Intersects(dem.rast ,slp.rast )
)
select rast from slp_30


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu


________________________

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150617/26724301/attachment-0001.html>


More information about the postgis-users mailing list