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

[dustymugs]

I wouldn't be surprised if the GDAL PostGIS Raster driver isn't working 
for you.  Which version of GDAL are you using?

On 03/07/2012 11:09 AM, Salvatore Larosa wrote:
> I tried but nothing, same problem!
>
>> ----Messaggio originale----
>> Da: dustymugs at gmail.com
>> Data: 07/03/2012 20.05
>> A:<postgis-devel at postgis.refractions.net>
>> Ogg: Re: [postgis-devel] R: Re:  raster2pgsql error?
>>
>> 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
>>>
>> _______________________________________________
>> 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
>