<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">Hi, Brian.<br>
Did you try to reinstall qgis forcing the version available in
ubuntu-gis unstable?<br>
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.<br>
All the best,<br>
<pre class="moz-signature" cols="72">Mauricio C. M. de Paulo
</pre>
On 08/29/2012 05:25 PM, Brian Fitzgerald wrote:<br>
</div>
<blockquote
cite="mid:CAPx4pOfrOa6sU-b_OhXMdXvkwJeMr3BwOD2=q8bX1N2fM6XJQw@mail.gmail.com"
type="cite">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?
<div><br>
</div>
<div>
<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
<div class="gmail_quote">On Wed, Aug 29, 2012 at 4:22 PM, Brian
Fitzgerald <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">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.
<div>
<br>
</div>
<div>Thx for all your help!</div>
<span class="HOEnZb"><font color="#888888">
<div><br>
</div>
<div>- Brian</div>
</font></span>
<div class="HOEnZb">
<div class="h5">
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
<div class="gmail_quote">
On Tue, Aug 28, 2012 at 3:29 PM, Mauricio de Paulo <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:mauricio.dev@gmail.com"
target="_blank">mauricio.dev@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi, Brian and Etienne.<br>
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.<br>
<br>
Fortunately, vector data is a mature standard
inside postgis and didn't 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 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.<br>
<br>
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. <br>
<br>
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.<br>
<br>
All the best,<br>
<pre cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
<div>
<div> On 08/28/2012 04:17 PM, Brian
Fitzgerald wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote type="cite">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?
<div><br>
</div>
<div>- Brian<br>
<br>
<div class="gmail_quote">On Tue, Aug 28,
2012 at 3:01 PM, Mauricio de Paulo <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:mauricio.dev@gmail.com"
target="_blank">mauricio.dev@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF"
text="#000000">
<div>Hi Brian,<br>
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.<br>
<br>
Sorry for my ignorance but what
GDAL version is being released
with linux mint? I couldn't find
anywhere online.<br>
<br>
The plugin heavily relies on
GDAL to perform the
visualization so you 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 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.<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
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.<br>
<br>
I'm copying this mail to the
list to allow other users to
find this thread later.
<pre cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
<div>
<div> On 08/28/2012 03:56 PM,
Brian Fitzgerald wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote type="cite">PS -
Im also unable to "load"
raster data into PostGIS
using the plugin... the icon
is greyed out for some
reason.
<div><br>
</div>
<div>- Brian<br>
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
<div class="gmail_quote">
On Tue, Aug 28, 2012
at 2:20 PM, Brian
Fitzgerald <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
Sure.
<div><br>
</div>
<div>I'm running
Ubuntu Mint 13
Cinnamon with
Postgres 1.9.5,
Postgis 2.0. and
QGIS 1.9.0</div>
<div><br>
</div>
<div>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></div>
<div><br>
</div>
<div>I loaded the
sample vector
shapefile into my
new 'training'
database and
opened it in QGIS
with no problem.</div>
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>
<div>Installed the
following
packages:</div>
<div>libjs-sphinxdoc
(1.1.3+dfsg-2ubuntu2.1)</div>
<div>libjs-underscore
(1.1.6-1ubuntu2)</div>
<div>python-dbg
(2.7.3-0ubuntu2)</div>
<div>python-psycopg2
(2.4.5-1)</div>
<div>python-psycopg2-dbg
(2.4.5-1)</div>
<div>python-psycopg2-doc
(2.4.5-1)</div>
<div>python2.7-dbg
(2.7.3-0ubuntu3.1)</div>
<div>python3
(3.2.3-0ubuntu1)</div>
<div>python3-dbg
(3.2.3-0ubuntu1)</div>
<div>python3-minimal
(3.2.3-0ubuntu1)</div>
<div>python3-psycopg2
(2.4.5-1)</div>
<div>python3-psycopg2-dbg
(2.4.5-1)</div>
<div>python3.2
(3.2.3-0ubuntu3)</div>
<div>python3.2-dbg
(3.2.3-0ubuntu3)</div>
<div>python3.2-minimal
(3.2.3-0ubuntu3)</div>
<div><br>
</div>
<div> 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.</div>
<div><br>
</div>
<div>I also tried
one of our ortho
geotiffs using
the following
command and get
the same
results:</div>
<div><br>
</div>
<div>
<div>postgres@minty
/home/rcgeoadmin/Temp
$ raster2pgsql
-s 4326
/home/rcgeoadmin/Temp/979903.tif
| psql
training</div>
<div>Processing
1/1:
/home/rcgeoadmin/Temp/979903.tif</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>Warning 1:
TIFFReadDirectory:Unknown
field with tag
33919 (0x847f)
encountered</div>
<div>BEGIN</div>
<div>NOTICE:
CREATE TABLE
will create
implicit
sequence
"979903_rid_seq"
for serial
column
"979903.rid"</div>
<div>NOTICE:
CREATE TABLE
/ PRIMARY KEY
will create
implicit index
"979903_pkey"
for table
"979903"</div>
<div>CREATE
TABLE</div>
<div>INSERT 0 1</div>
<div>COMMIT</div>
</div>
<span><font
color="#888888">
<div> <br>
</div>
<div><br>
</div>
<div>- Brian</div>
</font></span>
<div>
<div><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div
class="gmail_quote">On
Tue, Aug 28,
2012 at 8:24
AM, Mauricio
de Paulo <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:mauricio.dev@gmail.com"
target="_blank">mauricio.dev@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
bgcolor="#FFFFFF"
text="#000000">
<div>Hi,
Brian.<br>
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?<br>
All the best,<br>
<pre cols="72">Mauricio C. M. de Paulo
</pre>
<div>
<div> On
08/27/2012
07:00 PM,
Brian
Fitzgerald
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote
type="cite">
<div
class="gmail_quote">----------
Forwarded
message
----------<br>
From: "Brian
Fitzgerald"
<<a
moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">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" target="_blank">wonder.sk@gmail.com</a>><br>
<br
type="attribution">
I'm having
problems
loading a
Postgis 2.0
raster layer
into QGIS 1.9
using your
wktraster
extension.
<div><br>
</div>
<div> The menu
comes up, but
I get a "could
not load
layer"</div>
<div><br>
</div>
<div>Then a
window that
says:</div>
<div><br>
</div>
<div>"Could
not load PG:
dbname=training
host=localhost
user=postgres
password=topology4
port=5432
table= mode=2"</div>
<div><br>
</div>
<div>Any
ideas?<font
color="#888888"><br
clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian
Fitzgerald,
PMP, GISP</span><br>
<a
moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span><a
moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469" target="_blank">803.426.3469</a></span><br>
<span>------------------------------</span><span>---------</span><br>
</font></div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian
Fitzgerald,
PMP, GISP</span><br>
<a
moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span><a
moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469" target="_blank">803.426.3469</a></span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian Fitzgerald,
PMP, GISP</span><br>
<a
moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span><a
moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469" target="_blank">803.426.3469</a></span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian Fitzgerald, PMP, GISP</span><br>
<a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com"
target="_blank">bkfitz@gmail.com</a><br>
<span><a moz-do-not-send="true"
href="tel:803.426.3469"
value="+18034263469" target="_blank">803.426.3469</a></span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian Fitzgerald, PMP, GISP</span><br>
<a moz-do-not-send="true"
href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span><a moz-do-not-send="true"
href="tel:803.426.3469" value="+18034263469"
target="_blank">803.426.3469</a></span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span>------------------------------</span><span>--------</span><br>
<span>Brian Fitzgerald, PMP, GISP</span><br>
<a moz-do-not-send="true" href="mailto:bkfitz@gmail.com"
target="_blank">bkfitz@gmail.com</a><br>
<span>803.426.3469</span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</blockquote>
<br>
</body>
</html>