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

Thu Aug 30 06:40:44 PDT 2012

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
>