<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Hey,</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">I want to see if anyone has more suggestions for this issue. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Please let me know, Thanks!</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">-jason</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div> <div id="bloop_sign_1401911967240310016" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><br></div></div> <br><p style="color:#000;">On May 30, 2014 at 10:12:34 AM, Jason Mathis (<a href="mailto:jmathis@redzonesoftware.com">jmathis@redzonesoftware.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div></div><div>
<title></title>
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">
Well I appreciate your response I don’t think this is what I am
clocking for. Correct me if I am wrong. </div>
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">
<br></div>
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">
I am reprojecting the vectors (4326) to match the raster (5070). So
I am still confused why i sometimes get the error and other times I
do not. </div>
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">
<br></div>
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">
Thanks! </div>
<div id="bloop_sign_1401466177135906816" class="bloop_sign">
<div style="font-family:helvetica,arial;font-size:13px">
<br></div>
</div>
<br>
<p style="color:#000;">On May 30, 2014 at 2:12:35 AM, Hugues
François (<a href="mailto:hugues.francois@irstea.fr">hugues.francois@irstea.fr</a>)
wrote:</p>
<blockquote type="cite" class="clean_bq">
<div lang="FR" link="blue" vlink="purple" xml:lang="FR">
<div><span><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></span>
<div class="WordSection1">
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">
Hi,</span></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D" xml:lang="EN-GB">When you reproject rasters, pixels from different
tiles may not have the same alignment and union is not possible.
Since version 2.1 you may give a reference raster to get the right
alignment (see variant 3 here <a href="http://postgis.net/docs/RT_ST_Transform.html">http://postgis.net/docs/RT_ST_Transform.html</a>)</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D" xml:lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D" xml:lang="EN-GB">Hugues.</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D" xml:lang="EN-GB"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
De :</span></b> <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <b>De la part de</b>
Jason Mathis<br>
<b>Envoyé :</b> jeudi 29 mai 2014 20:45<br>
<b>À :</b> postgis-users@lists.osgeo.org<br>
<b>Objet :</b> [postgis-users] ERROR:
rt_raster_from_two_rasters:</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
I loaded a bunch raster data into separate tables. One for each us
western state. I thought it maybe handy to query a view instead of
the individual tables. Anyways everything seemed ok but I started
to get errors on a few ids I was testing. I knew what table it
should be pulling from so I queried the table and no issues. So i
must assume the error is because of the “union all” in the view.
Can anyone confirm this and why? I am on postgres 9.2.8 and postgis
2.1.2. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
thanks,</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
jason</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
query>>></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span class="apple-tab-span"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></span>
<span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
SELECT</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> report_id,
incident_id, </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span>
ST_SummaryStats(</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> ST_UNION(</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span>
ST_Clip(c.rast, 1, </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span>
ST_Transform(w.geom, 5070), true)</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> ),</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> 1</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> ) as
hdesc</span></p>
</div>
<div>
<p class="MsoNormal"><span class="apple-tab-span"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></span>
<span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
FROM rasters c</span></p>
</div>
<div>
<p class="MsoNormal"><span class="apple-tab-span"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></span>
<span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
JOIN w_reports w </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
<span class="apple-tab-span"> </span> ON ST_Intersects(c.rast,
ST_Transform(w.geom, 5070)) </span></p>
</div>
<div>
<p class="MsoNormal"><span class="apple-tab-span"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></span>
<span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
where w.incident_id = 5443 </span></p>
</div>
<div>
<p class="MsoNormal"><span class="apple-tab-span"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></span>
<span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
group by incident_id, report_id</span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
error>>></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p style="margin:0cm;margin-bottom:.0001pt"><span class="apple-tab-span"><span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></span>
<span style="font-size:9.0pt;font-family:"Monaco","serif"">ERROR:
rt_raster_from_two_rasters: The two rasters provided do not have
the same alignment</span></p>
<p style="margin:0cm;margin-bottom:.0001pt;min-height: 16px">
<span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span class="apple-tab-span"><span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></span>
<span style="font-size:9.0pt;font-family:"Monaco","serif"">**********
Error **********</span></p>
<p style="margin:0cm;margin-bottom:.0001pt;min-height: 16px">
<span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span class="apple-tab-span"><span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></span>
<span style="font-size:9.0pt;font-family:"Monaco","serif"">ERROR:
rt_raster_from_two_rasters: The two rasters provided do not have
the same alignment</span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span class="apple-tab-span"><span style="font-size:9.0pt;font-family:"Monaco","serif""> </span></span>
<span style="font-size:9.0pt;font-family:"Monaco","serif"">SQL
state: XX000</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif"">
</span></p>
</div>
<p class="MsoNormal"> </p>
<p><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">
This transmission contains confidential and privileged information
intended solely for the party identified above. If you receive this
message in error, you must not use it or convey it to others.
Please destroy it immediately and contact the sender at (303)
386-3955 or by return e-mail to the sender.</span></p>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div>
</div>
</blockquote>
</div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">This transmission contains confidential and privileged
information intended solely for the party identified above. If you receive this message in error, you must not use
it or convey it to others. Please destroy it immediately and contact the sender at
(303) 386-3955 or by return e-mail to the sender.</font></p>