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

Salvatore Larosa S_Larosa at libero.it
Wed Mar 7 11:09:30 PST 2012


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
>





More information about the postgis-devel mailing list