problem in two rasters query

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

problem in two rasters query

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

postgis-users mailing list
[hidden email]