[postgis-users] PostGis Raster questions

Giannis Giakoumidakis ggiakoumidakis at yahoo.com
Wed Oct 12 03:45:01 PDT 2011

Hello Jorge and thanks for the answer,

I use for this work Windows 7 and I'm a bit confused with the tools but i think that i have already done with the installations, by following exactly this post: http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/.

After this i upload normally raster images to my database (at template_postgis20) but when i connect to QGIS they have no geometry, so i can't display them in QGIS. Is this possible to happen or i have understood wrong and I can only use them for queries? Also, I can't find any QGIS Postgis raster plugin for Windows, any further help for this? 

Thank you very much.

From: Jorge Arévalo <jorge.arevalo at deimos-space.com>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Monday, September 12, 2011 12:21 PM
Subject: Re: [postgis-users] PostGis Raster questions

On Mon, Sep 12, 2011 at 10:51 AM, Giannis Giakoumidakis
<ggiakoumidakis at yahoo.com> wrote:
> Hello to everyone,
> I'm very new to postGis stuff and i finally manage to import into my
> database a .shp file and a .tiff one, with the raster extension.
> I used these commands for the raster file (found here:
> http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html):
>>$ python raster2pgsql.py -r /path/to/katrina.tif -t katrina -l 1 -k 64x64
>> -o katrina.sql -s 4326 -I -M
>>$ psql -d <raster_database> -f katrina.sql -U <user> -W
> Now i'm able to see the raster file in the database, as a new table and in
> the raster_columns. My problem is that i can't see/use it from any gis
> program that i tried, such as uDig, QGis etc. Contrary to the .shp file, the
> .tiff most times doesn't appear or it does but with no geometry, so it can't
> be visualized.
> If anyone could help i would be glad, because i'm stuck and i can't move on
> to my thesis.
> Thanx.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Hello Giannis,

You need the GDAL PostGIS Raster driver to connect with programs like
QGIS. Plus, if you use QGIS, you can download the PostGIS Raster
plugin from http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip

WKT Raster was the old name of the extension. Now is known as PostGIS Raster.

BTW, you need GDAL 1.8 or higher. The driver version included in GDAL
1.7 had bugs, fixed in 1.8. And I'm working in the driver right now.
The new version (faster and improved) will be packed in GDAL 1.8.2, I
hope (and before, if you use GDAL trunk).

Anyway, Could you please try with QGIS + QGIS PostGIS Raster plugin?
And GDAL 1.8.1

Best regards,

Jorge Arévalo
Internet & Mobility Division, DEIMOS
jorge.arevalo at deimos-space.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111012/ff670b30/attachment.html>

More information about the postgis-users mailing list