[postgis-users] problem with raster2pgsql

cheryl buckley cheryl.bckl at gmail.com
Wed Mar 7 03:03:14 PST 2012

Hi all,

I have a problem in which I think I need some clarification on.
I have made use of Gdal to produce hill shaded, aspect and slope
images. I wanted to store these raster images into postgis database by
making use of raster2pgsql. I have managed to get the hill shade image
to store into the database and when I then view it in QuantumGIS by
connecting to the postgis database it works and the image looks as
expected. But when I store the aspect or slope images to the database
using raster2pgsql and view it from QuantumGIS the images come out
faulty (they just look plain (flat) with speckles on). When I produce
the aspect and slope images using gdal and then viewing them in QGIS
without storing it to the database first the images look great and as
expected. It is when I first store them using raster2pgsql that the
images are faulty.

Perhaps im suppose to change something in my command line in the
raster2postgis, but I simply just cant figure where the problem lies.

Perhaps someone can give me a hint where im going wrong?

This is the raster2postgis command line i used:

raster2pgsql -c -s 4326 -I -C ./Hillshade.tif -F -t 100x100 ${TABLE} |
psql --quiet -h -U admin -d ${DB}

Thanks in Advance

More information about the postgis-users mailing list