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

Tue Aug 28 12:17:51 PDT 2012

Ola Mauricio

Linux Mint uses the ubuntu repositories, so look in the main ubuntu
repos for precise.

according to this, it uses 1.7.3

https://launchpad.net/ubuntu/precise/+package/gdal-bin

On Tue, Aug 28, 2012 at 4: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
> ---------------------------------------
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>