<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; ">Hello,</span></div><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; "><br></span></div><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; ">I'm a new postgis-user and i have a postgis raster project for a moment. I installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2, proj-4.6 in ubuntu. But when i use the raster table of dummy rasters formed from the site : <br> <a href="http://postgis.refractions.net/documentation/manual-svn/RT_reference.html" target="_blank" style="color: rgb(35, 71, 134); outline-style:
none; outline-width: initial; outline-color: initial; "><span class="yshortcuts" id="lw_1318159304_4">http://postgis.refractions.net/documentation/manual-svn/RT_reference.html</span></a><br><br></span></div><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; "> CREATE TABLE dummy_rast(rid integer, rast raster);<br> INSERT INTO dummy_rast(rid, rast)<br> VALUES (1,<br> ('01' -- little endian (uint8 ndr)<br> || <br> '0000' -- version (uint16 0)<br> ||<br> '0000' -- nBands (uint16 0)<br> ||<br> '0000000000000040' -- scaleX (float64 2)<br> ||<br> '0000000000000840' -- scaleY (float64 3)<br> ||<br> '000000000000E03F' -- ipX (float64 0.5)<br> ||<br> '000000000000E03F' -- ipY
(float64 0.5)<br> ||<br> '0000000000000000' -- skewX (float64 0)<br> ||<br><br>- Ignored:<br> '0000000000000000' -- skewY (float64 0)<br> ||<br> '00000000' -- SRID (int32 0)<br> ||<br> '0A00' -- width (uint16 10)<br> ||<br> '1400' -- height (uint16 20)<br> )::raster<br> ),<br> -- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0<br> (2, ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' ||<br> '41000000007719564100000000000000000000000000000000FFFFFFFF050005000400FDFEFDFEFEFDFEFEFDF9FAFEF' ||<br> 'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454C5665')::raster);<br> <br> and then i run this command :<br>
<br> SELECT rid, Box2D(rast) As rastbox<br> FROM dummy_rast;<br> <br> i get NOTICE and no result :<br> <br> NOTICE: compute_serialized_box3d called on unknown type 0<br> NOTICE: compute_serialized_box3d called on unknown type 0<br> rid | rastbox <br> -----+---------<br> 1 | <br> 2 | <br> (2 rows)<br> <br> Can you help me to find out what's going wrong here ? <br> <br> Thanks in advance,<br> Dang Uyen.<br><br>- Done.<br><br><div id="yiv604862970"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><div><div style="text-indent: 0px; ">Hello,</div><div style="text-indent: 0px;
"></div><div style="text-indent: 0px; ">I'm a new postgis-user and i have a postgis raster project for a moment. I installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2, proj-4.6 in ubuntu. But when i use the raster table of dummy rasters formed from the site : </div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "><a rel="nofollow" target="_blank" href="http://postgis.refractions.net/documentation/manual-svn/RT_reference.html" style="color: rgb(35, 71, 134); outline-style: none; outline-width: initial; outline-color: initial; ">http://postgis.refractions.net/documentation/manual-svn/RT_reference.html</a><br></div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">CREATE TABLE dummy_rast(rid integer, rast raster);</div><div style="text-indent: 0px; ">INSERT INTO dummy_rast(rid, rast)</div><div style="text-indent: 0px; ">VALUES (1,</div><div
style="text-indent: 0px; ">('01' -- little endian (uint8 ndr)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000' -- version (uint16 0)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000' -- nBands (uint16 0)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000000000000040' -- scaleX (float64 2)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000000000000840' -- scaleY (float64 3)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'000000000000E03F' -- ipX (float64 0.5)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'000000000000E03F' -- ipY (float64 0.5)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000000000000000' -- skewX (float64 0)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0000000000000000' -- skewY
(float64 0)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'00000000' -- SRID (int32 0)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'0A00' -- width (uint16 10)</div><div style="text-indent: 0px; ">||</div><div style="text-indent: 0px; ">'1400' -- height (uint16 20)</div><div style="text-indent: 0px; ">)::raster</div><div style="text-indent: 0px; ">),</div><div style="text-indent: 0px; ">-- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0</div><div style="text-indent: 0px; ">(2, ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' ||</div><div style="text-indent: 0px; ">'41000000007719564100000000000000000000000000000000FFFFFFFF050005000400FDFEFDFEFEFDFEFEFDF9FAFEF' ||</div><div style="text-indent: 0px; ">'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454C5665')::raster);</div><div
style="text-indent: 0px; "></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; ">and then i run this command :</div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">SELECT rid, Box2D(rast) As rastbox</div><div style="text-indent: 0px; ">FROM dummy_rast;</div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">i get NOTICE and no result :</div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">NOTICE: compute_serialized_box3d called on unknown type 0</div><div style="text-indent: 0px; ">NOTICE: compute_serialized_box3d called on unknown type 0</div><div style="text-indent: 0px; ">rid | rastbox</div><div style="text-indent: 0px; ">-----+---------</div><div style="text-indent: 0px; ">1 |</div><div
style="text-indent: 0px; ">2 |</div><div style="text-indent: 0px; ">(2 rows)</div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">Can you help me to find out what's going wrong here ?</div><div style="text-indent: 0px; "><br></div><div style="text-indent: 0px; "></div><div style="text-indent: 0px; ">Thanks in advance,</div><div style="text-indent: 0px; ">Dang Uyen.</div></div></div></div></div></span></div></div></body></html>