[postgis-users] PostGis Raster questions

[Jorge Arévalo]

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
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g