[postgis-users] problem with raster2pgsql

Bborie Park bkpark at ucdavis.edu
Wed Mar 7 13:39:50 PST 2012


I can't say I understand what's going on.  There shouldn't be any issue 
with tile-size differences as that is just a mechanism of how the raster 
is broken down, stored and accessed.

In my testing and production use, performance benefits greatly from 
having smaller tile sizes.  Most if not all my rasters use tile sizes 
smaller than 50x50.


On 03/07/2012 01:17 PM, Cheryl wrote:
> Hi bborie,
> Thankyou for you reply. I ended up solving the problem myself. It was a
> pixel issue. The given pixels in the command line of raster2pgsql didnt
> correlate with the raster image. The raster image was too large for the
> given "-t 100x100". I had to adjust the raster2pgsql command line by
> editing the "-t 100x100" to a larger value of "-t 300x300".
> The images now look as would be expected.
> raster2pgsql -c -s 4326 -I -C ./Hillshade.tif -F -t 100x100 ${TABLE} |
> psql --quiet -h -U admin -d ${DB}
> Thankyou
> Cheryl
> Am 07.03.12 17:14, schrieb Bborie Park:
>> 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 -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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Bborie Park
Center for Vectorborne Diseases
UC Davis
bkpark at ucdavis.edu

More information about the postgis-users mailing list