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

[Pierre Racine]

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