[postgis-users] problem with raster2pgsql

[Pierre Racine]

Does the loader pad the edge tiles when the tiles size is not a divisor of the raster width and height? The old loader did.

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Bborie Park
> Sent: Wednesday, March 07, 2012 4:40 PM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] problem with raster2pgsql
> 
> Cheryl,
> 
> 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.
> 
> -bborie
> 
> 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 127.0.0.1 -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 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
> >>
> >>
> >
> > _______________________________________________
> > 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users