Re: [postgis-users] Problem to visualize raster data from PostGIS inQGIS

2015-03-31 Thread Hugues François
: postgis-users@lists.osgeo.org Objet : [postgis-users] Problem to visualize raster data from PostGIS inQGIS I have two multiband raster files and i'm trying to load these data into PostGIS using “raster2pgsql”. Here is the syntax that i used: raster2pgsql -c -s 4326 -I -t 100x100 *.tif

Re: [postgis-users] Problem to visualize raster data from PostGIS inQGIS

2015-03-31 Thread Rémi Cura
to visualize raster data from PostGIS inQGIS I have two multiband raster files and i'm trying to load these data into PostGIS using “raster2pgsql”. Here is the syntax that i used: raster2pgsql -c -s 4326 -I -t 100x100 *.tif public.deforested_rasters | psql -d r342471958 It works without

Re: [postgis-users] Problem to visualize raster data from PostGIS inQGIS

2015-03-31 Thread Pierre Racine
Discussion Subject: Re: [postgis-users] Problem to visualize raster data from PostGIS inQGIS Hello, To display raster data, you can try ST_DumpAsPolygons into Arcgis or OpenJump (if it is just a test, you could add a where clause on tile id). WITH a AS (select ST_DumpAsPolygons(rast