[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