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

[Etienne Tourigny]

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
> ---------------------------------------