[postgis-users] Problem with postgis raster

[Jason Mathis]

In qgis you should be able to go into the DB manger and see the raster tables.  From there you can drag and drop onto the canvas. I am on 2.2 (valmiera) and can do this just fine. I *think* things were different in past versions and once there was a plugin for postgis raster support; although its not in the repos any longer. 



On May 19, 2014 at 3:54:36 PM, Bborie Park (dustymugs at gmail.com) wrote:

raster2pgsql does not create a "geom" column. You should consider tiling your rasters though with -t WIDTHxHEIGHT.

As for visualizing with QGIS, I have no suggestions. You can do a quick spot-check that the data is present and valid in PostGIS though...

SELECT (ST_SummaryStats(rast)).* FROM public.srtm_test

Compare the stats with that from

gdalinfo --stat C:\picardie-nature\Stage\Qgis\Alti\srtm\srtm_37_02.tif

-bborie


On Mon, May 19, 2014 at 2:26 PM, dandrigo <lcelati at latitude-geosystems.com> wrote:
Dear all,

I tried to import via pgraster2pgsql several DEM raster files.

Below, i paste a screenshot representing my DOS interface :

SS_pg_raster.JPG
<http://postgis.17.x6.nabble.com/file/n5006344/SS_pg_raster.JPG>


After the import, it's impossible to visualize the postgis raster layer via
qgis. And via qgis db manager or pgadmin3, we can notice thaht the import
did not create a geom column. Via qgis db manager, no overview of the layer
is visible.

Below the qgis db manager showing the characteristic of this layer :

qgis_dbmanager.JPG
<http://postgis.17.x6.nabble.com/file/n5006344/qgis_dbmanager.JPG>


I'm working with windows 8 with postgres 9. and postgis 2.1
In advance thank you t othrow light for me.



--
View this message in context: http://postgis.17.x6.nabble.com/Problem-with-postgis-raster-tp5006344.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

_______________________________________________  
postgis-users mailing list  
postgis-users at lists.osgeo.org  
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-- 
 

This transmission contains confidential and privileged information intended 
solely for the party identified above. If you receive this message in 
error, you must not use it or convey it to others. Please destroy it 
immediately and contact the sender at (303) 386-3955 or by return e-mail to 
the sender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140519/9ced2651/attachment.html>