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

[Salvatore Larosa]

Yes!

CREATE TABLE public.katrina
(
  rid integer NOT NULL DEFAULT nextval('katrina_rid_seq'::regclass),
  rast raster,
  filename text,
  .......
)

>----Messaggio originale----
>Da: Pierre.Racine at sbf.ulaval.ca
>Data: 07/03/2012 20.01
>A: "Salvatore Larosa"<S_Larosa at libero.it>, "PostGIS Development Discussion"
<postgis-devel at postgis.refractions.net>
>Ogg: RE: [postgis-devel] R: Re:  raster2pgsql error?
>
>So QGIS reads PostGIS raster through the GDAL driver?
>
>Does your raster table have a "rid" column?
>
>> -----Original Message-----
>> From: postgis-devel-bounces at postgis.refractions.net [mailto:postgis-devel-
>> bounces at postgis.refractions.net] On Behalf Of Salvatore Larosa
>> Sent: Wednesday, March 07, 2012 2:00 PM
>> To: postgis-devel at postgis.refractions.net
>> Subject: Re: [postgis-devel] R: Re: raster2pgsql error?
>> 
>> 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
>