[Qgis-user] Fwd: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint Maya

Thu Aug 30 11:03:21 PDT 2012

Brian - no this is not my job, like many people around here.

Sorry I can't help you for the postgis error - hoefully someone else
can step in.
However, I wonder if using another repository (sharpie) for postgis
could be the cause?
Although I assume you need that to get latest postgis. Ubuntugis ships
with 1.5.3-3~precise1

Sadly, sometime to have cutting-edge software you need to compile the
whole stack (or at least qgis) yourself...
Etienne

On Thu, Aug 30, 2012 at 2:47 PM, Brian Fitzgerald <bkfitz at gmail.com> wrote:
> Etienne,
>
> Thanks again for all your help... I know this isn't your job so I really
> appreciate it.
>
> I removed QGIS, and my qgis.org/debian ppa and changed it to
> /ubuntu-nightly.  Reinstalled, and now QGIS does show gdal 1.9 under help ->
> about.  :) :)
>
> However,  I'm still experiencing the exact same error.  See attached
> screenshots.
>
> - Brian
>
>
>
> On Thu, Aug 30, 2012 at 9:40 AM, Etienne Tourigny <etourigny.dev at gmail.com>
> wrote:
>>
>> Like I said in previous mail, use the
>> http://qgis.org/ubuntugis-nightly and ubuntugis-unstable repos.
>>
>> Etienne
>>
>> On Thu, Aug 30, 2012 at 10:36 AM, Giovanni Manghi
>> <giovanni.manghi at faunalia.pt> wrote:
>> > There are 2 nightly repos, one uses ubuntugis packages, including the
>> > latest
>> > gdal.
>> >
>> > On Aug 30, 2012 1:51 PM, "Mauricio de Paulo" <mauricio.dev at gmail.com>
>> > wrote:
>> >>
>> >> Don't quote me on this, but I have a memory of the nightly ppas not
>> >> being
>> >> linked against the latest gdal released.
>> >>
>> >> Mauricio C. M. de Paulo
>> >> Engenheiro Cartógrafo
>> >> Mestrando em Sensoriamento Remoto (INPE)
>> >>
>> >> On 08/30/2012 09:42 AM, Brian Fitzgerald wrote:
>> >>
>> >> Yeah... I've been using the nightly ppas
>> >>
>> >> ----------------------------
>> >> Brian Fitzgerald
>> >> bkfitz at gmail.com
>> >> 803-426-3469
>> >> Sent from my mobile phone
>> >> ----------------------------
>> >>
>> >> On Aug 30, 2012 8:39 AM, "Etienne Tourigny" <etourigny.dev at gmail.com>
>> >> wrote:
>> >>>
>> >>> Hi,
>> >>>
>> >>> If you want the nightlies ( which I don't recommend for production)
>> >>> you should be using these (and only these)
>> >>>
>> >>> deb     http://qgis.org/ubuntugis-nightly precise main
>> >>> deb-src http://qgis.org/ubuntugis-nightly precise main
>> >>> deb     http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu
>> >>> precise main
>> >>>
>> >>> For a more stable, but still recent, use ubuntugis-unstable (only)
>> >>>
>> >>> < remove other repos, and remove anything related to qgis (including
>> >>> gdal)
>> >>>
>> >>> sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
>> >>> sudo apt-get update
>> >>> sudo apt-get install qgis
>> >>>
>> >>> On Wed, Aug 29, 2012 at 5:25 PM, Brian Fitzgerald <bkfitz at gmail.com>
>> >>> wrote:
>> >>> > Scratch previous email... I just went to QGIS -> about and found
>> >>> > that
>> >>> > QGIS
>> >>> > is "Compiled against GDAL/OGR 1.7.3" even though I installed the 1.9
>> >>> > GDAL
>> >>> > libaries before I install QGIS.  Now what?
>> >>> >
>> >>> >
>> >>> >
>> >>> >
>> >>> >
>> >>> >
>> >>> > On Wed, Aug 29, 2012 at 4:22 PM, Brian Fitzgerald <bkfitz at gmail.com>
>> >>> > wrote:
>> >>> >>
>> >>> >> How do I figure out what version of GDAL my QGIS is using... I
>> >>> >> reinstalled
>> >>> >> everything (QGIS nightlies, gdal from the unstable-gis ppas,
>> >>> >> postgres
>> >>> >> and
>> >>> >> postgis) and am running into the same problem.  I checked in
>> >>> >> Synaptic
>> >>> >> and
>> >>> >> see both 1.7 and 1.9 gdal libraries installed.
>> >>> >>
>> >>> >> Thx for all your help!
>> >>> >>
>> >>> >> - Brian
>> >>> >>
>> >>> >>
>> >>> >>
>> >>> >>
>> >>> >> On Tue, Aug 28, 2012 at 3:29 PM, Mauricio de Paulo
>> >>> >> <mauricio.dev at gmail.com> wrote:
>> >>> >>>
>> >>> >>> Hi, Brian and Etienne.
>> >>> >>> Well, GDAL 1.7.3 was one of the first efforts to read postgis
>> >>> >>> raster,
>> >>> >>> back in the release candidate days. A few months before the
>> >>> >>> release
>> >>> >>> of
>> >>> >>> postgis 2.0 there was a major change in the raster storage and
>> >>> >>> some
>> >>> >>> code was
>> >>> >>> discontinued. GDAL 1.9.0 was the first release after postgis 2.0
>> >>> >>> was
>> >>> >>> released so it's the first version that is compatible.
>> >>> >>>
>> >>> >>> Fortunately, vector data is a mature standard inside postgis and
>> >>> >>> didn't
>> >>> >>> suffer any major changes that could break previous working code.
>> >>> >>>
>> >>> >>> Even though we were all notified by these changes, some of our
>> >>> >>> previous
>> >>> >>> work doesn't work with the current version. It was a huge
>> >>> >>> improvement
>> >>> >>> in
>> >>> >>> raster storage and metadata retrieval, so we have to cope with it.
>> >>> >>>
>> >>> >>> I'm releasing the new plugin version with the weak loader tonight.
>> >>> >>> It
>> >>> >>> should be enough to upload one untiled raster with no overviews to
>> >>> >>> the
>> >>> >>> database.
>> >>> >>>
>> >>> >>> I'm using ubuntugis' repositories. The gdal package available on
>> >>> >>> it
>> >>> >>> is
>> >>> >>> version 1.9.1 so you might want to try those binaries, since they
>> >>> >>> work
>> >>> >>> pretty well.
>> >>> >>>
>> >>> >>> All the best,
>> >>> >>>
>> >>> >>> Mauricio C. M. de Paulo
>> >>> >>> Engenheiro Cartógrafo
>> >>> >>> Mestrando em Sensoriamento Remoto (INPE)
>> >>> >>>
>> >>> >>> On 08/28/2012 04:17 PM, Brian Fitzgerald wrote:
>> >>> >>>
>> >>> >>> I'm showing GDAL version 1.7.3-6 in Synaptic... so that could be
>> >>> >>> my
>> >>> >>> problem... but wouldn't I also be experiencing loading postgis 2.0
>> >>> >>> vectors?
>> >>> >>>
>> >>> >>> - Brian
>> >>> >>>
>> >>> >>> On Tue, Aug 28, 2012 at 3:01 PM, Mauricio de Paulo
>> >>> >>> <mauricio.dev at gmail.com> wrote:
>> >>> >>>>
>> >>> >>>> Hi Brian,
>> >>> >>>> I downloaded the sample data and imported to my database and it
>> >>> >>>> seems to
>> >>> >>>> work pretty well. I'm using QGIS 1.8, postgis 2.0, postgres
>> >>> >>>> 9.1.5,
>> >>> >>>> gdal
>> >>> >>>> 1.9.1 on ubuntu 12.04.
>> >>> >>>>
>> >>> >>>> Sorry for my ignorance but what GDAL version is being released
>> >>> >>>> with
>> >>> >>>> linux mint? I couldn't find anywhere online.
>> >>> >>>>
>> >>> >>>> The plugin heavily relies on GDAL to perform the visualization so
>> >>> >>>> you
>> >>> >>>> need the latest GDAL available to get a decent performance.
>> >>> >>>>
>> >>> >>>> From my first tests I can say that GDAL 1.9.1 has greatly
>> >>> >>>> improved
>> >>> >>>> performance and the next versions should improve even further.
>> >>> >>>> The
>> >>> >>>> fastest
>> >>> >>>> visualization that I have achieved with version 1.9.1 is with
>> >>> >>>> single
>> >>> >>>> tiled
>> >>> >>>> raster files. Unfortunately I wasn't able to get GDAL to use
>> >>> >>>> overviews so
>> >>> >>>> far, but Jorge (GDAL's postgis raster developper) is researching
>> >>> >>>> on
>> >>> >>>> this
>> >>> >>>> subject.
>> >>> >>>>
>> >>> >>>> GDAL versions bellow 1.9 should not be able to read postgis 2.0.
>> >>> >>>>
>> >>> >>>> Unfortunately, since postgis 2.0 release, the python loader was
>> >>> >>>> discontinued in postgis source. Recently I have started to make
>> >>> >>>> the
>> >>> >>>> necessary changes starting from the old code to get it to work. I
>> >>> >>>> don't know
>> >>> >>>> if this is going to be a good solution but it seems possible. I'm
>> >>> >>>> trying to
>> >>> >>>> avoid the platform-dependent compilation that postgis' raster
>> >>> >>>> loader
>> >>> >>>> has in
>> >>> >>>> version 2.0 now that it's being entirely written in C. In the
>> >>> >>>> future
>> >>> >>>> I
>> >>> >>>> should probably release a simple uploader with the plugin,
>> >>> >>>> without
>> >>> >>>> all those
>> >>> >>>> options until I'm certain that everything is working according to
>> >>> >>>> the
>> >>> >>>> standard.
>> >>> >>>>
>> >>> >>>> I'm copying this mail to the list to allow other users to find
>> >>> >>>> this
>> >>> >>>> thread later.
>> >>> >>>>
>> >>> >>>> Mauricio C. M. de Paulo
>> >>> >>>> Engenheiro Cartógrafo
>> >>> >>>> Mestrando em Sensoriamento Remoto (INPE)
>> >>> >>>>
>> >>> >>>> On 08/28/2012 03:56 PM, Brian Fitzgerald wrote:
>> >>> >>>>
>> >>> >>>> PS - Im also unable to "load" raster data into PostGIS using the
>> >>> >>>> plugin... the icon is greyed out for some reason.
>> >>> >>>>
>> >>> >>>> - Brian
>> >>> >>>>
>> >>> >>>>
>> >>> >>>>
>> >>> >>>>
>> >>> >>>> On Tue, Aug 28, 2012 at 2:20 PM, Brian Fitzgerald
>> >>> >>>> <bkfitz at gmail.com>
>> >>> >>>> wrote:
>> >>> >>>>>
>> >>> >>>>> Sure.
>> >>> >>>>>
>> >>> >>>>> I'm running Ubuntu Mint 13 Cinnamon with Postgres 1.9.5, Postgis
>> >>> >>>>> 2.0.
>> >>> >>>>> and QGIS 1.9.0
>> >>> >>>>>
>> >>> >>>>> I followed this install tutorial:
>> >>> >>>>>
>> >>> >>>>> http://linfiniti.com/2012/05/installing-postgis-2-0-on-ubuntu/
>> >>> >>>>>
>> >>> >>>>> I loaded the sample vector shapefile into my new 'training'
>> >>> >>>>> database
>> >>> >>>>> and opened it in QGIS with no problem.
>> >>> >>>>>
>> >>> >>>>> I loaded the sample raster data using the command in the
>> >>> >>>>> tutorial,
>> >>> >>>>> it
>> >>> >>>>> loaded with no problems.  I ran the test query in the tutorial,
>> >>> >>>>> no
>> >>> >>>>> problem.
>> >>> >>>>> I went into QGIS to load the raster and got an error that
>> >>> >>>>> referred
>> >>> >>>>> to some
>> >>> >>>>> missing python dependencies (i think it was the python-psycopg
>> >>> >>>>> libs)... so I
>> >>> >>>>> went to Synaptic and loaded the following:
>> >>> >>>>>
>> >>> >>>>> Installed the following packages:
>> >>> >>>>> libjs-sphinxdoc (1.1.3+dfsg-2ubuntu2.1)
>> >>> >>>>> libjs-underscore (1.1.6-1ubuntu2)
>> >>> >>>>> python-dbg (2.7.3-0ubuntu2)
>> >>> >>>>> python-psycopg2 (2.4.5-1)
>> >>> >>>>> python-psycopg2-dbg (2.4.5-1)
>> >>> >>>>> python-psycopg2-doc (2.4.5-1)
>> >>> >>>>> python2.7-dbg (2.7.3-0ubuntu3.1)
>> >>> >>>>> python3 (3.2.3-0ubuntu1)
>> >>> >>>>> python3-dbg (3.2.3-0ubuntu1)
>> >>> >>>>> python3-minimal (3.2.3-0ubuntu1)
>> >>> >>>>> python3-psycopg2 (2.4.5-1)
>> >>> >>>>> python3-psycopg2-dbg (2.4.5-1)
>> >>> >>>>> python3.2 (3.2.3-0ubuntu3)
>> >>> >>>>> python3.2-dbg (3.2.3-0ubuntu3)
>> >>> >>>>> python3.2-minimal (3.2.3-0ubuntu3)
>> >>> >>>>>
>> >>> >>>>> I then came back to QGIS to open the raster and no longer get
>> >>> >>>>> the
>> >>> >>>>> python error... this time it brings up the "Load PostGIS Raster
>> >>> >>>>> Layer" just
>> >>> >>>>> fine and displays my sample raster.  I click on the raster name
>> >>> >>>>> in
>> >>> >>>>> the table
>> >>> >>>>> and it puts it down in the "Table Name" input box.  I then click
>> >>> >>>>> on
>> >>> >>>>> OK and
>> >>> >>>>> get a window that pops up saying "Could Not Load Layer".  I
>> >>> >>>>> click
>> >>> >>>>> ok to this
>> >>> >>>>> and another window comes up that says:  "Could not load PG:
>> >>> >>>>> dbname=training
>> >>> >>>>> host=localhost user=postgres password=xxxxxx port=5432
>> >>> >>>>> schema=public
>> >>> >>>>> table=srtm_4326 mode=2".  When I click ok to this, the window
>> >>> >>>>> diappears and
>> >>> >>>>> nothing happens.
>> >>> >>>>>
>> >>> >>>>> I also tried one of our ortho geotiffs using the following
>> >>> >>>>> command
>> >>> >>>>> and
>> >>> >>>>> get the same results:
>> >>> >>>>>
>> >>> >>>>> postgres at minty /home/rcgeoadmin/Temp $ raster2pgsql -s 4326
>> >>> >>>>> /home/rcgeoadmin/Temp/979903.tif | psql training
>> >>> >>>>> Processing 1/1: /home/rcgeoadmin/Temp/979903.tif
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919
>> >>> >>>>> (0x847f)
>> >>> >>>>> encountered
>> >>> >>>>> BEGIN
>> >>> >>>>> NOTICE:  CREATE TABLE will create implicit sequence
>> >>> >>>>> "979903_rid_seq"
>> >>> >>>>> for serial column "979903.rid"
>> >>> >>>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> >>> >>>>> "979903_pkey" for table "979903"
>> >>> >>>>> CREATE TABLE
>> >>> >>>>> INSERT 0 1
>> >>> >>>>> COMMIT
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>> - Brian
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>> On Tue, Aug 28, 2012 at 8:24 AM, Mauricio de Paulo
>> >>> >>>>> <mauricio.dev at gmail.com> wrote:
>> >>> >>>>>>
>> >>> >>>>>> Hi, Brian.
>> >>> >>>>>> Could you please elaborate a little more about what were you
>> >>> >>>>>> trying to
>> >>> >>>>>> do and what raster configuration you were using? Is it tiled or
>> >>> >>>>>> untiled? One
>> >>> >>>>>> single raster file in the table? Did you build overviews?
>> >>> >>>>>> All the best,
>> >>> >>>>>>
>> >>> >>>>>> Mauricio C. M. de Paulo
>> >>> >>>>>>
>> >>> >>>>>> On 08/27/2012 07:00 PM, Brian Fitzgerald wrote:
>> >>> >>>>>>
>> >>> >>>>>> ---------- Forwarded message ----------
>> >>> >>>>>> From: "Brian Fitzgerald" <bkfitz at gmail.com>
>> >>> >>>>>> Date: Aug 27, 2012 4:57 PM
>> >>> >>>>>> Subject: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint
>> >>> >>>>>> Maya
>> >>> >>>>>> To: <wonder.sk at gmail.com>
>> >>> >>>>>>
>> >>> >>>>>> I'm having problems loading a Postgis 2.0 raster layer into
>> >>> >>>>>> QGIS
>> >>> >>>>>> 1.9
>> >>> >>>>>> using your wktraster extension.
>> >>> >>>>>>
>> >>> >>>>>> The menu comes up, but I get a "could not load layer"
>> >>> >>>>>>
>> >>> >>>>>> Then a window that says:
>> >>> >>>>>>
>> >>> >>>>>> "Could not load PG: dbname=training host=localhost
>> >>> >>>>>> user=postgres
>> >>> >>>>>> password=topology4 port=5432 table= mode=2"
>> >>> >>>>>>
>> >>> >>>>>> Any ideas?
>> >>> >>>>>>
>> >>> >>>>>> --
>> >>> >>>>>> --------------------------------------
>> >>> >>>>>> Brian Fitzgerald, PMP, GISP
>> >>> >>>>>> bkfitz at gmail.com
>> >>> >>>>>> 803.426.3469
>> >>> >>>>>> ---------------------------------------
>> >>> >>>>>>
>> >>> >>>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>>
>> >>> >>>>> --
>> >>> >>>>> --------------------------------------
>> >>> >>>>> Brian Fitzgerald, PMP, GISP
>> >>> >>>>> bkfitz at gmail.com
>> >>> >>>>> 803.426.3469
>> >>> >>>>> ---------------------------------------
>> >>> >>>>
>> >>> >>>>
>> >>> >>>>
>> >>> >>>>
>> >>> >>>> --
>> >>> >>>> --------------------------------------
>> >>> >>>> Brian Fitzgerald, PMP, GISP
>> >>> >>>> bkfitz at gmail.com
>> >>> >>>> 803.426.3469
>> >>> >>>> ---------------------------------------
>> >>> >>>>
>> >>> >>>>
>> >>> >>>
>> >>> >>>
>> >>> >>>
>> >>> >>> --
>> >>> >>> --------------------------------------
>> >>> >>> Brian Fitzgerald, PMP, GISP
>> >>> >>> bkfitz at gmail.com
>> >>> >>> 803.426.3469
>> >>> >>> ---------------------------------------
>> >>> >>>
>> >>> >>>
>> >>> >>
>> >>> >>
>> >>> >>
>> >>> >> --
>> >>> >> --------------------------------------
>> >>> >> Brian Fitzgerald, PMP, GISP
>> >>> >> bkfitz at gmail.com
>> >>> >> 803.426.3469
>> >>> >> ---------------------------------------
>> >>> >
>> >>> >
>> >>> >
>> >>> >
>> >>> > --
>> >>> > --------------------------------------
>> >>> > Brian Fitzgerald, PMP, GISP
>> >>> > bkfitz at gmail.com
>> >>> > 803.426.3469
>> >>> > ---------------------------------------
>> >>
>> >>
>> >>
>> >> _______________________________________________
>> >> Qgis-user mailing list
>> >> Qgis-user at lists.osgeo.org
>> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
>> >>
>> >
>> > _______________________________________________
>> > Qgis-user mailing list
>> > Qgis-user at lists.osgeo.org
>> > http://lists.osgeo.org/mailman/listinfo/qgis-user
>> >
>
>
>
>
> --
> --------------------------------------
> Brian Fitzgerald, PMP, GISP
> bkfitz at gmail.com
> 803.426.3469
> ---------------------------------------