<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>
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 class="moz-signature" cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
On 08/28/2012 03:56 PM, Brian Fitzgerald wrote:<br>
</div>
<blockquote
cite="mid:CAPx4pOfW0n0_xVt3LA6Hezx0Ef1Tq1DE5h9UCEx2GrtySTpxCQ@mail.gmail.com"
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 class="HOEnZb"><font color="#888888">
<div>
<br>
</div>
<div><br>
</div>
<div>- Brian</div>
</font></span>
<div>
<div class="h5"><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>803.426.3469</span><br>
<span>------------------------------</span><span>---------</span><br>
</div>
</div>
</blockquote>
<br>
</body>
</html>