[postgis-users] problem with raster2pgsql

Bborie Park bkpark at ucdavis.edu
Wed Mar 7 08:14:06 PST 2012


Hey Cheryl,

If possible, could you provide a sample raster image so that we can
duplicate what you're seeing.  Since the loader is working for your
hillshade images but not for your aspect or slope images, my guess is
that there is some key difference.

-bborie

On Wed, Mar 7, 2012 at 3:03 AM, cheryl buckley <cheryl.bckl at gmail.com> wrote:
> 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 127.0.0.1 -U admin -d ${DB}
>
> Thanks in Advance
> Cheryl
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu



More information about the postgis-users mailing list