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

[dustymugs]

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
>