[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] problem in two rasters query
From:       Ahmet Temiz <ahmettemiz88 () gmail ! com>
Date:       2015-06-17 17:48:15
Message-ID: CAJKO1YvrLFApOjtNYrxj2=VqmtE_-x0m2LH04S=V4agZe9+txQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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

[Attachment #5 (text/html)]

<div class="gmail_default" style="color:rgb(34,34,34);line-height:22px">I tried to \
build two rasters query. But it gave this error</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px"><br></div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">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.</div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px"><br></div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px">How can I solve \
the problem?</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">----------</div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px"><br></div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px">Create View \
vslp888 as  <br></div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">WITH slp_30 AS (</div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px">SELECT \
ST_MapAlgebra( dem.rast, slp.rast,        </div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">                                   \
&#39;CASE WHEN ([rast1] &gt; 20   and [rast2] &gt; 30) THEN 1  </div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px">                   \
ELSE NULL</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">                                         \
END&#39;,&#39;32BF&#39;, &#39;INTERSECTION&#39;)   as rast</div><div \
class="gmail_default" style="color:rgb(34,34,34);line-height:22px">FROM o_12_slp_22 \
as slp , o_8_trdem2 as dem</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">WHERE slp.rid = 20 and   \
ST_Intersects(dem.rast ,slp.rast )</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">)</div><div class="gmail_default" \
style="color:rgb(34,34,34);line-height:22px">select rast from slp_30</div><br><br>-- \
<br><div dir="ltr"><div><div dir="ltr"><div>Ahmet Temiz<br>Jeoloji Müh.<br>Afet ve \
Acil Durum Yönetimi Başkanlığı<br>Bilgi İşlem   Dairesi Başkanlığı-CBS \
Grubu<br><br><br>________________________<br><br>Ahmet Temiz<br>Geological \
Eng.<br>Information Systems - GIS Group<br>Disaster and Emergency Management<br>of \
Presidency</div></div></div></div><br>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]