[Qgis-user] Fwd: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint Maya
Mauricio de Paulo
mauricio.dev at gmail.com
Fri Aug 31 06:04:34 PDT 2012
Could you please do one easy test? Try creating a table without a number
as first character in it's name.
I may have experienced this before. I don't remember exactly but i
suspect that this is a postgresql constraint. I think I should start
using " " on table's name in the plugin.
Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)
On 08/30/2012 02:47 PM, Brian Fitzgerald 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 <http://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 <mailto: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 <mailto: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 <mailto: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 <mailto:bkfitz at gmail.com>
> >> 803-426-3469 <tel:803-426-3469>
> >> Sent from my mobile phone
> >> ----------------------------
> >>
> >> On Aug 30, 2012 8:39 AM, "Etienne Tourigny"
> <etourigny.dev at gmail.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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
> <mailto: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 <mailto: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 <mailto:bkfitz at gmail.com>
> >>> >>>>>> 803.426.3469 <tel:803.426.3469>
> >>> >>>>>> ---------------------------------------
> >>> >>>>>>
> >>> >>>>>>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>> --
> >>> >>>>> --------------------------------------
> >>> >>>>> Brian Fitzgerald, PMP, GISP
> >>> >>>>> bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> >>> >>>>> 803.426.3469 <tel:803.426.3469>
> >>> >>>>> ---------------------------------------
> >>> >>>>
> >>> >>>>
> >>> >>>>
> >>> >>>>
> >>> >>>> --
> >>> >>>> --------------------------------------
> >>> >>>> Brian Fitzgerald, PMP, GISP
> >>> >>>> bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> >>> >>>> 803.426.3469 <tel:803.426.3469>
> >>> >>>> ---------------------------------------
> >>> >>>>
> >>> >>>>
> >>> >>>
> >>> >>>
> >>> >>>
> >>> >>> --
> >>> >>> --------------------------------------
> >>> >>> Brian Fitzgerald, PMP, GISP
> >>> >>> bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> >>> >>> 803.426.3469 <tel:803.426.3469>
> >>> >>> ---------------------------------------
> >>> >>>
> >>> >>>
> >>> >>
> >>> >>
> >>> >>
> >>> >> --
> >>> >> --------------------------------------
> >>> >> Brian Fitzgerald, PMP, GISP
> >>> >> bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> >>> >> 803.426.3469 <tel:803.426.3469>
> >>> >> ---------------------------------------
> >>> >
> >>> >
> >>> >
> >>> >
> >>> > --
> >>> > --------------------------------------
> >>> > Brian Fitzgerald, PMP, GISP
> >>> > bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> >>> > 803.426.3469 <tel:803.426.3469>
> >>> > ---------------------------------------
> >>
> >>
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
>
>
> --
> --------------------------------------
> Brian Fitzgerald, PMP, GISP
> bkfitz at gmail.com <mailto:bkfitz at gmail.com>
> 803.426.3469
> ---------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120831/1db43454/attachment.html>
More information about the Qgis-user
mailing list