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

[dustymugs]

Try any of the other modes besides 2?

-bborie

On 03/07/2012 11:04 AM, Pierre Racine wrote:
> Well, I make it works here just by making sure a "rid" column exist. Should there be more problems?
>
>> -----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 2:02 PM
>> To: postgis-devel at postgis.refractions.net
>> Subject: Re: [postgis-devel] R: Re: raster2pgsql error?
>>
>> 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
>>>
>> _______________________________________________
>> 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
>