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

[Salvatore Larosa]

@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
>