[postgis-users] raster support

[Pierre Racine]

Hi Stefan,

I personally don't use QGIS to visualize PostGIS rasters so I'm not of much help. I still use OpenJump to visualise vectorization of my rasters. It turns out to be always much more simple than figuring how to do it, with what, in QGIS.

There was a QGIS python plugin to display PostGIS raster. I don't think I tried it since QGIS 2.0 is out though. Apparently it is now broken :-(   Anyway that plugin was, from my point of view, badly designed without a good understanding of the better way to exploit PostGIS Raster.

I just gave a try to the recipe given in the post (using the DB Manager once a connection with PostGIS has been done) and it works when the raster was loaded with raster2pgsql and the constraints were set.

Yes we need a SIMPLE way to deal with any PostGIS rasters in QGIS. Efforts should be concentrated on the "Add PostGIS Table" dialog. Maybe Boundless could help concentrating the efforts.

Pierre

> -----Original Message-----
> From: Stefan Keller [mailto:sfkeller at gmail.com]
> Sent: Sunday, June 08, 2014 2:53 AM
> To: PostGIS Users Discussion
> Cc: Pierre Racine
> Subject: Re: [postgis-users] raster support
> 
> Salut Pierre
> 
> Can you help on how to display PostGIS Raster in QGIS 2.x exactly?
> I've found this
> http://postgis.17.x6.nabble.com/Problem-with-postgis-raster-
> td5006344.html
> 
> but it's not specific on how to achieve this.
> 
> In addition, do you think QGIS needs a Python plugin (before it manages to
> be adapted by QGIS core)?
> 
> Yours, Stefan
> 
> 
> 
> 2014-06-05 20:40 GMT+02:00 Pierre Racine <Pierre.Racine at sbf.ulaval.ca>:
> 
> 
> 	These variables are system variables, not PostgreSQL variables. to
> know how to set them in your system search for "set environment variable
> os x".
> 
> 	Pierre
> 
> 
> 	> -----Original Message-----
> 	> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-
> users-
> 	> bounces at lists.osgeo.org] On Behalf Of John Payne
> 	> Sent: Sunday, June 01, 2014 10:25 AM
> 	> To: postgis-users at lists.osgeo.org
> 	> Subject: [postgis-users] raster support
> 	>
> 	> I want to store raster data in PostGIS.  I am using Postgresql 9.2.4
> with
> 	> PostGIS 9.1.0 on a Mac Powerbook running OS X 10.8.5.  I want to
> use the
> 	> command "raster2pgsql" but I get an error message saying that
> the type
> 	> "raster" was not recognized.
> 	>
> 	> I think the problem may be (from Chapter 2.1 of the PostGIS
> manual):
> 	>
> 	>
> 	> "As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are
> disabled by
> 	> default. In order to re-enable these, you need to set the following
> 	> environment variables:POSTGIS_GDAL_ENABLED_DRIVERS and
> 	> POSTGIS_ENABLE_OUTDB_RASTERS in the server environment"
> 	>
> 	>
> 	> I tried adding the following to the end of my postgresql.conf file:
> 	> POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL
> 	> POSTGIS_ENABLE_OUTDB_RASTERS=1
> 	> However, it generated an error message saying that the variables
> weren't
> 	> recognized.  Can anyone tell me how to set them?
> 	>
> 	> Thanks,
> 	>
> 	> John
> 
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at lists.osgeo.org
> 	http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
>