[Qgis-user] Fwd: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint Maya
Mauricio de Paulo
mauricio.dev at gmail.com
Thu Aug 30 05:51:01 PDT 2012
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
> 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>
> > ---------------------------------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120830/7b40fcb7/attachment.html>
More information about the Qgis-user
mailing list