<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hello Jorge and thanks for the answer,</span></div><div><br><span></span></div><div><span>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/.</span></div><div><br><span></span></div><div><span>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? <br></span></div><div><span><br></span></div><div><span>Thank you very
much.</span></div><div><span><br></span></div><div><br><span></span></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Jorge Arévalo <jorge.arevalo@deimos-space.com><br><b><span style="font-weight: bold;">To:</span></b> Giannis Giakoumidakis <ggiakoumidakis@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Monday, September 12, 2011 12:21 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] PostGis Raster questions<br></font><br>
On Mon, Sep 12, 2011 at 10:51 AM, Giannis Giakoumidakis<br><<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>> wrote:<br>> Hello to everyone,<br>> I'm very new to postGis stuff and i finally manage to import into my<br>> database a .shp file and a .tiff one, with the raster extension.<br>> I used these commands for the raster file (found here:<br>> <a href="http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html" target="_blank">http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html</a>):<br>>>$ python <a target="_blank" href="http://raster2pgsql.py">raster2pgsql.py</a> -r /path/to/katrina.tif -t katrina -l 1 -k 64x64<br>>> -o katrina.sql -s 4326 -I -M<br>>>$ psql -d <raster_database> -f katrina.sql -U <user> -W<br>> Now i'm able to see the raster file in the database, as a new table and in<br>> the raster_columns. My problem is that i can't
see/use it from any gis<br>> program that i tried, such as uDig, QGis etc. Contrary to the .shp file, the<br>> .tiff most times doesn't appear or it does but with no geometry, so it can't<br>> be visualized.<br>> If anyone could help i would be glad, because i'm stuck and i can't move on<br>> to my thesis.<br>> Thanx.<br>><br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br>><br>><br><br>Hello Giannis,<br><br>You need the GDAL PostGIS Raster driver to connect with programs like<br>QGIS. Plus, if you use QGIS, you can download the PostGIS Raster<br>plugin from http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip<br><br>WKT Raster was the old
name of the extension. Now is known as PostGIS Raster.<br><br>BTW, you need GDAL 1.8 or higher. The driver version included in GDAL<br>1.7 had bugs, fixed in 1.8. And I'm working in the driver right now.<br>The new version (faster and improved) will be packed in GDAL 1.8.2, I<br>hope (and before, if you use GDAL trunk).<br><br>Anyway, Could you please try with QGIS + QGIS PostGIS Raster plugin?<br>And GDAL 1.8.1<br><br>Best regards,<br><br>-- <br>Jorge Arévalo<br>Internet & Mobility Division, DEIMOS<br><a ymailto="mailto:jorge.arevalo@deimos-space.com" href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a><br>http://es.linkedin.com/in/jorgearevalo80<br>http://mobility.grupodeimos.com/<br>http://gis4free.wordpress.com<br>http://geohash.org/ezjqgrgzz0g<br><br><br></div></div></div></body></html>