[postgis-users] problem with raster2pgsql

[Bborie Park]

Yes.  All tiles of a raster will have the same dimensions.  So an edge 
tile would have the same dimensions as every other tile, just that some 
of the tiles have no data.

-bborie

On 03/07/2012 02:40 PM, Pierre Racine wrote:
> 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
> _______________________________________________
> 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