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

orkun
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]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users