<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>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. </div><div><br></div><div>thanks,</div><div>jason</div><div><br></div><div>query>>></div><div><br></div><div><div><span class="Apple-tab-span" style="white-space:pre"> </span>SELECT</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>report_id, incident_id, </div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>ST_SummaryStats(</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>ST_UNION(</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>ST_Clip(c.rast, 1, </div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>ST_Transform(w.geom, 5070), true)</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>),</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>1</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>) as hdesc</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>FROM rasters c</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>JOIN w_reports w </div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>ON ST_Intersects(c.rast, ST_Transform(w.geom, 5070)) </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>where w.incident_id = 5443 </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>group by incident_id, report_id</div></div><div><br></div><div>error>>></div><div><br></div><div><p style="margin: 0px; font-size: 12px; font-family: Monaco;"><span class="Apple-tab-span" style="white-space:pre"> </span>ERROR: rt_raster_from_two_rasters: The two rasters provided do not have the same alignment</p>
<p style="margin: 0px; font-size: 12px; font-family: Monaco; min-height: 16px;"><br></p>
<p style="margin: 0px; font-size: 12px; font-family: Monaco;"><span class="Apple-tab-span" style="white-space:pre"> </span>********** Error **********</p>
<p style="margin: 0px; font-size: 12px; font-family: Monaco; min-height: 16px;"><br></p>
<p style="margin: 0px; font-size: 12px; font-family: Monaco;"><span class="Apple-tab-span" style="white-space:pre"> </span>ERROR: rt_raster_from_two_rasters: The two rasters provided do not have the same alignment</p>
<p style="margin: 0px; font-size: 12px; font-family: Monaco;"><span class="Apple-tab-span" style="white-space:pre"> </span>SQL state: XX000</p></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></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>