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

[Salvatore Larosa]

1.9.0

>----Messaggio originale----
>Da: dustymugs at gmail.com
>Data: 07/03/2012 20.15
>A: <postgis-devel at postgis.refractions.net>
>Ogg: Re: [postgis-devel] R: Re:  raster2pgsql error?
>
>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
>>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>