[Qgis-user] Fwd: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint Maya
Mauricio de Paulo
mauricio.dev at gmail.com
Wed Aug 29 20:12:13 PDT 2012
Hi, Brian.
Did you try to reinstall qgis forcing the version available in
ubuntu-gis unstable?
You probably has two qgis repositories working now, since qgis 1.8 is
not available in the default ubuntu repositories. You may want to remove
the older repository and stick with ubuntugis unstable to avoid version
conflicts.
All the best,
Mauricio C. M. de Paulo
On 08/29/2012 05:25 PM, Brian Fitzgerald 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
> ---------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120830/5591d478/attachment.html>
More information about the Qgis-user
mailing list