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

[Pierre Racine]

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