[Qgis-user] Raster postGIS problema visualizar en QGIS
Mike Treglia
mtreglia at gmail.com
Thu Nov 13 05:54:54 PST 2014
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 <juanmimullor at 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 <juanmimullor at 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 <juanmimullor at 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 <mtreglia at 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 <juanmimullor at 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.neto at 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" <juanmimullor at 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 at lists.osgeo.org
>>>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Qgis-user mailing list
>>>>> Qgis-user at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141113/1aaa9db7/attachment.html>
More information about the Qgis-user
mailing list