Hi, Brian and Etienne.
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.
Fortunately, vector data is a mature standard inside postgis and didn't
suffer any major changes that could break previous working code.
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.
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.
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.
All the best,
Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)
On 08/28/2012 04:17 PM, Brian Fitzgerald wrote:
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?
- Brian
On Tue, Aug 28, 2012 at 3:01 PM, Mauricio de Paulo
<[email protected] <mailto:[email protected]>> 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
<[email protected] <mailto:[email protected]>> 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@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
<[email protected] <mailto:[email protected]>> 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" <[email protected]
<mailto:[email protected]>>
Date: Aug 27, 2012 4:57 PM
Subject: wktraster with Postgis 2.0 in QGIS 1.9 on Linux
Mint Maya
To: <[email protected] <mailto:[email protected]>>
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
[email protected] <mailto:[email protected]>
803.426.3469 <tel:803.426.3469>
---------------------------------------
--
--------------------------------------
Brian Fitzgerald, PMP, GISP
[email protected] <mailto:[email protected]>
803.426.3469 <tel:803.426.3469>
---------------------------------------
--
--------------------------------------
Brian Fitzgerald, PMP, GISP
[email protected] <mailto:[email protected]>
803.426.3469 <tel:803.426.3469>
---------------------------------------
--
--------------------------------------
Brian Fitzgerald, PMP, GISP
[email protected] <mailto:[email protected]>
803.426.3469
---------------------------------------
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
