[postgis-devel] R: Re: raster2pgsql error?

[Salvatore Larosa]

I am not using the plugin in qgis.
I invoke commands using python console!
Try checking the GDAL libraries if they work properly!

thanks

>----Messaggio originale----
>Da: dustymugs at gmail.com
>Data: 07/03/2012 19.53
>A: <postgis-devel at postgis.refractions.net>
>Ogg: Re: [postgis-devel] R: Re:  raster2pgsql error?
>
>Sounds like there is a problem in QGIS.  I wouldn't be surprised if this 
>has something to do with either GDAL and/or the QGIS PostGIS Raster plugin.
>
>I don't know what I can say to help you as the QGIS plugin isn't 
>developed by the PostGIS devs.  Maybe ask on the QGIS-users list?
>
>I've had to tinker with the QGIS plugin in the past to make things work 
>but I gave up at some point due to lack of time.
>
>-bborie
>
>On 03/07/2012 10:46 AM, Salvatore Larosa wrote:
>> @Pierre:
>> Hi,
>> I can see my layer "katrina" in toc(legend), but not in map canvas!
>>
>> @dustymugs:
>>
>> I get this:
>>
>> workshop=# SELECT ST_SummaryStats(rast) FROM public.katrina;
>>                       st_summarystats
>> ----------------------------------------------------------
>>   (16384,1916773,116.990539550781,13.4360453737346,70,212)
>>   (16384,1914536,116.85400390625,23.6285272165208,36,242)
>>   (16384,3100277,189.225891113281,36.6181475706478,56,242)
>>   (16384,3778685,230.632629394531,7.4514288079297,186,247)
>>   (16384,3651724,222.883544921875,27.2873881219779,39,254)
>>   (16384,3309946,202.023071289062,25.8896340135631,65,253)
>>   (16384,2883054,175.967651367188,30.2396745751291,29,242)
>>   (16384,2697786,164.659790039062,30.9344790879092,26,233)
>> ....................
>>
>>> ----Messaggio originale----
>>> Da: Pierre.Racine at sbf.ulaval.ca
>>> Data: 07/03/2012 19.41
>>> A: "PostGIS Development Discussion"<postgis-devel at postgis.refractions.net>
>>> Ogg: Re: [postgis-devel] raster2pgsql error?
>>>
>>> What do you mean by empty? Does QGIS show an empty square or just nothing?
>>>
>>>> -----Original Message-----
>>>> From: postgis-devel-bounces at postgis.refractions.net [mailto:postgis-
devel-
>>>> bounces at postgis.refractions.net] On Behalf Of dustymugs
>>>> Sent: Wednesday, March 07, 2012 1:20 PM
>>>> To: postgis-devel at postgis.refractions.net
>>>> Subject: Re: [postgis-devel] raster2pgsql error?
>>>>
>>>> On 03/07/2012 10:12 AM, Salvatore Larosa-1 wrote:
>>>>> Hi,
>>>>> I'm trying to import a tif raster [1] into PostGIS but I have a problem!
>>>>>
>>>>> raster2pgsql command seems to run correctly, but when I try to display
>>>>> the raster in qgis my map is empty!
>>>>>
>>>>> below what i do:
>>>>>
>>>>> 1] postgres at debian:~$ raster2pgsql -s 4236 -I -C -M
>>>>> /home/sam/pgraster_test/katrina.tif -F -t 64x64 public.katrina>
>>>>> /home/sam/pgraster_test/katrina.sql
>>>>>
>>>>> 2] postgres at debian:~$ psql -f /home/sam/pgraster_test/katrina.sql -d
>>>>> workshop
>>>>>
>>>>> in QGIS:
>>>>>
>>>>>>>> from qgis.utils import iface
>>>>>>>> connection = "PG:host='localhost' port='5432' dbname='workshop'
>>>>>>>> user='postgres' password='*******' schema='public' table='katrina'
>>>>>>>> mode='2'"
>>>>>>>> iface.addRasterLayer(connection, "katrina")
>>>>>
>>>>> Any hint?
>>>>>
>>>>>
>>>>
>>>> First, check to see if there is data in any of the three bands of that
>> raster.
>>>> Something like
>>>>
>>>> SELECT ST_SummaryStats(rast) FROM public.katrina
>>>>
>>>> If there are counts, there is data.
>>>>
>>>> My guess is that QGIS isn't rendering correctly.  I can't say much about
>> the
>>>> PostGIS Raster plugin as it has been a while since I tried using it and 
at
>> last
>>>> check, it was out-of-date with regards to PostGIS trunk (to become 2.0).
>>>>
>>>> -bborie
>>>> _______________________________________________
>>>> postgis-devel mailing list
>>>> postgis-devel at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>> _______________________________________________
>>> postgis-devel mailing list
>>> postgis-devel at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>>
>>
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>