<html><head></head><body><div class="ydpcc3f69aayahoo-style-wrap" style="font-family:times new roman, new york, times, serif;font-size:16px;"><div></div>
<div><span style="color: rgb(38, 40, 42);">Hi, </span><br></div></div><div id="ydp5207b0d7yahoo_quoted_2063948840" class="ydp5207b0d7yahoo_quoted"><div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;"><div><div id="ydp5207b0d7yiv1020533276"><div class="ydp5207b0d7yiv1020533276yahoo-style-wrap" style="font-family:times new roman, new york, times, serif;font-size:16px;"><div dir="ltr"><br></div><div dir="ltr">I am having an issue, when rasterizing a union of rasters. Each of the geometries from my initial table are quads or polygons, and the following SQL command </div><div dir="ltr" data-setdir="false">(that should work according the documentation right?) gives me a raster 2x2 .</div><div dir="ltr"><br></div><div dir="ltr" data-setdir="false"><div><div>CREATE TABLE raster_test AS</div><div>(WITH</div><div dir="ltr" data-setdir="false"><span style="white-space: pre-wrap;"> </span>rast AS (SELECT ST_ASRaster(ST_SetSRID(ST_EXTENT( <span><span style="color: rgb(38, 40, 42); font-family: times new roman, new york, times, serif; font-size: 16px;">myQuads</span></span>), 4326), 0.1, 0.1 ,'8BUI')</div><div><span style="white-space: pre-wrap;"> </span> <span style="white-space: pre-wrap;"> </span>FROM myDB, </div><div><span style="white-space: pre-wrap;"> </span> <span style="white-space: pre-wrap;"> </span>WHERE ST_IsValid(myQuads)),</div><div dir="ltr" data-setdir="false"> <span style="white-space: pre-wrap;"> </span>raster_ AS (SELECT ST_Union(ST_ASRaster(ST_SetSRID(ST_Force2D( <span><span style="color: rgb(38, 40, 42); font-family: times new roman, new york, times, serif; font-size: 16px;">myQuads</span></span>), 4326), rast.ST_ASRaster), 'SUM')</div><div dir="ltr" data-setdir="false"><span style="white-space: pre-wrap;"> </span> <span style="white-space: pre-wrap;"> </span>FROM <span><span style="color: rgb(38, 40, 42); font-family: times new roman, new york, times, serif; font-size: 16px;">myDB</span></span>, rast</div><div dir="ltr" data-setdir="false"><span style="white-space: pre-wrap;"> </span> <span style="white-space: pre-wrap;"> </span>WHERE <span><span style="color: rgb(38, 40, 42); font-family: times new roman, new york, times, serif; font-size: 16px;">myQuads</span></span> IS NOT NULL)</div><div> SELECT raster_.ST_Union as rast_chunks</div><div> <span style="white-space: pre-wrap;"> </span>FROM raster_, rast );</div></div><br></div><div dir="ltr" data-setdir="false">The command produces the desired raster if I replace my resolution (0.1, 0.1) by the raster size if it's equal to 150. Over that (200 say) I get an alignment error message.</div><div dir="ltr" data-setdir="false">I tried to cast 0.1 to double precision I still get an issue. <br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I am wondering if I am doing something wrong here or if there's a known issue. </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thanks, </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Lio</div></div></div></div>
</div>
</div></body></html>