<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Don't quote me on this, but I have a
memory of the nightly ppas not being linked against the latest
gdal released.<br>
<pre class="moz-signature" cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
On 08/30/2012 09:42 AM, Brian Fitzgerald wrote:<br>
</div>
<blockquote
cite="mid:CAPx4pOdmDDqEJseQgTqdEyydi8yxff-jqXuREUSLMSZrBMvGxQ@mail.gmail.com"
type="cite">
<p>Yeah... I've been using the nightly ppas</p>
<p>----------------------------<br>
Brian Fitzgerald<br>
<a moz-do-not-send="true" href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
803-426-3469<br>
Sent from my mobile phone<br>
----------------------------</p>
<div class="gmail_quote">On Aug 30, 2012 8:39 AM, "Etienne
Tourigny" <<a moz-do-not-send="true"
href="mailto:etourigny.dev@gmail.com">etourigny.dev@gmail.com</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
If you want the nightlies ( which I don't recommend for
production)<br>
you should be using these (and only these)<br>
<br>
deb <a moz-do-not-send="true"
href="http://qgis.org/ubuntugis-nightly" target="_blank">http://qgis.org/ubuntugis-nightly</a>
precise main<br>
deb-src <a moz-do-not-send="true"
href="http://qgis.org/ubuntugis-nightly" target="_blank">http://qgis.org/ubuntugis-nightly</a>
precise main<br>
deb <a moz-do-not-send="true"
href="http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu"
target="_blank">http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu</a><br>
precise main<br>
<br>
For a more stable, but still recent, use ubuntugis-unstable
(only)<br>
<br>
< remove other repos, and remove anything related to qgis
(including gdal)<br>
<br>
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable<br>
sudo apt-get update<br>
sudo apt-get install qgis<br>
<br>
On Wed, Aug 29, 2012 at 5:25 PM, Brian Fitzgerald <<a
moz-do-not-send="true" href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a>>
wrote:<br>
> Scratch previous email... I just went to QGIS -> about
and found that QGIS<br>
> is "Compiled against GDAL/OGR 1.7.3" even though I
installed the 1.9 GDAL<br>
> libaries before I install QGIS. Now what?<br>
><br>
><br>
><br>
><br>
><br>
><br>
> On Wed, Aug 29, 2012 at 4:22 PM, Brian Fitzgerald <<a
moz-do-not-send="true" href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a>>
wrote:<br>
>><br>
>> How do I figure out what version of GDAL my QGIS is
using... I reinstalled<br>
>> everything (QGIS nightlies, gdal from the
unstable-gis ppas, postgres and<br>
>> postgis) and am running into the same problem. I
checked in Synaptic and<br>
>> see both 1.7 and 1.9 gdal libraries installed.<br>
>><br>
>> Thx for all your help!<br>
>><br>
>> - Brian<br>
>><br>
>><br>
>><br>
>><br>
>> On Tue, Aug 28, 2012 at 3:29 PM, Mauricio de Paulo<br>
>> <<a moz-do-not-send="true"
href="mailto:mauricio.dev@gmail.com">mauricio.dev@gmail.com</a>>
wrote:<br>
>>><br>
>>> Hi, Brian and Etienne.<br>
>>> Well, GDAL 1.7.3 was one of the first efforts to
read postgis raster,<br>
>>> back in the release candidate days. A few months
before the release of<br>
>>> postgis 2.0 there was a major change in the
raster storage and some code was<br>
>>> discontinued. GDAL 1.9.0 was the first release
after postgis 2.0 was<br>
>>> released so it's the first version that is
compatible.<br>
>>><br>
>>> Fortunately, vector data is a mature standard
inside postgis and didn't<br>
>>> suffer any major changes that could break
previous working code.<br>
>>><br>
>>> Even though we were all notified by these
changes, some of our previous<br>
>>> work doesn't work with the current version. It
was a huge improvement in<br>
>>> raster storage and metadata retrieval, so we have
to cope with it.<br>
>>><br>
>>> I'm releasing the new plugin version with the
weak loader tonight. It<br>
>>> should be enough to upload one untiled raster
with no overviews to the<br>
>>> database.<br>
>>><br>
>>> I'm using ubuntugis' repositories. The gdal
package available on it is<br>
>>> version 1.9.1 so you might want to try those
binaries, since they work<br>
>>> pretty well.<br>
>>><br>
>>> All the best,<br>
>>><br>
>>> Mauricio C. M. de Paulo<br>
>>> Engenheiro Cartógrafo<br>
>>> Mestrando em Sensoriamento Remoto (INPE)<br>
>>><br>
>>> On 08/28/2012 04:17 PM, Brian Fitzgerald wrote:<br>
>>><br>
>>> I'm showing GDAL version 1.7.3-6 in Synaptic...
so that could be my<br>
>>> problem... but wouldn't I also be experiencing
loading postgis 2.0 vectors?<br>
>>><br>
>>> - Brian<br>
>>><br>
>>> On Tue, Aug 28, 2012 at 3:01 PM, Mauricio de
Paulo<br>
>>> <<a moz-do-not-send="true"
href="mailto:mauricio.dev@gmail.com">mauricio.dev@gmail.com</a>>
wrote:<br>
>>>><br>
>>>> Hi Brian,<br>
>>>> I downloaded the sample data and imported to
my database and it seems to<br>
>>>> work pretty well. I'm using QGIS 1.8, postgis
2.0, postgres 9.1.5, gdal<br>
>>>> 1.9.1 on ubuntu 12.04.<br>
>>>><br>
>>>> Sorry for my ignorance but what GDAL version
is being released with<br>
>>>> linux mint? I couldn't find anywhere online.<br>
>>>><br>
>>>> The plugin heavily relies on GDAL to perform
the visualization so you<br>
>>>> need the latest GDAL available to get a
decent performance.<br>
>>>><br>
>>>> From my first tests I can say that GDAL 1.9.1
has greatly improved<br>
>>>> performance and the next versions should
improve even further. The fastest<br>
>>>> visualization that I have achieved with
version 1.9.1 is with single tiled<br>
>>>> raster files. Unfortunately I wasn't able to
get GDAL to use overviews so<br>
>>>> far, but Jorge (GDAL's postgis raster
developper) is researching on this<br>
>>>> subject.<br>
>>>><br>
>>>> GDAL versions bellow 1.9 should not be able
to read postgis 2.0.<br>
>>>><br>
>>>> Unfortunately, since postgis 2.0 release, the
python loader was<br>
>>>> discontinued in postgis source. Recently I
have started to make the<br>
>>>> necessary changes starting from the old code
to get it to work. I don't know<br>
>>>> if this is going to be a good solution but it
seems possible. I'm trying to<br>
>>>> avoid the platform-dependent compilation that
postgis' raster loader has in<br>
>>>> version 2.0 now that it's being entirely
written in C. In the future I<br>
>>>> should probably release a simple uploader
with the plugin, without all those<br>
>>>> options until I'm certain that everything is
working according to the<br>
>>>> standard.<br>
>>>><br>
>>>> I'm copying this mail to the list to allow
other users to find this<br>
>>>> thread later.<br>
>>>><br>
>>>> Mauricio C. M. de Paulo<br>
>>>> Engenheiro Cartógrafo<br>
>>>> Mestrando em Sensoriamento Remoto (INPE)<br>
>>>><br>
>>>> On 08/28/2012 03:56 PM, Brian Fitzgerald
wrote:<br>
>>>><br>
>>>> PS - Im also unable to "load" raster data
into PostGIS using the<br>
>>>> plugin... the icon is greyed out for some
reason.<br>
>>>><br>
>>>> - Brian<br>
>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>> On Tue, Aug 28, 2012 at 2:20 PM, Brian
Fitzgerald <<a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a>><br>
>>>> wrote:<br>
>>>>><br>
>>>>> Sure.<br>
>>>>><br>
>>>>> I'm running Ubuntu Mint 13 Cinnamon with
Postgres 1.9.5, Postgis 2.0.<br>
>>>>> and QGIS 1.9.0<br>
>>>>><br>
>>>>> I followed this install tutorial:<br>
>>>>><br>
>>>>> <a moz-do-not-send="true"
href="http://linfiniti.com/2012/05/installing-postgis-2-0-on-ubuntu/"
target="_blank">http://linfiniti.com/2012/05/installing-postgis-2-0-on-ubuntu/</a><br>
>>>>><br>
>>>>> I loaded the sample vector shapefile into
my new 'training' database<br>
>>>>> and opened it in QGIS with no problem.<br>
>>>>><br>
>>>>> I loaded the sample raster data using the
command in the tutorial, it<br>
>>>>> loaded with no problems. I ran the test
query in the tutorial, no problem.<br>
>>>>> I went into QGIS to load the raster and
got an error that referred to some<br>
>>>>> missing python dependencies (i think it
was the python-psycopg libs)... so I<br>
>>>>> went to Synaptic and loaded the
following:<br>
>>>>><br>
>>>>> Installed the following packages:<br>
>>>>> libjs-sphinxdoc (1.1.3+dfsg-2ubuntu2.1)<br>
>>>>> libjs-underscore (1.1.6-1ubuntu2)<br>
>>>>> python-dbg (2.7.3-0ubuntu2)<br>
>>>>> python-psycopg2 (2.4.5-1)<br>
>>>>> python-psycopg2-dbg (2.4.5-1)<br>
>>>>> python-psycopg2-doc (2.4.5-1)<br>
>>>>> python2.7-dbg (2.7.3-0ubuntu3.1)<br>
>>>>> python3 (3.2.3-0ubuntu1)<br>
>>>>> python3-dbg (3.2.3-0ubuntu1)<br>
>>>>> python3-minimal (3.2.3-0ubuntu1)<br>
>>>>> python3-psycopg2 (2.4.5-1)<br>
>>>>> python3-psycopg2-dbg (2.4.5-1)<br>
>>>>> python3.2 (3.2.3-0ubuntu3)<br>
>>>>> python3.2-dbg (3.2.3-0ubuntu3)<br>
>>>>> python3.2-minimal (3.2.3-0ubuntu3)<br>
>>>>><br>
>>>>> I then came back to QGIS to open the
raster and no longer get the<br>
>>>>> python error... this time it brings up
the "Load PostGIS Raster Layer" just<br>
>>>>> fine and displays my sample raster. I
click on the raster name in the table<br>
>>>>> and it puts it down in the "Table Name"
input box. I then click on OK and<br>
>>>>> get a window that pops up saying "Could
Not Load Layer". I click ok to this<br>
>>>>> and another window comes up that says:
"Could not load PG: dbname=training<br>
>>>>> host=localhost user=postgres
password=xxxxxx port=5432 schema=public<br>
>>>>> table=srtm_4326 mode=2". When I click ok
to this, the window diappears and<br>
>>>>> nothing happens.<br>
>>>>><br>
>>>>> I also tried one of our ortho geotiffs
using the following command and<br>
>>>>> get the same results:<br>
>>>>><br>
>>>>> postgres@minty /home/rcgeoadmin/Temp $
raster2pgsql -s 4326<br>
>>>>> /home/rcgeoadmin/Temp/979903.tif | psql
training<br>
>>>>> Processing 1/1:
/home/rcgeoadmin/Temp/979903.tif<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> Warning 1: TIFFReadDirectory:Unknown
field with tag 33919 (0x847f)<br>
>>>>> encountered<br>
>>>>> BEGIN<br>
>>>>> NOTICE: CREATE TABLE will create
implicit sequence "979903_rid_seq"<br>
>>>>> for serial column "979903.rid"<br>
>>>>> NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index<br>
>>>>> "979903_pkey" for table "979903"<br>
>>>>> CREATE TABLE<br>
>>>>> INSERT 0 1<br>
>>>>> COMMIT<br>
>>>>><br>
>>>>><br>
>>>>> - Brian<br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>> On Tue, Aug 28, 2012 at 8:24 AM, Mauricio
de Paulo<br>
>>>>> <<a moz-do-not-send="true"
href="mailto:mauricio.dev@gmail.com">mauricio.dev@gmail.com</a>>
wrote:<br>
>>>>>><br>
>>>>>> Hi, Brian.<br>
>>>>>> Could you please elaborate a little
more about what were you trying to<br>
>>>>>> do and what raster configuration you
were using? Is it tiled or untiled? One<br>
>>>>>> single raster file in the table? Did
you build overviews?<br>
>>>>>> All the best,<br>
>>>>>><br>
>>>>>> Mauricio C. M. de Paulo<br>
>>>>>><br>
>>>>>> On 08/27/2012 07:00 PM, Brian
Fitzgerald wrote:<br>
>>>>>><br>
>>>>>> ---------- Forwarded message
----------<br>
>>>>>> From: "Brian Fitzgerald" <<a
moz-do-not-send="true" href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a>><br>
>>>>>> Date: Aug 27, 2012 4:57 PM<br>
>>>>>> Subject: wktraster with Postgis 2.0
in QGIS 1.9 on Linux Mint Maya<br>
>>>>>> To: <<a moz-do-not-send="true"
href="mailto:wonder.sk@gmail.com">wonder.sk@gmail.com</a>><br>
>>>>>><br>
>>>>>> I'm having problems loading a Postgis
2.0 raster layer into QGIS 1.9<br>
>>>>>> using your wktraster extension.<br>
>>>>>><br>
>>>>>> The menu comes up, but I get a "could
not load layer"<br>
>>>>>><br>
>>>>>> Then a window that says:<br>
>>>>>><br>
>>>>>> "Could not load PG: dbname=training
host=localhost user=postgres<br>
>>>>>> password=topology4 port=5432 table=
mode=2"<br>
>>>>>><br>
>>>>>> Any ideas?<br>
>>>>>><br>
>>>>>> --<br>
>>>>>>
--------------------------------------<br>
>>>>>> Brian Fitzgerald, PMP, GISP<br>
>>>>>> <a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
>>>>>> <a moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
>>>>>>
---------------------------------------<br>
>>>>>><br>
>>>>>><br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>> --<br>
>>>>> --------------------------------------<br>
>>>>> Brian Fitzgerald, PMP, GISP<br>
>>>>> <a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
>>>>> <a moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
>>>>> ---------------------------------------<br>
>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>> --<br>
>>>> --------------------------------------<br>
>>>> Brian Fitzgerald, PMP, GISP<br>
>>>> <a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
>>>> <a moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
>>>> ---------------------------------------<br>
>>>><br>
>>>><br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>> --------------------------------------<br>
>>> Brian Fitzgerald, PMP, GISP<br>
>>> <a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
>>> <a moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
>>> ---------------------------------------<br>
>>><br>
>>><br>
>><br>
>><br>
>><br>
>> --<br>
>> --------------------------------------<br>
>> Brian Fitzgerald, PMP, GISP<br>
>> <a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
>> <a moz-do-not-send="true" href="tel:803.426.3469"
value="+18034263469">803.426.3469</a><br>
>> ---------------------------------------<br>
><br>
><br>
><br>
><br>
> --<br>
> --------------------------------------<br>
> Brian Fitzgerald, PMP, GISP<br>
> <a moz-do-not-send="true" href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
> <a moz-do-not-send="true" href="tel:803.426.3469"
value="+18034263469">803.426.3469</a><br>
> ---------------------------------------<br>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>