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-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Bborie Park > Sent: Wednesday, March 07, 2012 4:40 PM > To: postgis-users@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.b...@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@postgis.refractions.net > >>> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > >> > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
