[postgis-users] PostGis Raster questions

Giannis Giakoumidakis ggiakoumidakis at yahoo.com
Wed Oct 12 04:42:06 PDT 2011


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?






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

Hi Giannis,

2011/10/12 Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>:
> 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/.

This is a post from my blog. I'm glad you could configure PostGIS
Raster following the instructions. Don't hesitate to ask me for any
question.


> 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.

Yes, this is normal. You can't see any geometries because you're
dealing with raster data, not geometry data. But you can use the QGIS
WKTRaster plugin, from here http://pyqgis.org/repo/contributed. This
is the direct link
http://spatialserver.net/pyqgis_1.0/contributed/wktraster.zip

Best regards,
Jorge




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



-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111012/96b30746/attachment.html>


More information about the postgis-users mailing list