<div dir="ltr"><div><div><div><div>Hey,<br></div>I would recommand gdalinfo.<br></div>You may need a recent gdal to properly display raster in QGIS (with a recent QGIS version also)<br><br></div>Cheers,<br><br></div>Rémi-C<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-31 16:05 GMT+02:00 Hugues François <span dir="ltr"><<a href="mailto:hugues.francois@irstea.fr" target="_blank">hugues.francois@irstea.fr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="FR"><div><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">Hello,<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">To display raster data, you can try ST_DumpAsPolygons into Arcgis or OpenJump (if it is just a test, you could add a where clause on tile id).<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">WITH a AS (select ST_DumpAsPolygons(rast) AS mydump from deforested_areas –where rid = 1)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">SELECT (mydump).val, (mydump).geom FROM a<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">This website is a bit outdated, but you can find some useful insights : <a href="http://trac.osgeo.org/postgis/wiki/WKTRaster" target="_blank">http://trac.osgeo.org/postgis/wiki/WKTRaster</a><u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB">Hug<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-GB"><u></u> <u></u></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""> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>De la part de</b> Roberto Lazarte Kaqui<br><b>Envoyé :</b> mardi 31 mars 2015 15:11<br><b>À :</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Objet :</b> [postgis-users] Problem to visualize raster data from PostGIS inQGIS<u></u><u></u></span></p></div></div><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">I have two multiband raster files and i'm trying to load these data into PostGIS using<span> “</span></span><span style="font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">raster2pgsql”</span><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">. <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">Here is the syntax that i used:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">raster2pgsql -c -s 4326 -I -t 100x100 *.tif  public.deforested_rasters | psql -d r342471958<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u> <u></u></span></p><p style="margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">It works without error, but i don't know if the command loads correctly both raster files. The database in PostGIS has two columns, one with the spatial index and the other one with raster information. I'm trying to visualize the resultant database in QGIS, but for some reason it doesn't open the raster layer.<u></u><u></u></span></p><p style="margin:0cm;margin-bottom:.0001pt;line-height:13.5pt;vertical-align:baseline;background-color:rgba(248,248,248,0.6);word-spacing:0px"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">I've tried to solve this problem using this idea:<span> </span></span><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="PT-BR"><a href="https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/" target="_blank"><span style="color:#358daa;border:none windowtext 1.0pt;padding:0cm" lang="EN-US">https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/</span></a></span><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">, transforming the raster data to geometry data through DB manager using this command:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">select rid,rast::geometry from deforested_rasters<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u> <u></u></span></p><p style="margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">but when visualized in QGIS, only returns a rectangular area without the original characteristics.<u></u><u></u></span></p><p style="margin:0cm;margin-bottom:.0001pt;line-height:13.5pt;vertical-align:baseline;background-color:rgba(248,248,248,0.6);word-spacing:0px"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">Any ideas of how can i confirm that the<span> “</span>raster2pgsql” command loads correctly the raster files? Or a different way to load these data into PostGIS?<u></u><u></u></span></p><p style="margin:0cm;margin-bottom:.0001pt;line-height:13.5pt;vertical-align:baseline;background-color:rgba(248,248,248,0.6);word-spacing:0px"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">The raster files are available in:</span><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="PT-BR"><a href="https://www.dropbox.com/sh/nu8nl6cigv8viz1/AADTrr_w8SCstDHOu6AiGeJta?dl=0" target="_blank"><span style="color:#358daa;border:none windowtext 1.0pt;padding:0cm" lang="EN-US">https://www.dropbox.com/sh/nu8nl6cigv8viz1/AADTrr_w8SCstDHOu6AiGeJta?dl=0</span></a></span><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333" lang="EN-US">Roberto<u></u><u></u></span></p><p class="MsoNormal"><span lang="PT-BR"><u></u> <u></u></span></p></div></div></div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>