Hi Mike, I agree, I think that it is a problem related to the file size because QGIS does not report any failure, just takes too. I am going to try with another smaller file.
Thank you. Juanmi. 2014-11-13 14:54 GMT+01:00 Mike Treglia <mtreg...@gmail.com>: > 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. > > Hope that helps... I don't have a ton of experience with postgis, so I'm > not sure what else could be going on. > > > > On Nov 13, 2014, at 7:45 AM, Juan Miguel Requena <juanmimul...@gmail.com> > wrote: > > Hello, some information more, I can visualize shapes from the same data > base. > > Thank you. > > Juanmi > > 2014-11-13 14:42 GMT+01:00 Juan Miguel Requena <juanmimul...@gmail.com>: > >> 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. >> >> Any idea?? thank in advance. >> >> Juanmi. >> >> 2014-11-13 10:46 GMT+01:00 Juan Miguel Requena <juanmimul...@gmail.com>: >> >>> 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. >>> >>> Best regards. >>> >>> Juanmi. >>> >>> 2014-11-13 4:35 GMT+01:00 Michael Treglia <mtreg...@gmail.com>: >>> >>>> Hi Juan, >>>> >>>> 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). >>>> >>>> Is that what you're using to open the PostGIS Raster? Or were you >>>> trying to just use the normal "Add PostGIS layer" method? >>>> >>>> If that's not it, try to give more details of the steps youre taking to >>>> access the PostGIS layer in QGIS. >>>> >>>> Hope that helps, >>>> Mike >>>> >>>> On Wed, Nov 12, 2014 at 3:45 PM, Juan Miguel Requena < >>>> juanmimul...@gmail.com> wrote: >>>> >>>>> Hello Alexandre, sorry. >>>>> >>>>> 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. >>>>> >>>>> Thank you in advance for your help >>>>> >>>>> Juanmi >>>>> >>>>> El 12 de noviembre de 2014, 20:51, Alexandre Neto < >>>>> senhor.n...@gmail.com> escribió: >>>>> >>>>> Hello Juan, can I ask you to write your question in English? >>>>>> >>>>>> Thanks, >>>>>> >>>>>> Alexandre Neto >>>>>> Em 12/11/2014 16:25, "Juan Miguel Requena" <juanmimul...@gmail.com> >>>>>> escreveu: >>>>>> >>>>>>> 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'. >>>>>>> >>>>>>> Alguien puede echarme un mano, muchas gracias por adelantado. >>>>>>> >>>>>>> Juanmi. >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Qgis-user mailing list >>>>>>> Qgis-user@lists.osgeo.org >>>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Qgis-user mailing list >>>>> Qgis-user@lists.osgeo.org >>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>>>> >>>> >>>> >>> >> >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user