<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Yes I found the QGIS plugin in here: http://pyqgis.org/repo/contributed, but how can I use it in Windows 7? I think it is source, only for Linux. Are there any instructions for applying it in QGIS in Windows?<br></span></div><div><br><span></span></div><div><br><span></span></div><div><span><br></span></div><div><br></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><br><b><span style="font-weight: bold;">Cc:</span></b> PostGIS Users Discussion
<postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, October 12, 2011 1:54 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] PostGis Raster questions<br></font><br>
Hi Giannis,<br><br>2011/10/12 Giannis Giakoumidakis <<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>>:<br>> Hello Jorge and thanks for the answer,<br>> I use for this work Windows 7 and I'm a bit confused with the tools but i<br>> think that i have already done with the installations, by following exactly<br>> this post:<br>> http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/.<br><br>This is a post from my blog. I'm glad you could configure PostGIS<br>Raster following the instructions. Don't hesitate to ask me for any<br>question.<br><br><br>> After this i upload normally raster images to my database (at<br>> template_postgis20) but when i connect to QGIS they have no geometry, so i<br>> can't display them in QGIS. Is this possible to happen or i have understood<br>> wrong and I can only use them for
queries?<br>> Also, I can't find any QGIS<br>> Postgis raster plugin for Windows, any further help for this?<br>><br>> Thank you very much.<br><br>Yes, this is normal. You can't see any geometries because you're<br>dealing with raster data, not geometry data. But you can use the QGIS<br>WKTRaster plugin, from here http://pyqgis.org/repo/contributed. This<br>is the direct link<br>http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip<br><br>Best regards,<br>Jorge<br><br><br><br><br>> ________________________________<br>> From: Jorge Arévalo <<a ymailto="mailto:jorge.arevalo@deimos-space.com" href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a>><br>> To: Giannis Giakoumidakis <<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>>; PostGIS Users<br>> Discussion <<a ymailto="mailto:postgis-users@postgis.refractions.net"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>> Sent: Monday, September 12, 2011 12:21 PM<br>> Subject: Re: [postgis-users] PostGis Raster questions<br>><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,<br>>> the<br>>> .tiff most times doesn't appear or it does but with no geometry, so it<br>>> can't<br>>> be visualized.<br>>> If anyone could help i would be glad, because i'm stuck and i can't move<br>>> 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 <a href="http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip" target="_blank">http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip</a><br>><br>> WKT Raster was the old name of the extension. Now is known as PostGIS<br>> 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>><br><br><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><a href="http://es.linkedin.com/in/jorgearevalo80" target="_blank">http://es.linkedin.com/in/jorgearevalo80</a><br><a href="http://mobility.grupodeimos.com/"
target="_blank">http://mobility.grupodeimos.com/</a><br><a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br><a href="http://geohash.org/ezjqgrgzz0g" target="_blank">http://geohash.org/ezjqgrgzz0g</a><br><br><br></div></div></div></body></html>