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