[postgis-users] Problem with postgis raster

[Bborie Park]

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