<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Is it a large raster? I don't have experience with remote postgis data, but I know that if I'm dealing with very large postgis rasters locally, it takes some time to render.</div><div><br></div><div>Hope that helps... I don't have a ton of experience with postgis, so I'm not sure what else could be going on.<br><br><br style="font-family: Helvetica; font-size: medium; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); -webkit-text-size-adjust: auto; "></div><div><br>On Nov 13, 2014, at 7:45 AM, Juan Miguel Requena <<a href="mailto:juanmimullor@gmail.com">juanmimullor@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">Hello, some information more, I can visualize shapes from the same data base.<div><br></div><div>Thank you.</div><div><br></div><div>Juanmi</div></div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-13 14:42 GMT+01:00 Juan Miguel Requena <span dir="ltr"><<a href="mailto:juanmimullor@gmail.com" target="_blank">juanmimullor@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello again, now I have a new problem. I connect into the data base from other pc without problems (via DB Manager plugin) but when I want to visualize the raster I can not. However, I can see the info and the table of the file but not the preliminar view.<div><br></div><div>Any idea?? thank in advance.</div><div><br></div><div>Juanmi.</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2014-11-13 10:46 GMT+01:00 Juan Miguel Requena <span dir="ltr"><<a href="mailto:juanmimullor@gmail.com" target="_blank">juanmimullor@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Michael, thank you very much for your reply. My problem has been solved. Indeed, I was trying to import the postGIS raster from the wrong way, i.e., 'Add PostGIS layer', and when I load it from DB Manager plugin there is no problem, it was very easy but it was my first time. Thank you again.<div><br></div><div>Best regards.</div><div><br></div><div>Juanmi.</div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-13 4:35 GMT+01:00 Michael Treglia <span dir="ltr"><<a href="mailto:mtreglia@gmail.com" target="_blank">mtreglia@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Hi Juan,<br><br></div>To display a PostGIS Raster in QGIS, I think you need to use the Database Manager plugin ("DB Manager"). If you have it installed/activated, you would access it from the "Database" tab in the menu bar at top. (I'm on QGIS 2.6 and 2.4, but I'd imagine its the same for 2.0).<br><br></div>Is that what you're using to open the PostGIS Raster? Or were you trying to just use the normal "Add PostGIS layer" method?<br><br></div>If that's not it, try to give more details of the steps youre taking to access the PostGIS layer in QGIS.<br><br></div>Hope that helps,<br>Mike<br></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 12, 2014 at 3:45 PM, Juan Miguel Requena <span dir="ltr"><<a href="mailto:juanmimullor@gmail.com" target="_blank">juanmimullor@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Alexandre, sorry.<div><br></div><div><div>I have used the postGIS command 'raster2pgsql' to import a geotiff file into a postgres data base.The process was successfully finished. Both columns 'rid' and 'rast' were successfully created but when I connect QGIS 2.0 to the data base and load the table, the software is unable to recognize the data type and the geometry type, so that I can not visualize the file and the attribute table has not the rast column.</div><div><br></div><div>Thank you in advance for your help</div></div><div><br></div><div>Juanmi</div></div><div class="gmail_extra"><br><div class="gmail_quote">El 12 de noviembre de 2014, 20:51, Alexandre Neto <span dir="ltr"><<a href="mailto:senhor.neto@gmail.com" target="_blank">senhor.neto@gmail.com</a>></span> escribió:<div><div><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Hello Juan, can I ask you to write your question in English?</p>
<p dir="ltr">Thanks,</p>
<p dir="ltr"> Alexandre Neto</p>
<div class="gmail_quote">Em 12/11/2014 16:25, "Juan Miguel Requena" <<a href="mailto:juanmimullor@gmail.com" target="_blank">juanmimullor@gmail.com</a>> escreveu:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><div dir="ltr">Hola, estoy utilizando el comando raster2pgsql de postGIS para importar un archivo geotif a una base de datos (postgresql). Todo el proceso lo ejecuta correctamente. Crea los campos 'rid' y 'rast' bien. Pero al conectarme a la base de datos con QGIS, la tabla postgres correspondiente viene como 'Tipo de dato' : Nada y 'Tipo espacial' : Ninguna geometría. Cuando añado el archivo y visualizo la tabla de atributos solo existe el campo 'rid' pero no el 'rast'.<div><br></div><div>Alguien puede echarme un mano, muchas gracias por adelantado.</div><div><br></div><div>Juanmi.</div></div>
<br></span>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div>
</blockquote></div></div></div><br></div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></blockquote></body></html>