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

Thu Aug 30 06:36:26 PDT 2012

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120830/6de5bc7a/attachment.html>