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

[dustymugs]

You're probably not going to get far as GDAL (all versions including 1.9 
and trunk) aren't up to date with PostGIS trunk.

-bborie

On 03/07/2012 10:59 AM, Salvatore Larosa wrote:
> 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
>>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>